If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Input" data sheet
Have a "customer" cell on an "input' sheet that will
determine which row on the data worksheets the information will be placed into. The "customer" cell gets a customer name through a vlookup on "input" sheet. Have a table/grid (13 columns x 20 rows) on "input" sheet that you enter numbers into. Need to have data from the input sheet, transferred to 20 data worksheets (all data sheets have the same layout) although different layout to table/grid on "input" sheet. Each row in table/grid goes to a separate worksheet but there is an additional column on each worksheet separating adjacent data on the table/grid. Once you finish entering customer data into input sheet, you change customer number and commence entering next customer's data. Customer's data remains in the data worksheets until you re-enter new data for this customer. Many thanks Kev |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2000 "Dead" Chart Links | Phoenix | Charts and Charting | 4 | September 16th, 2004 07:51 PM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Auto-populating data from one sheet to another | Steph | Worksheet Functions | 1 | March 29th, 2004 01:15 AM |
exporting/linking data from a row on one sheet into another sheet | Clark haddock | Worksheet Functions | 1 | February 2nd, 2004 03:25 PM |