Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey guys I have a very limited knowledge in visual basic and i need some
help..........I would like some sort of macro that will take the data in an entire row that I specify and copy that row and paste that exact row and format into each row below it that contains a certain value in a column............for example: I have an excel sheet and in row 1 I have a lot of data, I need to be able to search all of the data in the rows below it for the letter "D" and every cell in the A colomn that has the letter "D" I need to paste the data from Row 1 into that any row below it containing "D".......but the rows also contain the letters "F" "G" "H" and I dont want the macro pasting row 1 into any of those other rows that contain any other letters.....there is around 6000 rows in all and I really do not want to do each individually by hand and my visual basic skills are slim to none.....hope you guys can help...........thanx *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
anyway to make a macro for all of excel | Excel Discussion (Misc queries) | |||
how do I debug my Excel macro & make it actually WORK? | Excel Programming | |||
How do you cut a paste a macro or VB language in Excel and make it | Excel Programming | |||
Macro to make excel close | Excel Programming | |||
Make a macro run automatically in Excel 03??? | Excel Programming |