A LoopToCopyColumnWithMatchingYearQuarter

**yjmmay34** · 07-09-2010, 05:01 AM

Hi, all. I need help with following problem.
pls open the attachment, you will see a simple sample worksheet which shows the same contents but different format seperated by column i . I need a loop could help me check the whether the year and quarter are same, if they match, then copy the whole column's value to the other side. But after copy the data, i hope it could copy the address, so that when the database change, the coped part also could change without run the macro again.
Greatly appreciate any help! Thank you.

**p24leclerc** · 07-09-2010, 12:26 PM

It is not clear to me what you try to achieve. It seems really too simple.
Do you really need a macro to do this?

**royUK** · 07-09-2010, 02:04 PM

Why don't you design the sheet better? You shouldn't need to copy data like that.

**yjmmay34** · 07-12-2010, 10:49 PM

Hi,p24leclerc.actually i got a huge amount of data like this, i really need a macro to help me done this job, and the critical part is the copied number should be a formula or address, so that next time when i change the data, there is no need to run the macro again the copied part will also change. Thank you leclerc.

**yjmmay34** · 07-12-2010, 10:51 PM

Hello, royUk. please check the sample again, i 've edited it. Thank you!

**foxguy** · 07-13-2010, 05:30 PM

Hi yjmmay34;

Here's a file that doe what you want (I think) without using a macro.
Hide Rows(1:2) and it will look like you want.

**yjmmay34** · 07-13-2010, 08:52 PM

hi, foxguy, thank you for your kind help. but i really need a macro to help me done this work, because i will insert this macro to my entire program. this is a macro project.

**foxguy** · 07-13-2010, 09:56 PM

You say

But after copy the data, i hope it could copy the address, so that when the database change, the coped part also could change without run the macro again.

That means that you have to copy formulas over to the other side. Or it has to run a macro to copy again.
I provided a sheet that has the formulas already. There is no need for macros. The macros will just do what I already did.

If this is not good enough, you will have to explain why you need it to be a macro.

If you are saying that you can not put the formulas into you workbook, then you will need to provide your workbook so that someone can write the macro correctly. It is too hard to try and write a macro that will handle every possible situation.