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

Excel blinking cell without macro
Spell number in excel without macro - Guide
Macros in excel download - Download - Spreadsheets
Excel date format dd.mm.yyyy - Guide
Excel macro to create new sheet based on value in cells - Guide
Excel free download - Download - Spreadsheets

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.

SOS
Jul 6, 2011 at 03:39 AM

thanks rizvisa1, it took me till midnight 4 hours but I finally worked it out.

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!!

Similar discussions

Lenovo Laptop blinking keys but no display

How to use conditional format based on text?

No display on monitor, light blinks

Excel make cell flash red

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!