Excel Formula to auto move & populate field

Closed
Report
Posts
1
Registration date
Tuesday August 7, 2012
Status
Member
Last seen
August 7, 2012
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am builidng a spreadsheet that shows progress week by week on two sheets. Weekly Status and Project summary sheets. I am building it so you can select current week on Project summary sheet and it will populate the status for last week and current week in the progress column. This information will come from the Weekly status sheet where this weeks column is highlighted. I want a formula(s) that:

1. Automatically selects the current weeks column on weekly status sheet
2. Populates data highlighted in that column on the Project Summary tab...probably a ='Weekly Status"!columnnumber I presume.


Thanks

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
Please post a very small extract of your data sheets.

do you want a FORMULA or a MACRO