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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

shanesuzanne

New Member
Joined
Dec 1, 2016
Messages
21
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.)
 

cschubert68

New Member
Joined
Apr 4, 2016
Messages
10
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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,532
Messages
5,659,368
Members
418,499
Latest member
mbcmel

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