Copy data from sheet1 column with dynamic date, and copy data to second sheet column

[Renaliiii]

I posted a problem last week, but as most of the time it is, the easiest solution was the best. A button!


I am creating a button with a VBA macro to pull data from a column of numbers N3:N36 on sheet1(Weekly) with a header specified by the current days week ending date(as weeks ending on Friday) =TODAY()+(5-WEEKDAY(TODAY(),2)) so for this week it shows 5/27/2016 as the header for the column.


I would like to copy -> paste this data into a correlating column on sheet2 (Calculation) finding the next column with the matching date as the header (I will pre-fill in each column header for all 52 weeks). So for this weeks data it would pull all the numbers in column N3:N36 with the header 5/27/2016 as defined by our date function and input it into the column with the header 5/27/2016 on sheet2(Calculation).


I need this function so that I can compound the data entered each week to get a month to date and year to date cumulative total. I would like the defining factor to be the date, so that the macro doesn't just insert data into the next empty column and possibly input data more than one time(I'll be using simple autosums every 4-5 weeks to determine monthly totals).


I can attach a dummy workbook, or work off of one provided by you.


Thank you for any and all help you can provide. I would love to find a solution to this problem.

[dflak]

A sample workbook would be greatly appreciated. It will serve two purposes: It will help visualize the requirement better and it will encourage people to work on it since they won't have to create the workbook before starting to work on it.

[Renaliiii]

http://imgur.com/a/Xk50I

I have attached a link to an imgur album with an exact example of what it is im trying to accomplish.

I would post the workbook, but it has employee names on it. So I would in essence be creating a new workbook when the pictures should suffice for what I'm needing.

[dflak]

Well, I am still not going to set up a workbook to work on this. I suggest you change the employee names in the version you attach.

[Renaliiii]

I didn't expect you were going to work on it to begin with by your original statement of "encourage others". But I apologize if my reply about the pictures sounded snarky. Here is a butchered workbook. I am not concerned with any of the formulas working except for the week ending date in N3, so if anything else is messed up by my deleting of info just now I will rework it. How can I attach the workbook?

[dflak]

Click on Go Advanced. Go to Manage attachments, click on the Browse button and navigate to the file. Click Upload and when it uploads, leave the page and then Submit Reply.

[IonutC]

post the excel and we can help. should be easier to do ,if you want to copy all the time the same column to a different one.