Hello All - and a Happy New Year!
I'm try to create a formula that will allow me to (on a new worksheeet in the same workbook) create a list (table/array) of data from multiple worksheets in that workbook.
Information:
The workbook has 5 worksheets (with unique names)
Each worksheet contains an array with the same named headers (14 headers) and additionally Cell A1 contains the name of the worksheet
In one of the columns in those worksheets is one called 'Commissioned'
In that is a cell which contains the text Full or Partial (or is blank) on each individual row
So each individual row in that table that contains 'Partial' I want to pull/extract into that new worksheet (possibly with the 1st new column in that worksheet being the worksheet name)
For info - Each individual row in the worksheets have a unique cell in column field called 'project code' if that helps?
Ping me if you can help or have any questions - Thanks Guys!
I'm try to create a formula that will allow me to (on a new worksheeet in the same workbook) create a list (table/array) of data from multiple worksheets in that workbook.
Information:
The workbook has 5 worksheets (with unique names)
Each worksheet contains an array with the same named headers (14 headers) and additionally Cell A1 contains the name of the worksheet
In one of the columns in those worksheets is one called 'Commissioned'
In that is a cell which contains the text Full or Partial (or is blank) on each individual row
So each individual row in that table that contains 'Partial' I want to pull/extract into that new worksheet (possibly with the 1st new column in that worksheet being the worksheet name)
For info - Each individual row in the worksheets have a unique cell in column field called 'project code' if that helps?
Ping me if you can help or have any questions - Thanks Guys!