MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Moving sheets

  Asked By: Sean    Date: Aug 15    Category: MS Office    Views: 1342

I have 4 workbooks, each workbook contains a sheet called "Summary". I would
like a code that will go to the summary sheet of workbook1, select from A1 to
the last non empty row, copy the selection into a sheet1 of a new workbook, the
code will go to the summary sheet of workbook2 , select from A1 to the last non
empty row and go to next empty row of sheet1 of workbook5 and past the data, the
same thing with workbook3 an 4.



2 Answers Found

Answer #1    Answered By: Nathaniel Martin     Answered On: Aug 15

Have you tried recording a macro to see the code  that is generated? The
trick to recording macro's, is that you should try to do all the work
with keystrokes rather than the mouse, so once you figure out that part,
you should be able to get some good code recorded.

Go to = CTRL+G. Type Summary:A1 and then press Enter to place your
cursor in the first cell of the Summary sheet.
CTRL+SHIFT+END will select  the Range of non-empty cells in that sheet.
ALT+F, N, will open a New Book, so you can CTRL+V to Paste.

CTRL+End and then down arrow will move your cursor down to the empty

Once you have some code recorded, post it back here if you continue to
have problems getting the code to do exactly what you want, and then we
can help tweak it for you.

Answer #2    Answered By: Rachel Fischer     Answered On: Aug 15

I will work on it. I think this is a great way to

Didn't find what you were looking for? Find more on Moving sheets Or get search suggestion and latest updates.