Moving information from one spreadsheet to another

cschubert68

New Member
Joined
Apr 4, 2016
Messages
10
I have a spreadsheet with all addresses for holiday cards.

Is there a macro that will take all the international addresses from one spreadsheet tab 1 and move to tab 2?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Can you provide more details? Such as - is each address in one row, but stretched across multiple columns? Is the country field in the same column for all addresses? Can you post an example?

As a side note - adding a filter and copying/pasting (if there is one address per row) is quick and easy IF it's something you aren't going to have to do very often.

(If you click on the "Tips for Posting" link at the top of this page it will take you to a thread that explains add-ins that allow you to add image examples/screenprints to your posts. I just started using MrExcelHTML and LOVE it.)
 
Upvote 0
Hello,

Yes, I have three thousand names and addresses- there are 18 columns with different text. Address 1- Address 2 City state City Country
So you are saying to sort by country and then copy and paste to the new tab. That makes sense.
i will try. I love macros and formulas that I want to use them all the time and forget the easy steps.
Thank you
 
Upvote 0

Forum statistics

Threads
1,217,505
Messages
6,137,027
Members
450,040
Latest member
vincentywh

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
Back
Top