Extreme Beginner (Macros) - Need Macro with Date Form to transfer data

[jesspbarnett]

Hello!

I am a new analyst and I am trying to make a report at my work more accurate and free of human error.

I have one worksheet which is a template (we use this template every day and we save under the current date) before saving we must update this template with the current date's Forecasting numbers. We have another 2 workbooks with the month's forecasts (1 for each client we service). For example we have "Client A March 2017 Forecast" and "Client B March 2017 Forecast" in each of these there are 4 sheets (they have call center stats "NCO" "AHT" "Open" "Closed") each sheet has a heading on row1 with the date and from row 2 to 34 it has numbers.

We need to locate the date, then copy from row 2 to 34 and paste in the Template file under the Forecast cells.

I remember there was a way before when we opened the file, we got a pop up asking us to insert today's date and the macro would fill in the forecasts for us. However, this file has been deleted and the person who created it no longer works with us.

Any idea what I need to do for this? I've been googling and searching YouTube to no avail. If you can at least let me know what to google, that would be helpful.

Thanks!

 

[Joe4]

Cross posted here: Extreme Beginner (Macros) - Need Macro with Date Form to transfer data

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.