I am in need of some assistance with this challenge. We receive on a daily basis many Excel files that come in in the same format. What we want to do is the following:
1--Take each of the files and add the "posted" date on the end of each row. I've attached an example so you can see exactly what we are looking for. The date is always located in A3. But it is "just a date" there is some text with it.
2--We want to take all the files in the daily folder "combine" and have the data in the sheet of each workbook labeled "PartnerApprovedDailyPoste
dSales". (this is always the name) combine into 1 new workbook on a single tab stacked on top of one another. Just as if you cut and pasted each of the workbooks individually into one worksheet. The data always starts in A1 on row 6 but in varies in how many rows each workbook will have.
Any help would be very much appreciated.