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 Sheet" template
"Input sheet" that distributes data to other worksheets.
I wish to create an "input template" that based on the name in a "customer" cell it should place the data in that customer's row on various worksheets. This data needs to be retained on those worksheets even when a new "customer" information is used on the "input sheet". Does such a function exist or am I about to learn VBA? |
#2
|
|||
|
|||
You are about to learn vba. You will need a macro that takes the info from
that cell or row and transfers to the next available, or specific, row(column) for the specific customer. Post back with more details and someone will assist. -- Don Guillett SalesAid Software "Kev" wrote in message ... "Input sheet" that distributes data to other worksheets. I wish to create an "input template" that based on the name in a "customer" cell it should place the data in that customer's row on various worksheets. This data needs to be retained on those worksheets even when a new "customer" information is used on the "input sheet". Does such a function exist or am I about to learn VBA? |
#3
|
|||
|
|||
Have a "customer" cell on "input' sheet that will
determine which row on the data worksheets the information will be placed into. This "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 -----Original Message----- You are about to learn vba. You will need a macro that takes the info from that cell or row and transfers to the next available, or specific, row(column) for the specific customer. Post back with more details and someone will assist. -- Don Guillett SalesAid Software "Kev" wrote in message ... "Input sheet" that distributes data to other worksheets. I wish to create an "input template" that based on the name in a "customer" cell it should place the data in that customer's row on various worksheets. This data needs to be retained on those worksheets even when a new "customer" information is used on the "input sheet". Does such a function exist or am I about to learn VBA? . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Getting info from a template (to a Sheet as a batabase) | oriollobet | General Discussion | 1 | September 26th, 2004 04:53 AM |
New Date-New Sheet | [email protected] | Worksheet Functions | 1 | May 1st, 2004 06:41 PM |
Sheet copy with absolute reverence | Peo Sjoblom | Worksheet Functions | 0 | November 17th, 2003 08:16 PM |
Balance Sheet Template | ying | Setting up and Configuration | 1 | October 18th, 2003 07:21 AM |