Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Vachoen
 
Posts: n/a
Default 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   Report Post  
Ragdyer
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
help! making a worksheet more automated? redb Excel Discussion (Misc queries) 2 April 15th 05 01:53 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 04:07 PM


All times are GMT +1. The time now is 12:28 PM.

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

About Us

"It's about Microsoft Excel"