Good Afternoon,
I'm trying to create a VBA code which will run and complete the following based in Excel 2003 & 2010.![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
Currently 1 data table exists in one excel workbook which I'm working off.
I'm trying to create a macro to run the following:
1) I need the VBA to output to a new workbook and give it a title: "Example Title"
2) It needs to output based on the following calculations:
- If Column F and Column G are blank and Column Y doesn't equal "A Word" - calculate Column E minus Column D and return this value only if it's greater than 7 in the new workbook along with select cell values from that item's row in this order:
- Column D, Column A, Column N, Column AI, Column AE, Column AE minus AH, Column AQ, Column Y, Answer from above calculation.
3) Save and Email the output to a selected address.
Is this at all possible? At the moment I have a table that is refreshed by a macro but it takes a very long time due to the amount of data currently in use.
I'm sure a better solution exists within the realms of VBA, just don't know how to start it.
Please any advice or suggestions are greatly appreciated.
Thank you very much for your time.![Big grin :biggrin: :biggrin:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
Kind Regards,
S
I'm trying to create a VBA code which will run and complete the following based in Excel 2003 & 2010.
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
Currently 1 data table exists in one excel workbook which I'm working off.
I'm trying to create a macro to run the following:
1) I need the VBA to output to a new workbook and give it a title: "Example Title"
2) It needs to output based on the following calculations:
- If Column F and Column G are blank and Column Y doesn't equal "A Word" - calculate Column E minus Column D and return this value only if it's greater than 7 in the new workbook along with select cell values from that item's row in this order:
- Column D, Column A, Column N, Column AI, Column AE, Column AE minus AH, Column AQ, Column Y, Answer from above calculation.
3) Save and Email the output to a selected address.
Is this at all possible? At the moment I have a table that is refreshed by a macro but it takes a very long time due to the amount of data currently in use.
I'm sure a better solution exists within the realms of VBA, just don't know how to start it.
Please any advice or suggestions are greatly appreciated.
Thank you very much for your time.
![Big grin :biggrin: :biggrin:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
Kind Regards,
S