Hello Excel World.
Thank you in advance for your support.
I have an excel file name: "Heatwave.xlsm".
Now on the work sheet name: "Heat Map".
On Column "A". I have a few list of country names in alphabetical order with their data on Column "B, C and so on".
My problem here is this:
On a next workbook. I have a list of countries names on Column "A".
Some countries are listed in "Heatwave.xlsm" workbook and some are not.
My problem here is this: How can I copy and paste data into Heatwave.xlsm automatically and keep alphabetical order at the same time without losing and data in "Heatwave.xlsm" workbook.
Please view examples Below
Thks in advance
Heatwave.xlsx
Thank you in advance for your support.
I have an excel file name: "Heatwave.xlsm".
Now on the work sheet name: "Heat Map".
On Column "A". I have a few list of country names in alphabetical order with their data on Column "B, C and so on".
My problem here is this:
On a next workbook. I have a list of countries names on Column "A".
Some countries are listed in "Heatwave.xlsm" workbook and some are not.
My problem here is this: How can I copy and paste data into Heatwave.xlsm automatically and keep alphabetical order at the same time without losing and data in "Heatwave.xlsm" workbook.
Please view examples Below
Thks in advance
Heatwave.xlsx
Transfer Data to Heatwave workbook.xlsx
drive.google.com