Copy, Search, Then Paste Needed

[strato1983]

Newbie! I am looking for a macro to assign to a command button that will copy cells in row A2:A10 in worksheet1 based on a criteria (date) giving in cell A1 , then search worksheet2 (column A) for the criteria (date) giving in (Worksheet1! A1) and paste the cells in (Worksheet1! A2:A10) next to the found date in worksheet2.

I would really appreciate the help.

[StephenR]

I suggest you attach a small sample workbook illustrating your data and desired results.

[strato1983]

Thanks for the fast response!
Here's a sample. Basically what I need,

Using a command button
Copy cells B1:E1 then paste the values to sheet2 next to the date based on cell A1 in sheet1.

If you change the (criteria) date in A1 than click the command button cells B1:E1 will be copied next to that date, and so on.

[StephenR]

OK, that's easily done, but why couldn't you just use the VLOOKUP formula?

Where are the values in B1:E1 coming from when you change the date?

[strato1983]

Sounds like you know your stuff StephenR

I want the user to ensure that the data in sheet1 is correct before copying the values to sheet2. A command button adds a user step but gives the added security. If that makes any sense.

[StephenR]

Sort of, though you could just use data validation. Anyway, try assigning this to a button:

Please Login or Register  to view this content.

[strato1983]

Wow! That does look easy.
Now can the same date in sheet1 also be used to copy another set of cells lets say B2:E2 to another set of dates below the first set of dates in sheet2 all with one click of the button? Please see the attached example.

[StephenR]

If there is a fixed interval between your two sets of dates:

Please Login or Register  to view this content.

[strato1983]

I get it! Thanks a bunch StephenR. I'll mark this thread as solved.