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
|
|||
|
|||
Macro or Lookup? Not sure where to start.
I have created two worksheets:
1) Auction Items Item# Table# Location# ItemDescription WinBid are the headers of the data. 2) Bidders Bidder# FirstName LastName I would like to be able to create a macro or something that will allow me to enter the item#, bidder# and winning bid price and have a sheet filled with. ie. Item# 2 (Handcrafted Table) Bidder# 12 (John Doe) Winning Bid $250 Can excel pull from two sheets and created another sheet with all the final details? I am a little new to excel (version 2000) it is the only tool/application available to us at this time. If anyone can point me in the right direction it will be a great help. Thanks dD |
#2
|
|||
|
|||
Macro or Lookup? Not sure where to start.
DoubleD;
Create your table thusly(suggested format) First Last ID Item Table Location ItemDesc Bid Concatenate Enter your bidder information. In the Concatenate field type the following; =concatenate(a1," ",b1) This will combine the bidders first and last name. Drag this formula down the column as needed. In cell J2 type; =max(h2:h10) Create a form that has fields named what you like and add pics, etc. Now, Next to the cell that says name enter this: =IF(LOOKUP(J2,H2:H10)=J2,LOOKUP(J2,H2:H10,I2:I10), "") This is your first and last name. In the cell next to Bidder# type; =IF(LOOKUP(J2,H2:H10)=J2,LOOKUP(J2,H2:H10,c2:c10), "") This is your Bidder #. Next to the cell that is labeled Winning Bid type; =j2 I think that's right. Post back if it throws an error. God Bless Frank Pytel "DoubleD" wrote: I have created two worksheets: 1) Auction Items Item# Table# Location# ItemDescription WinBid are the headers of the data. 2) Bidders Bidder# FirstName LastName I would like to be able to create a macro or something that will allow me to enter the item#, bidder# and winning bid price and have a sheet filled with. ie. Item# 2 (Handcrafted Table) Bidder# 12 (John Doe) Winning Bid $250 Can excel pull from two sheets and created another sheet with all the final details? I am a little new to excel (version 2000) it is the only tool/application available to us at this time. If anyone can point me in the right direction it will be a great help. Thanks dD |
Thread Tools | |
Display Modes | |
|
|