Hello
I am new at writting macros and I am having difficulties firguring out how to write a macro for the following.
In an excel workbook I have multiple worksheets. Each worksheet represents a country e.g. "Argentina", "Canada" etc... The master worksheet "complete usage report" includes data of all the countrys in the workbook. What I would like to do is have a macro so each country worksheet can pull data from the master worksheet "complete usage report".
The data that needs to be pulled is columns A:H. I would like it so the data updates only what is new on the "complete usage report" worksheet (so if there is existing data on the country sheet it does not delete it or paste over it).
Columns A:H Worksheet "Argentina"
Find company name in "complete usage report" e.g. "marketing"
Pull from A:H "complete usage report"
Paste into A:H " Argentina"
I am new at writting macros and I am having difficulties firguring out how to write a macro for the following.
In an excel workbook I have multiple worksheets. Each worksheet represents a country e.g. "Argentina", "Canada" etc... The master worksheet "complete usage report" includes data of all the countrys in the workbook. What I would like to do is have a macro so each country worksheet can pull data from the master worksheet "complete usage report".
The data that needs to be pulled is columns A:H. I would like it so the data updates only what is new on the "complete usage report" worksheet (so if there is existing data on the country sheet it does not delete it or paste over it).
Columns A:H Worksheet "Argentina"
Find company name in "complete usage report" e.g. "marketing"
Pull from A:H "complete usage report"
Paste into A:H " Argentina"
