Macro to Select Certain Tab

[BLS99covert]

This is probably something super easy, but I'm not a macro guy, so help is much appreciated. I have a macro I created that is taking certain sections of a table and pasting them into another workbook. However, right now I can only get the macro to paste into the active sheet of the other workbook. I want my selected cells to be pasted to a specific sheet with the name "Budget". The same with going back to my original workbook I want to make sure it is taking the selection from sheet name "BudgetExport" My macro code is below.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Maybe

Please Login or Register  to view this content.

It was a little difficult to understand precisely what you want to do in any circumstance since your code was presumably put together by the macro recorder and hence only recorded stuff that happened to be relevant at that time. If you need further advice then upload the workbook and tell us what you want to do, rather than what the macro recorder did.

[BLS99covert]

Ok here are the workbooks. I'm hoping that by hitting Ctrl+Shift+X to copy Cells D5:O21 & D24:O88 from "Budget Export" Tab in "Budget Creator" workbook to the same cells in "BBudget" Tab in "Budget Updated" workbook (Paste Values). Enjoy my lovely spreadsheets I started by being bored this winter.
Thanks for the help.

[Richard Buttrey]

Hi,

Sorrty small typo earlier

Please Login or Register  to view this content.

[BLS99covert]

Sorry, for the delay in reply, but tried this code today and it didn't work. Any ideas?

[Richard Buttrey]

Just checked again and it works OK for me.

You'll need to tell me what you mean by 'it didn't work'. Did the macro run but not do anything, did it run but not copy and paste the right data, did it not run at all and debug with an error? If the latter on which line did it halt.

Have you put this code in the Budget Creator workbook in place of your existing code.

If so upload the workbooks again with the new code I gave you.

[BLS99covert]

Ok here are the fresh copies, I just get a ding sound when I press ctrl+shift+x. Nothing else happens. Everything looks like it should work I don't question you there. I'm just probably doing something simple wrong.

[Richard Buttrey]

Try deleting the last line
Range("R8").Select

[BLS99covert]

No luck, are you able to get it to run when you open up the two workbooks?

[Richard Buttrey]

No luck, are you able to get it to run when you open up the two workbooks?

I believe that was the case when I last tried it. I don't have Excel access at the moment so can't reconfirm.

[BLS99covert]

If you could check again when you do have access again that would be great. I still can't get it to do much of anything at all.

[BLS99covert]

I was able to get it to go, I was pasting the code into "View Code" on sheet tabs versus pasting it in the Recorded Macro edit screen.
Thanks for all your help.