Macro that copies based on cell value

Hey there,

Well, you can easily achieve this by introducing another IF condition inside that IF condition within the loop. Below is the modified version of your code:

Please Login or Register  to view this content.

Attached is a working sample for your reference.

Hey - don't get pushy, we all work for free. You may be getting what you pay for.

Hey freshfruit,

The file you attached has no macro in it. If you attach a sample that has the data in sheet 1 and the macro, I can comment the code and see if I can figure it out. No guarantees though as I work for free.

Hello there,

Am sorry for my late response. I've been caught up with some work at my office for past a few days. Well, to cater your needs. Am attaching a sample work again. Test it. I've not been very elaborative last time so have included instructions and a tutorial of how I did the same task. Check and let me know if things work out for you.. All the best!

Tutorial Link

Also, looking at your file, it seems you've additional parts in that date cell A3, i.e., it starts with an extra 5 letters ("Date: ") in the beginning of the value. If that's the case, then attached is the re-worked file which can be of use.

Do let me know if things don't work out the way you wanted.

Sure, no problem.

The Workbook files having string - "With Date" are files that work together and those without "With Dates" work together. Use either of them based on your requirements.

Let me know if things don't really work out.

Warm regards,
cOdEsLiZeR

Yeah.. I observed some inconsistencies when I opened more than one file. Thanks for the heads up. I fixed it, try it now.

Freshfruit, are you following my instructions? There are two files to indicate two different scenarios in which date could come. My idea was simple "m/d/yyyy" format but when I went through your sample, it has a string part - "Date: " followed by a date in "m/d/yyyy" format. So, I have included both the files for your references as both of them takes care of the work in two different scenarios.

You say it still doesn't work for you. How are you testing them? For my examples, you'll have to open main XL file along with its supporting document. Say like if you are opening
1. "Check Date and Copy (With Date).xlsb" - main file then you'll also have to open "Workbook1(With Date).xlsx" - supporting file to check its working.
2. "Check Date and Copy.xlsb" - main file then you'll also have to open "Workbook1.xlsx" and "Workbook2.xlsx" - supporting files to check its working.

For a visual reference, I've also attached a GIF tutorial for "Check Date and Copy.xlsb" - main file in my earlier post.

I hope you're not trying these main files with your XL files. The XL files that we provide here is just for ideas and references to make OP understand how they can work out in their XL challenges.

Originally Posted by freshfruit

What? I don't have a macro!! I NEED a macro. Instructions again:

In the attached sheet, there is a tab called "Data sheet". This represents all of the open workbooks. In A3 there is a date, match this date to the dates in row 3, workbook and tab "2014masterfile" and copy the content starting in row 7 below the date in 2014 masterfile.

Just a warning!!

Common courtesy is the order of the day. Avoid coarse language, personal attacks and inflammatory remarks. Address your concerns at topics and not at people.

User names that are deemed offensive or in poor taste are subject to being changed or banned.