Help on copying data from multiple sheets into one single worksheet
Hello everyone!!
I'm trying to copy data from 5 worksheet in the same excel workbook into one new sheet that I create in the same workbook. How can I do this??
What I have done so far is: When I select all the 5 sheets and hit copy then paste into the new worksheet it tells me that the copy and paste area needs to be the same size and shape.
Does anyone have any idea and could help me out???
Last edited by SimonLee; 08-22-2011 at 01:06 AM.
you should copy and paste the sheets one by one into the new worksheets
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Well it works when I open a new workbook to paste but I want to paste it in the same workbook but just under a different sheet name??
copy the data from one sheet then go to the new sheet in same workbook and paste
i did try that. it don't work. i keep getting this error: tells me that the copy and paste area needs to be the same size and shape.
lets your your data is in sheet 2 in range A1:G100:
select the range A1:G100
Copy the range
come in sheet 1
keep your cursor on Cell A1
paste the data
there is no need to select the range in the sheet 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks