Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula needed
Hello,
Office '03 (Excel), Glass Order! (sheet tab) A1:W1 is my header row. The data range on this worksheet is currently A2:W237. Information is added daily, so the formula will need to have a dynamic range. I would like a formula that does something like the following. If any cell in column T of the Glass Order sheet tab 0, then send that row's information to the only other sheet tab in this workbook (RMA!), which has the same format as Glass Order! (header row A1:W1...other than the header row this worksheet is currently empty, but after this formula will need to be dynamic also....by adding each new row's information underneath the last ones) I believe I'll need a vlookup formula to do this, but am not able to get it right...a little help with the formula would be great! Once I have a formula, where do I put it? And how should I copy it across the range? fill handle? Please help and let me know if I need to better describe what I'm looking for or if you need more information. TIA~ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula needed
Can you not use Data=AutoFilter on column T and then copy/paste?
Record as macro for future updates? "olrustyxlsuser" wrote in message ... Hello, Office '03 (Excel), Glass Order! (sheet tab) A1:W1 is my header row. The data range on this worksheet is currently A2:W237. Information is added daily, so the formula will need to have a dynamic range. I would like a formula that does something like the following. If any cell in column T of the Glass Order sheet tab 0, then send that row's information to the only other sheet tab in this workbook (RMA!), which has the same format as Glass Order! (header row A1:W1...other than the header row this worksheet is currently empty, but after this formula will need to be dynamic also....by adding each new row's information underneath the last ones) I believe I'll need a vlookup formula to do this, but am not able to get it right...a little help with the formula would be great! Once I have a formula, where do I put it? And how should I copy it across the range? fill handle? Please help and let me know if I need to better describe what I'm looking for or if you need more information. TIA~ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula needed
Can you not filter on Column T (0) and then copy/paste the data to RMA?
Record this as a macro for future updates. "olrustyxlsuser" wrote: Hello, Office '03 (Excel), Glass Order! (sheet tab) A1:W1 is my header row. The data range on this worksheet is currently A2:W237. Information is added daily, so the formula will need to have a dynamic range. I would like a formula that does something like the following. If any cell in column T of the Glass Order sheet tab 0, then send that row's information to the only other sheet tab in this workbook (RMA!), which has the same format as Glass Order! (header row A1:W1...other than the header row this worksheet is currently empty, but after this formula will need to be dynamic also....by adding each new row's information underneath the last ones) I believe I'll need a vlookup formula to do this, but am not able to get it right...a little help with the formula would be great! Once I have a formula, where do I put it? And how should I copy it across the range? fill handle? Please help and let me know if I need to better describe what I'm looking for or if you need more information. TIA~ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula needed
Toppers,
I've created the macro. I thought there may be a way to do this via a lookup to help automate it a bit more, but the macro works too. Thank you, John "toppers" wrote: Can you not use Data=AutoFilter on column T and then copy/paste? Record as macro for future updates? "olrustyxlsuser" wrote in message ... Hello, Office '03 (Excel), Glass Order! (sheet tab) A1:W1 is my header row. The data range on this worksheet is currently A2:W237. Information is added daily, so the formula will need to have a dynamic range. I would like a formula that does something like the following. If any cell in column T of the Glass Order sheet tab 0, then send that row's information to the only other sheet tab in this workbook (RMA!), which has the same format as Glass Order! (header row A1:W1...other than the header row this worksheet is currently empty, but after this formula will need to be dynamic also....by adding each new row's information underneath the last ones) I believe I'll need a vlookup formula to do this, but am not able to get it right...a little help with the formula would be great! Once I have a formula, where do I put it? And how should I copy it across the range? fill handle? Please help and let me know if I need to better describe what I'm looking for or if you need more information. TIA~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup formula needed? | Excel Worksheet Functions | |||
VLOOKUP Help Needed | Excel Discussion (Misc queries) | |||
vlookup vs. if, help needed | Excel Worksheet Functions | |||
VLOOKUP help needed! | Excel Worksheet Functions | |||
Vlookup Help Needed | Excel Discussion (Misc queries) |