Copy Entire Row to different sheet based on Date selected

[her.rockstar]

Hello, I've got a thread posted at https://www.ozgrid.com/forum/forum/h...-date-selected
I haven't had much luck eliciting any support, if it's possible and there's someone willing to help me out that would be fantastic.

Thanks!

[Winon]

Hello her.rockstar,

Would you consider this approach, which does not limit you to the Date Selected only?

Please Login or Register  to view this content.

See and try attached sample workbook.

Regards.

[her.rockstar]

Hey Winon, that's a really sharp workbook. In practice it works really great.

The concern I have is that it will be for my wife and the added steps of selecting the desired range on one page, and then the desired range on the second page would be far too much. Just having it grab the line and paste it over the corresponding line on the next page automatically is really what I'm after.

I love how this works though.

[Winon]

Thank you her.rockstar,

Please could you provide more info w.r.t. in which column the date resides, etc,?

Also, please attach a sample workbook (not a picture or pasted copy).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[her.rockstar]

Hey, I had uploaded the file to the other website. Shouldn't have assumed that would have been enough.

The value for the desired date is found on Calendar!AQ1
Essentially, I need the row from Calendar!E14:AI14 copied to the correct row on the Results sheet, beginning in column B, except offset down by one row (below the dates)

[Winon]

Hello her.rockstar,

I have done 2019 for you. Is that what you want?

We use the Formula:

Please Login or Register  to view this content.

Regards.

[her.rockstar]

Oh dear, I don't think I've been clear enough in my ask. Please accept my apology as I haven't meant to waste yours or anyone else's time.

You're correct with how it should look, those results are in the correct spot, but I'm not looking for formulas on the Results page. What I'm hoping for is VBA code for the "Add Schedule" button. It will search the Results Page (column A) for the month/year selected in (Calendar!F11/I11), go down one row, and over one column, and then paste the values from Calendar!E14:AI14.

Again, I'm so sorry I haven't been clear. If this still isn't clear, please let me know. And thank you, thank you.

[AB33]

The code assumes you are looking for a single match based on Year and month selections.
I am unable to attach it to a button as all your buttons have already been assigned, but you can do it yourself.
You have lots of merged cells, which are not VBA's friendly.
The code is very sensitive to the layout of the data, so any change will render the code prone to error.

[her.rockstar]

This perfect AB33! Thank you so much for your help, I'm looking forward to studying what you've done here. Thank you too, again Winon. You've both been great.

[Winon]

@ AB33,

AB33 to the rescue, with excellent observations and Coding!!! Thank you Sir!

Kudos to you, my friend!

@ her.rockstar,

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.