Good Afternoon,
I'm trying to create a VBA code which will run and complete the following based in Excel 2003 & 2010.
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.
Kind Regards,
S
I'm trying to create a VBA code which will run and complete the following based in Excel 2003 & 2010.

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.

Kind Regards,
S