Add intermittent cells to column

[bwiebe]

I am creating a report which lists gifts during a two week time period. Most donors have only one gift, listed in column C and D. Some donors have donated twice or three timies in the two week period. I would like these entries, which are intermittent in Cloumns H-I and K-L, to be automatically moved under the corresponding cells in columns C and D. This way an individuals two or three donations all end up in one column. Can Excel do this?

[noboffinme]

Hi bwiebe,

A Macro can, I assume you want the data to be under the same date?

Can you advise?

Thanks

[bwiebe]

Thank you noboffinme. I am not familiar with Macro's. Yes, I would like the data to be under the same date. Columns E and F are where I want to see the data in question, not Columns C and D as previously mentioned.

[noboffinme]

OK, try the attached file.

It should do what you need.

I've commented the code so you can see what it does.

Cheers Peter

[bwiebe]

Thank you kindly, Peter, for your generosity in going to this amount of work. This should be a time saver!