Hi,
I'm very new to programming and have a task at work which is very repetitive and time consuming and I'm sure there must be a way to automate it.
On the attached are a list of example fund manager trades. I copy each group of trades belonging to a fund manager, paste this data into a template spreadsheet already open and save as eg Aberdeen Unit Trust Managers Limited Transactions.xls.
I dont know where to start really...any help would be much appreciated?
Cheers
'SHEET1 TO MANY WORKBOOKS
Here's a macro for parsing rows of data from one sheet to many workbooks named for the same values.My macro names the workbooks for values in the column PLUS today's date, you can take a stab at removing the date part...or leave it in, it's a good technique.
To work on your sheet, just edit the colored values to match your layout:
Please Login or Register to view this content.
Last edited by JBeaucaire; 11-08-2010 at 02:55 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks