Previous Topic Next Topic

Excel Office2007 macro

Solved/Closed
SOS - Jul 2, 2011 at 05:47 AM
rizvisa1 Posts 4478 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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
SOS
Jul 6, 2011 at 03:39 AM
thanks rizvisa1, it took me till midnight 4 hours but I finally worked it out.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 6, 2011 at 08:09 AM
Well thanks for feedback. Who says hard work does not pay off :)
Cheers!!
0

Similar discussions

Lenovo Laptop blinking keys but no display
What123What -
What123What -

5 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Blue light blinking every second
Lakshit -
nathanwirth -

2 responses