SteveG
11-21-2007, 08:30 AM
Hello,
I have data that is imported into an Excel file that contains information for several clients. Within that same file I have a worksheet that calculates out different statistics for each client based on a user selecting the client from a drop down in cell A12. This involves a ton of formulas to calculate the data based on client. Additionally, the data being imported contains a lot of information I don't need. What I'd like to do is be able to copy and paste the data from the import sheet to a calc sheet based on different criteria.
1) Client ID in A12 of Calc sheet found in column C of import data sheet matches.
2) Only if data in column D of import data sheet matches one of 63 criteria identifed as a Named Range "Transactions".
3) Insert data beginning on A17 of Calc Sheet
The import sheet range is A:L and the destination range for the Calc sheet is A17:L65536.
So, the user selects the Client ID in A12 and clicks a button to import the data for that client from the import sheet. I'm not exactly sure where to start on this one. Any help would be appreciated!
Steve
I have data that is imported into an Excel file that contains information for several clients. Within that same file I have a worksheet that calculates out different statistics for each client based on a user selecting the client from a drop down in cell A12. This involves a ton of formulas to calculate the data based on client. Additionally, the data being imported contains a lot of information I don't need. What I'd like to do is be able to copy and paste the data from the import sheet to a calc sheet based on different criteria.
1) Client ID in A12 of Calc sheet found in column C of import data sheet matches.
2) Only if data in column D of import data sheet matches one of 63 criteria identifed as a Named Range "Transactions".
3) Insert data beginning on A17 of Calc Sheet
The import sheet range is A:L and the destination range for the Calc sheet is A17:L65536.
So, the user selects the Client ID in A12 and clicks a button to import the data for that client from the import sheet. I'm not exactly sure where to start on this one. Any help would be appreciated!
Steve