Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping down list and each time copying to another worksheet
Hi all,
I'm a newbie to VBA and need a solution to the following problem if possible. I have a worksheet that summarises another using sumproducts etc and displays info for one account at a time whereas the main report displays all accounts. I need some vba code that will loop down the list of account numbers on the main worksheet and each time do the following: 1) Copy account number to summary worksheet 2) Copy summary worksheet to new workbook and name workbook by account number 3) Copy paste value for worksheet so that it has no links. 4) Repeat for each account number. It sounds like a very complicated macro would be needed - is this possible? Thanks in advance. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a Filter list to a new worksheet. | Excel Worksheet Functions | |||
Copying more that one Worksheet at a time. | Excel Discussion (Misc queries) | |||
Copying Data List to Different Worksheet | Excel Discussion (Misc queries) | |||
building a text string while looping though a worksheet | Excel Programming | |||
Nested Looping with Tests, Row Copying Macro | Excel Programming |