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
Excel mod apk for pc - Download - Spreadsheets
Excel macro to create new sheet based on value in cells - Guide
Excel marksheet - Guide
Kernel for excel - Download - Backup and recovery

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

Date formatting in dd/mm/yyyy

Toshiba HDD blue light stays on not blinking and it goes off

Similar discussions

Subscribe To Our Newsletter!