Excel Office2007 macro

Solved/Closed
SOS - Jul 2, 2011 at 05:47 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 6, 2011 at 08:09 AM
Hello,
I writting a macro to clean up the format of a report down loaded into excel. I'm stuff on on section. I have filter column A for blank cells. I need a code to move and data in column B into the Blank cells in Column A. I need this to be a loop until no more data is in column B.
Appreciate any help

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 2, 2011 at 08:24 AM
Could you post a sample workbook with some sample data on some shared site and post back the link here. In that sample book please show how the data is right now and how you would like to see it post run of macro.
0
thanks rizvisa1, it took me till midnight 4 hours but I finally worked it out.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 6, 2011 at 08:09 AM
Well thanks for feedback. Who says hard work does not pay off :)
Cheers!!
0