sg2209
12-28-2018, 11:03 PM
Hi Friends,
i am newbie to VBA and don't know how to write the codes , tried recorded however not getting the expected results
I have a Pivot Table and need to copy the Data from A7 till last Row and Last Column its in Table Format , every day Data gets added to source data and Pivot has been updating auto.
I need to copy the Data starting from Cell A7 since daily numbers are getting added ( Columns and Row are adding to Pivot Table )
How do i copy the Data from At to Last Row and Column and email through Outlook Body.
Recorded Macro doesn't help me here.
Kindly review and help
i am newbie to VBA and don't know how to write the codes , tried recorded however not getting the expected results
I have a Pivot Table and need to copy the Data from A7 till last Row and Last Column its in Table Format , every day Data gets added to source data and Pivot has been updating auto.
I need to copy the Data starting from Cell A7 since daily numbers are getting added ( Columns and Row are adding to Pivot Table )
How do i copy the Data from At to Last Row and Column and email through Outlook Body.
Recorded Macro doesn't help me here.
Kindly review and help