Copy and pasting with tabs

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
I am attempting to copy and paste a mailing list from several different tabs. Unfortunately, I can't figure out how to convince excel to recognize the pattern. I am pulling several pieces of data from each tab but all the information is placed in the exact same cells. Any help would be appreciated.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
Do you have a file of a mailing list in a mailing label format that you are trying to get into 1 row?
 

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
No, I am pulling the information off of check requests to make a mailing list with the name, address, and some other misc. information.
 

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
I tried the following and let me see if it will help you.

Continue to do what you are doing, copying the data in MSWord and Paste it into a blank sheet in Excel. Copy the new pasted data and go to the sheet you want the data in and go to Edit > Paste Special and choose the Transpose option at the bottom of the pop up screen.

Maybe this will help you. It will put the data onto 1 row. Let me know if this was what you were looking for.

If not please try to give a better description.
 

Forum statistics

Threads
1,144,358
Messages
5,723,891
Members
422,524
Latest member
wirkkarn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top