Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I?
Hi all
I want to collect figures from several worksheets and display them in set boxes on another worksheet that will act as a template. I have a sheet with say 50 people on each on their own line. In several colums their are amounts. I want to move a specific amount to a set static cell in a completely different worksheet.? In this new worksheet I want to bering in figures from other worksheets for each employee (to be done one at a time) Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I?
Steven --
Not exactly sure what you're trying to do, but to bring a value from one worksheet to another, here's how. Let's say you want a value (number or text) to update automatically from A1 in Sheet 1 to B2 in Sheet 2. In the 'target' cell -- Sheet2!B2, type: ='Sheet1'!A1 HTH "Steven" wrote: Hi all I want to collect figures from several worksheets and display them in set boxes on another worksheet that will act as a template. I have a sheet with say 50 people on each on their own line. In several colums their are amounts. I want to move a specific amount to a set static cell in a completely different worksheet.? In this new worksheet I want to bering in figures from other worksheets for each employee (to be done one at a time) Thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I?
I have a few sheets with data in columns.
I want to bring that data into a new worksheet which has specific fields for the data to go into. I need to do this repetitive procedure for lots of employees (each one has a seperate employee number) I thouhg tif I could get it set up to bring in data from cells in the master sheets I could then just change the employee number lookup reference and then it would bring in all the data for that employee. Sheet A Gross Pay smith 12.00 jones 234.98 williams 89.27 brown 112.83 Sheet B Tax smith 14.00 jones 12.00 williams 4.50 brown 4.27 Sheet C NI smith 2.40 jones 4,56 williams 7.00 brown 3.46 Sheet D Gross Pay xx Tax xx NI xx I want to have a sheet D for each employee. You get my jist? "pdberger" wrote in message ... Steven -- Not exactly sure what you're trying to do, but to bring a value from one worksheet to another, here's how. Let's say you want a value (number or text) to update automatically from A1 in Sheet 1 to B2 in Sheet 2. In the 'target' cell -- Sheet2!B2, type: ='Sheet1'!A1 HTH "Steven" wrote: Hi all I want to collect figures from several worksheets and display them in set boxes on another worksheet that will act as a template. I have a sheet with say 50 people on each on their own line. In several colums their are amounts. I want to move a specific amount to a set static cell in a completely different worksheet.? In this new worksheet I want to bering in figures from other worksheets for each employee (to be done one at a time) Thanks |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I?
Steven
I think you want to use LOOKUP functions. Excel has good help, but here's a start. If Sheet A holds gross pay, Sheet B holds tax, then Sheet D would look like: A B C 1 Name Pay Tax 2 Smith Cell B2: =VLOOKUP(A2,'Sheet1'!$A$2:$B$100,2,FALSE) Cell C2: =VLOOKUP(A2,'Sheet2'!$A$2:$B$100,2,FALSE) you'd adjust the A2:B100 range to whatever is the employee list. HTH "Steven" wrote: I have a few sheets with data in columns. I want to bring that data into a new worksheet which has specific fields for the data to go into. I need to do this repetitive procedure for lots of employees (each one has a seperate employee number) I thouhg tif I could get it set up to bring in data from cells in the master sheets I could then just change the employee number lookup reference and then it would bring in all the data for that employee. Sheet A Gross Pay smith 12.00 jones 234.98 williams 89.27 brown 112.83 Sheet B Tax smith 14.00 jones 12.00 williams 4.50 brown 4.27 Sheet C NI smith 2.40 jones 4,56 williams 7.00 brown 3.46 Sheet D Gross Pay xx Tax xx NI xx I want to have a sheet D for each employee. You get my jist? "pdberger" wrote in message ... Steven -- Not exactly sure what you're trying to do, but to bring a value from one worksheet to another, here's how. Let's say you want a value (number or text) to update automatically from A1 in Sheet 1 to B2 in Sheet 2. In the 'target' cell -- Sheet2!B2, type: ='Sheet1'!A1 HTH "Steven" wrote: Hi all I want to collect figures from several worksheets and display them in set boxes on another worksheet that will act as a template. I have a sheet with say 50 people on each on their own line. In several colums their are amounts. I want to move a specific amount to a set static cell in a completely different worksheet.? In this new worksheet I want to bering in figures from other worksheets for each employee (to be done one at a time) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|