Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
connecting multiple cells to new sheet (VLOOKUP?IF?)
Hi I am trying to find a way to pull certain data off an existing worksheet and onto a new sheet. I don't think I need a macro and can do it through VLOOKUP or an IF function. Would be good if someone could give me some help on this. Essentially I want to pull the data in columns A, B and I on the existing sheet into a new worksheet. But I only want to pull those cells when in column H it says 2. So i guess Im saying in the new worksheet, pull data in columns A,B and I, only if in column H it says 2. (obviously it would then pull those three columns into columns A,B and C in the new worksheet!). If anyone could give me a hand, I would be most grateful. Many thanks for your time, Greg. -- Gregula ------------------------------------------------------------------------ Gregula's Profile: http://www.excelforum.com/member.php...o&userid=37728 View this thread: http://www.excelforum.com/showthread...hreadid=573162 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
connecting multiple cells to new sheet (VLOOKUP?IF?)
Well, you could write a formula, say =IF(sheet1!H2=2,sheet1!A1,"")
etc. -- Brevity is the soul of wit. "Gregula" wrote: Hi I am trying to find a way to pull certain data off an existing worksheet and onto a new sheet. I don't think I need a macro and can do it through VLOOKUP or an IF function. Would be good if someone could give me some help on this. Essentially I want to pull the data in columns A, B and I on the existing sheet into a new worksheet. But I only want to pull those cells when in column H it says 2. So i guess Im saying in the new worksheet, pull data in columns A,B and I, only if in column H it says 2. (obviously it would then pull those three columns into columns A,B and C in the new worksheet!). If anyone could give me a hand, I would be most grateful. Many thanks for your time, Greg. -- Gregula ------------------------------------------------------------------------ Gregula's Profile: http://www.excelforum.com/member.php...o&userid=37728 View this thread: http://www.excelforum.com/showthread...hreadid=573162 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Replacing sheet reference in multiple cells... | Excel Worksheet Functions | |||
Change scales from reference cells value for a chart in a separate sheet | Charts and Charting in Excel | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |