Moving data based on the date

[Punter!]

Can anybody help me write a macro code wherein:

If I enter date as 1 then a particular selection shows up under Column A
Similarly, if I enter date as 2 then a particular selection shows up under Column B and so on.

I have an attchment that has sample data that will help you understand the situation

[jeffreybrown]

Moving what data?

You may need to fill in some gaps in the explanation here...

Where does the data come from and where are you entering the 1 or 2...?

[Punter!]

S5 is the cell where I will enter date and I have highlighted the data i.e. S7:S10

[jeffreybrown]

This still does not mean anything to me.

How about making a before and after in the attachment.

[Punter!]

This still does not mean anything to me.

How about making a before and after in the attachment.

Here is the attachment? I'm sorry since I was not able to explain the problem earler, hope this helps.

[jeffreybrown]

Maybe this is what you are wanting...

It runs off of a worksheet change event when a date is selected from C5...

[Teethless mama]

See the attached

[Punter!]

Maybe this is what you are wanting...

It runs off of a worksheet change event when a date is selected from C5...

Awesome! Thanks Jeffi! This answers my question!

[Punter!]

See the attached

Thank You - Your formula did the same thing that I wanted a macro to do...TYVM

[Punter!]

Hi, If we can keep data to stay at the old position as well. For eg: If we toggle between date?

[Punter!]

Jeff,

How can I get this functionality if I only have one sheet?

[jeffreybrown]

Hi, If we can keep data to stay at the old position as well. For eg: If we toggle between date?

I'm guessing you are asking for the data to be stacked on top on each other if data is already there? If so...

Please Login or Register  to view this content.

How can I get this functionality if I only have one sheet?

I'm not so clear on this. Do you mean you just have one sheet so you want the results to be pasted above the drop down which is in row 5?

[Punter!]

Thanks Jeffi! Your earlier code is working well for me...Thanks again for your time and patience.

Moderators Note:

• As per Forum Rule #12, please don't quote whole posts unless necessary-- it's just clutter...Thanks.

[jeffreybrown]

Glad to hear it and you're welcome.