Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with 2 sheets with data to work together
I have two worksheets. One is named order the other is inventory. Inventory
has info in a-g, numbered down 4-400. I want to enter a number in sheet order 4-400 and it pulls all the info from inventory sheet a-g and automatically fills it in just by inputing one of the numbers in a4-a400. Is it possible and can anyone help me with it. I just can't seem to get the formulas right. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with 2 sheets with data to work together
Please give me a green tick if you like this!
1 sheet INVENTORY. Insert a new column A, before all your other data, and call it "Ref". You now have 8 columns A:H. 2 in cell A4 and all the cells below, use the formula =ROW() inventory. I am using this like a reference for your row. 3 you now have something like this: INVENTORY Ref col1 col2 col3 col4 etc =ROW() =ROW() =ROW() 4 in sheet ORDER, let's imagine that cell A3 is the cell where you want to type a row number, and have data pulled into cells B3:H3 from INVENTORY based on the row number you type in. Cell A3 is blank at first Cell B3 formula is =VLOOKUP($A3,INVENTORY!$A:$H,COLUMN(),0) You can extend this across to cells C3:H3. When you type a value into cell A3, cells C3:H3 will display the relevant data for that row from INVENTORY. If you have not quite used the same 8 columns as me, you should just play with that COLUMN() number. This tells excel how many columns to count across from column A before it reports back the value it is looking for. You can maybe use COLUMN()+1, or COLUMN()-3 etc Try this first and reply if it doesn't give you what you need. -- Allllen "moochx5" wrote: I have two worksheets. One is named order the other is inventory. Inventory has info in a-g, numbered down 4-400. I want to enter a number in sheet order 4-400 and it pulls all the info from inventory sheet a-g and automatically fills it in just by inputing one of the numbers in a4-a400. Is it possible and can anyone help me with it. I just can't seem to get the formulas right. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
transfer data in excel between sheets | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pie Diagram from data across multiple work sheets | Charts and Charting in Excel | |||
How do I transfer data between Excell sheets? | Excel Worksheet Functions |