I need help with a formula. I have a master spreadsheet with different company names on it. I have been asked to create a system where the data from each individual company is automatically separated and transfered to another separate Excel file.
For example, my current spreadsheet has 102 different company names followed with attached data such as date it was entered and so on. I need to set up something so that when I enter info on my master spreadsheet, it will automatically sort by company name and transfer to a separate Excel file. In the end I should have 102 different company files with attached info.
Any help would be appreciated.
2006-11-13 01:13:10 · 5 answers · asked by Denny M 3 in Computers & Internet ➔ Software
And...
Here is the solution
I will be glad to create that (Excel - Macros) technique for you.
I love doing these stuff, and actually enjoy it.
So,
If you like, send me your e-mail address through Y! Abswers here, and other details to send you the file that will do the trick.
Trust me I did alot of these for other Y! Answers members before just for fun.
Info will be needed are:
- Do you have these companies info in a table (Means Col A, Name, Col B, Date) and etc?
- Do you have a col with company numbers?
- Do you want the name of the created files with comany number or company name?
- And more will come after starting the file.
Enjoy my profile, I am the VBAXLMan
2006-11-13 20:59:58 · answer #1 · answered by Anonymous · 0⤊ 0⤋
I agree with Topher. Bring the data into a database. Then, you can create different reports to show the data you want. You can then export the data if you need to, or complete calculations in the reports. You can use the report wizard to create different groupings (by companies). I do not think that you actually need to go into Macros. Just think outside of the box to get what you need. Work smarter, not harder.
2006-11-13 10:43:56 · answer #2 · answered by Jame 3 · 0⤊ 0⤋
It seems easy enough, but without specifics, it's kind of hard to answer.
You definitely have to create a Macro (and a bunch of functions) that will do the job.
The real question is: Why do you want to create 1 Excel file per client? Maybe it would indeed be easier to put all that information into a database.
2006-11-13 01:20:37 · answer #3 · answered by stargate_jumper 3 · 1⤊ 0⤋
Eric is right. You need to create macros and functions. Try the mid function to sort the company names. Macros to copy onto separate files. Remember to make everything global.
2006-11-13 01:32:38 · answer #4 · answered by Sharon L 1 · 0⤊ 0⤋
With that much data, have you tried Access. You can always import excel spreadsheets.
2006-11-13 01:16:19 · answer #5 · answered by Topher 1 · 1⤊ 0⤋