|
Sunday, 26 April 2009 13:06 |
|
I have 4 to 6 excel spreedsheets. I want to automatically sort some of the spreadsheets and copy and populate different tabs with specific data from one tab to the other. I will also like to auto-populate 4 of the spreedsheets with data from other spreadsheets.
First example:
spreadsheet A has 8 tabs
spreadsheet B has 4 tabs
Spreadsheet C has 3 tabs
1. Auto-populate the 4 tabs on spreadsheet B with 4 tabs from spreadsheet A
2. Auto-populate the 3 tabs on spreadsheet C with 3 tabs from spreadsheet A
Second Example:
I have 5 spreadsheets in a folder call daily files
I output 9 spreadsheets from an access file to copy and paste in the 5 spreadsheets in the daily file folder.
I will need you to automatically populate the 5 spreadsheets in the dialy file folder with the 9spreadsheet I output from my access file.
3rd Example:
1. Create a new spread sheet with several tabs.
2. Populate those tabs with specific data from one specific spreadsheet.
Fouth example involves automatically sorting 3-5 sheets and automatically populating the data on another tab or in another sheet.
THIS IS VERY SIMPLE STUFF AND I WILL EXPLAIN IN DETAILS TO THE WINNING BIDDER IN CHAT. THIS IS A JOB FOR A HIGHLY EXPERIENCED EXCEL and ACCESS PROGRAMMER.
|
