searching for a day then populating that column to a new sheet

[JAL_0110]

Hello

I hope someone can assist me. File is attached.

I have a macro running which accesses two hyperlinks, copies the data from these files and pastes it into my file in the "raw data tab".
What I need is for the data for Monday to be put into the "RD MON" tab, the data for Tuesday to be put into the "RD Tue" tab and so on for each day of the week.

There are two sets of data that are imported into the "Raw Data" tab that need to be imported to each of the tabs for each days of the week:
"Res Out by Half Hour Gold ADE60" referred to as Gold Data
"Res Out by Half Hour NonGold ADE60" referred to as Non Gold Data

Gold Data needs to be pasted from B4:B21 in the following tabs "RD Mon""RD Tue""RD Wed""RD Thu""RD Fri""RD Sat""RD Sun"
Non Gold Data needs to be pasted from D4:D21 in the following tabs "RD Mon""RD Tue""RD Wed""RD Thu""RD Fri""RD Sat""RD Sun"

Problem 1:
These hyperlink files are daily reports. They are very simple and look at the confirmed orders, broken down into time periods, for the next 7 days. Because they are run daily the first column of data each day is for the next day. For example if I ran it today (Tuesday), the first column of data would be for Wednesday, then Thursday and so on for 7 days. If I ran the report tomorrow (Wednesday) the first column of data would be for Thursday and then for Friday and so on. So every time I run the macro, it places the data into my spreadsheet.

As the day changes columns every time you upload the file, I cant work out how to make the macro take the 2 columns of data for each day and place it in the relevant columns in that Days Tab.

Any assistance is greatly appreciated.

[jaslake]

Hi JAL_0110

Try this

Please Login or Register  to view this content.

[JAL_0110]

Thank you so much. Code worked brilliantly!!

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.