Excel Formula to auto move & populate field

Closed
santelakeway Posts 1 Registration date Tuesday August 7, 2012 Status Member Last seen August 7, 2012 - Aug 7, 2012 at 05:20 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 7, 2012 at 11:54 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 7, 2012 at 11:54 PM
Please post a very small extract of your data sheets.

do you want a FORMULA or a MACRO
0