Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help buiding a worksheet.
I need some advice on how to build a worksheet that references a previous
sheet and adds a value based on user input. Example: On sheet 1 I have the data in 2 columns. Each column has 20 rows of data. Sheet 1 Column A Column B 1 5 2 12 3 9 Etc...... On sheet 2 I have 3 columns. The user will enter a value from Column A on sheet 1 then will enter a quanity in Column 2 on sheet 2. In column 3 on sheet 2 will be the quanity in colum B on sheet 2 multiplied by the data from Column B on Sheet 1. Sheet 2 Column 1 Column 2 Column 3 (user enters (user enters Coumn 2 value from quanity) times column B Column A on Sheet 1) I think I probably made that confusing, but thanks for any help you can give. Vachoen |
#2
|
|||
|
|||
Sheet1 - Datalist is A2 to B20
Sheet2 - Enter value in A2 - Enter quantity in B2, Enter this formula in C2: =B2*VLOOKUP(A2,Sheet1!$A$2:$B$20,2,0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Vachoen" wrote in message ... I need some advice on how to build a worksheet that references a previous sheet and adds a value based on user input. Example: On sheet 1 I have the data in 2 columns. Each column has 20 rows of data. Sheet 1 Column A Column B 1 5 2 12 3 9 Etc...... On sheet 2 I have 3 columns. The user will enter a value from Column A on sheet 1 then will enter a quanity in Column 2 on sheet 2. In column 3 on sheet 2 will be the quanity in colum B on sheet 2 multiplied by the data from Column B on Sheet 1. Sheet 2 Column 1 Column 2 Column 3 (user enters (user enters Coumn 2 value from quanity) times column B Column A on Sheet 1) I think I probably made that confusing, but thanks for any help you can give. Vachoen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
help! making a worksheet more automated? | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |