copying & pasting
copying & pasting
(OP)
I would like to know the vba code to copy the contents of one worksheet to the next available empty cells of another worksheet. These worksheets are all in one workbook.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: copying & pasting
DO you mean you wish to copy an entire sheet to the next worksheet that is currently empty?
i.e. If you have five sheets, Sheets 1, 2 and 3 all have some data and you wish to copy Sheet 1 to SHeet 4? or do you mean something different?
Hope this helps.
----------------------------------
maybe only a drafter
but the best user at this company!
RE: copying & pasting
Thanks
Ken
RE: copying & pasting
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: copying & pasting
Usually, the resultant VBA is a bit over-the-top. It will contain a whole load of stuff that is actually not required. But you can remove this manually to get more compact code. Comment it out first, make sure it still works correctly, then delete it.
RE: copying & pasting
Thanks for sharing.