Creating 3 new sheets & then pull data from a file name to create a date

Wow,

That is so good and so fast. Just blown away. Thank you so much !!

Once tiny glitch is that on the "real" raw data sheet I just realized that there is a bottom row of data that I don't require, but as some of it is numerical it is effecting the summary total amount. Is there a way to get the macro to ignore that very bottom row of data in the raw data sheet ?

Cheers

Jon

Yeah, it was a odd chance occurance that in this string at the bottom it happened to have "Approved" in the right column to copy to the "Approved" sheet.

Dont worry, I managed to cobble a fix together by asking the original sheet to search for the last cell in Column A (which is the one causing the problem) and then clearing that cell before it performs the adding sheets action. Works great now.

Thanks so much for your help. I have learnt so much in the last week just by trying to decipher the code you produced.

Cheers

Jon

Hi

I just found a small issue with the code, which I am sure I can sort out myself, I just need clarification on one part:-

Please Login or Register  to view this content.

If I am reading this correctly it is saying if the cell is showing day 1 (presumably Monday) the populate as day 3 (presumably Wednesday).

Is that correct ? If so it will help me a lot with the tweaking.

Thanks

Jon

Never mind, I had an hour to play around with those numbers and it became obvious that 1 = sunday and that the second set of numbers relates to the number of days increase required.

Thanks so much for your help

Thanks so much for all of your help with this code, it has saved such a huge amount of time.

I wanted to ask if there is a way to create a code that would be able to create a master summary workbook.

Basically I would have worksheets created each day by running the macro (above) providing a summary sheet of the data from that day.

I would like to be able to have a new master workbook that looks at the folder where these files are stored recognizes when a new file has been generated and then copies the data from that summary sheet and pastes that data as new line in the Master Summary worksheet.

I had found some code to open newest files in a folder, but there maybe times (after a weekend) when I could have 3 days files generated and put into the folder on a Monday, so this code would only pick up the most recent. Which is why I thought a search for un-inputted files would work better.

Would appreciate you having a look.

Many thanks

Jon