Sabealgo
asked on
copying info from one worksheet to another
Hello,
I am trying to create a summary (publishable) worksheet with certain data from a master worksheet. The master worksheet contains a continually evolving list of products and their scheduled release date. As products are released to the market, the master worksheet is updated to reflect the actual release date.
Our business partners are asking us to provide them with periodic updates about upcoming releases, projected release dates and their actual release dates.
As noted above, I would like to create a worksheet (within the same Excel file) that will hold various pieces of information contained on the master file. I would like the summary worksheet, if possible via formulas or macro(s), to be updated either dynamically or by executing a process.
The update needs to include product releases that have already been reported (reflecting an updated projected release date, and eventually the actual release date). It should also include any new entries to the master list.
While some of our products are scheduled within the next 30 - 120 days, some are like 'pie in the sky' products that are on the radar, but with no release date. Therefore I would like to limit the updates to existing plus the next three months, ignoring anything further out. In the sample attached, the summary report could only report the month of expected release. the Expected Submission date sometimes is completed with either an actual date or just the month. For the purposes of uniformity, in the summary I could report just the month.
I have struggled with this for about three days now, trying to determine if a series of formulas, including ranges, would get me to my solution or if a macro would be better.
Any guidance or help would be much appreciated.
Sample-data.xls
I am trying to create a summary (publishable) worksheet with certain data from a master worksheet. The master worksheet contains a continually evolving list of products and their scheduled release date. As products are released to the market, the master worksheet is updated to reflect the actual release date.
Our business partners are asking us to provide them with periodic updates about upcoming releases, projected release dates and their actual release dates.
As noted above, I would like to create a worksheet (within the same Excel file) that will hold various pieces of information contained on the master file. I would like the summary worksheet, if possible via formulas or macro(s), to be updated either dynamically or by executing a process.
The update needs to include product releases that have already been reported (reflecting an updated projected release date, and eventually the actual release date). It should also include any new entries to the master list.
While some of our products are scheduled within the next 30 - 120 days, some are like 'pie in the sky' products that are on the radar, but with no release date. Therefore I would like to limit the updates to existing plus the next three months, ignoring anything further out. In the sample attached, the summary report could only report the month of expected release. the Expected Submission date sometimes is completed with either an actual date or just the month. For the purposes of uniformity, in the summary I could report just the month.
I have struggled with this for about three days now, trying to determine if a series of formulas, including ranges, would get me to my solution or if a macro would be better.
Any guidance or help would be much appreciated.
Sample-data.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. Sometimes the easy answers are covered by complication.
Much appreciated.