| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to find, copy, and paste until value change
On an imported worksheet I have a column that is mostly blanks with a company
number when the report changes. I would like a macro to go to the first filled in cell, copy it and paste it into every subsequent blank cell until the next company then copy and paste, etc to the bottom row. Ex: Row-Value 1 2 3 - A 4 5 6 - B Copy "A", paste to rows 4 and 5, copy "B", paste to following blank cells, etc. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| change from copy & paste task pane (yuk) to c&p little box | Excel Discussion (Misc queries) | |||
| Copy & Paste macro | Excel Worksheet Functions | |||
| Copy Paste Special Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
