Hello people, I need your guidance.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am running reports from a system daily that gives me the information in a CSV. I then have to do loads of formatting to make it look presentable but have found the glory of Macros and I bloody love em... But have come across a few problems.<o></o>
<o></o>
I can set up the formatting but every time I run the report I can be getting a variable number of rows, I need to find out how I can create a macro to find the last row of data and then do Autosum on the next row down?? HELP....<o></o>
<o></o>
*NOTE: I am creating macros by recording the process, VBA scares me. If there is anyone in the Bham area who would fancy giving me a few lessons??<o></o>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>I am running reports from a system daily that gives me the information in a CSV. I then have to do loads of formatting to make it look presentable but have found the glory of Macros and I bloody love em... But have come across a few problems.<o
></o><o
></o>I can set up the formatting but every time I run the report I can be getting a variable number of rows, I need to find out how I can create a macro to find the last row of data and then do Autosum on the next row down?? HELP....<o
></o><o
></o>*NOTE: I am creating macros by recording the process, VBA scares me. If there is anyone in the Bham area who would fancy giving me a few lessons??<o
></o>
