Need a VBA Code to refresh data and save the active sheet as a new workbook.

This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

Have you started any work on this project yet?
How far did you get?
Where are you stuck?

We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.

Hi There,

I have currently build the below mentioned macros.
Baiscally the first macro would assign a counter to a specific cell(E4)and this macro needs to loop based on cell(E2)value ie. if E2 = 37, then this macro should run 37 times by assigning value from 1 until 37 to cell E4.

Upon assigning a a counter to Cell E4 in "Control" Sheet, the second macro would
unhide row in "Statment" Sheet and the data is refreshed.

Finally the activesheet ie "Statement" needs to be saved in excel 2003 Version.

The above 3 macros should be consolidated and run multiple times depending upon the
cell value in E2 in "Control Sheet".

Just need a little help to tweak the code and make it work.

Thanks
Krishna

Please Login or Register  to view this content.