Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Hi
I am trying to find a way to pull certain data off a particular sheet onto a new sheet. I don't think I need a macro and can do it through VLOOKUP or a 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 into a new worksheet. But I only want to pull these 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. If anyone could give me a hand, I would be most grateful. Many thanks for your time, Greg. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
Linking cells | Excel Worksheet Functions | |||
Use TREND function with nonadjacent cells | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |