Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Smart" Copy
My set of data looks like this:
VendorNbr Amount 1000 $900 $750 $500 1120 $600 1500 $700 $800 I want the data in a more "tabular" format, so I'm hoping to copy each vendor number down to the next populated cell, and repeat the process all the way down (about 9,000 rows). Doing this the manually for 9,000 rows isn't a real option. Is there some code that could automate this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
Question about "smart" text comparing | Excel Programming |