Dougie1
Board Regular
- Joined
- Jul 27, 2007
- Messages
- 212
Using Excel 2016
I have a sheet (Sheet1) that contains monthly values in the columns - e.g. column G has the September 2017 values, column H has the October 2017 values etc. all the way through to the August 2018 values in column R.
Each column names the month and year in row 3 and then there is data in each column in rows 5-11.
What I want to do is pull the relevant value through to cells on Sheet2 depending on the current month and year e.g. Currently, I want to pull the values through for January 2018.
So what I am trying to do is set formulas on Sheet2, in cells F3 to F8 that will identify the current month and year – then find this month and year in row 3 of Sheet1 and pull the value from row 5 to cell F3 on Sheet2, pull the value from row 6 to F4 on Sheet2 and so on down to F8.
Can anyone help please?
TIA
Dougie
I have a sheet (Sheet1) that contains monthly values in the columns - e.g. column G has the September 2017 values, column H has the October 2017 values etc. all the way through to the August 2018 values in column R.
Each column names the month and year in row 3 and then there is data in each column in rows 5-11.
What I want to do is pull the relevant value through to cells on Sheet2 depending on the current month and year e.g. Currently, I want to pull the values through for January 2018.
So what I am trying to do is set formulas on Sheet2, in cells F3 to F8 that will identify the current month and year – then find this month and year in row 3 of Sheet1 and pull the value from row 5 to cell F3 on Sheet2, pull the value from row 6 to F4 on Sheet2 and so on down to F8.
Can anyone help please?
TIA
Dougie