Hi there - I am after some advice on how to look at setting something up. Not really sure if Index/Match is the right way to go or if it would work?
I have a worksheet (A) that tracks everyday work items that have KPI due dates - all have a 'type' that uses vLookUp and other formulas that calculate the KPI dates. This is used daily.
Within the same workbook a different report may only require some certain 'type' and use say the first 4 columns info with additional columns for other information to have further input. I would like to keep this on a separate worksheet (B).
Is there a way to auto populate the worksheet (B) with the duplicate columns from worksheet (A)?
So if worksheet (A) had 'type' = 'apple', 'orange', 'pear'
worksheet (B) only required the 'apple' types + columns 2, 3, and 4 copied for each row it occurred for.
Hope this makes sense?! Any help would be greatly appreciated.
Many thanks, Helen.
I have a worksheet (A) that tracks everyday work items that have KPI due dates - all have a 'type' that uses vLookUp and other formulas that calculate the KPI dates. This is used daily.
Within the same workbook a different report may only require some certain 'type' and use say the first 4 columns info with additional columns for other information to have further input. I would like to keep this on a separate worksheet (B).
Is there a way to auto populate the worksheet (B) with the duplicate columns from worksheet (A)?
So if worksheet (A) had 'type' = 'apple', 'orange', 'pear'
worksheet (B) only required the 'apple' types + columns 2, 3, and 4 copied for each row it occurred for.
Hope this makes sense?! Any help would be greatly appreciated.
Many thanks, Helen.