A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Input" data sheet



 
 
Thread Tools Display Modes
  #1  
Old November 3rd, 2004, 12:15 PM
Kev
external usenet poster
 
Posts: n/a
Default "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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.