I recieve a file every month that requires me to it clean up before
can us it in a pivot table. One of the things I am required to do i
copy data into blank cells, for example. In the following table
would be requred to copy into row 2 and 3 what is on row 1 in columns
and B. Then I would copy what's on row 4 column A and B onto line 5..
and so on. Is there a macro that would do this for me?

Spreadsheet column

A B C
1 Mr. Jones 9483 $3,434
2 $ 524
3 $3,200
4 Ms. Black 1052 $1,255
5 $ 251
6 Mr. Smith 2254 $ 553
7 Ms. James 5855 $ 651
8 $1,221
9 $9,33

--
Message posted from http://www.ExcelForum.com