Hello
i am competent when it comes to excel and basic macro's but now what i need to do is out of my depth!!
I have a master spread sheet with 2 tabs (called "results" and "readings"), these two tabs will then be inserted into existing spreadsheets, where they will vary in their position in the workbooks as these have all been compiled differently.
what i am aiming to do is have a button "send data" whereby it copies these 2 tabs only out of entire workbook and sends them as an attachement via outlook. these tabs will always have the same name no matter what workbook theyre saved in.
is it possible to create macro that will extract the tabs by their names and attach to an email?
i have looked in all the usual suspects when it comes to excel/macro help but it appears the majority is sending the entire workbook, which is not acceptable.
any help would be much appreciated.
i am competent when it comes to excel and basic macro's but now what i need to do is out of my depth!!
I have a master spread sheet with 2 tabs (called "results" and "readings"), these two tabs will then be inserted into existing spreadsheets, where they will vary in their position in the workbooks as these have all been compiled differently.
what i am aiming to do is have a button "send data" whereby it copies these 2 tabs only out of entire workbook and sends them as an attachement via outlook. these tabs will always have the same name no matter what workbook theyre saved in.
is it possible to create macro that will extract the tabs by their names and attach to an email?
i have looked in all the usual suspects when it comes to excel/macro help but it appears the majority is sending the entire workbook, which is not acceptable.
any help would be much appreciated.
