Mary Bizmax
New Member
- Joined
- Aug 12, 2018
- Messages
- 4
I'm very new to macros, so please excuse my ignorance.
My workbook contains the following sheets:
"XeroImport" - a report from Xero accounting software exported to excel is pasted in there by the user (so the size varies each month)
"Pivot" which has a pivot table sourced from "XeroImport" which automatically refreshes (I've managed to code that in a macro) and then I've filtered the table to exclude blanks and the same macro copies the data into a new sheet called:
"InputSheet". My problem is that I have specified the table range to copy to be A1:H100 (because the pivot table size will vary each month) and so I end up with a lot of empty rows at the end of the "InputSheet". (eg from row 10 to row 100 this month) So when I try and use this sheet as an import to another cloud system, I'm getting a lot of error messages....so I really need to delete these rows.
Please could someone help either with VBA code to delete these empty rows at the end of the sheet? Probably a very simple question but I've been doing a lot of searching on various forums and nothing I've tried seems to work.
Many thanks.
My workbook contains the following sheets:
"XeroImport" - a report from Xero accounting software exported to excel is pasted in there by the user (so the size varies each month)
"Pivot" which has a pivot table sourced from "XeroImport" which automatically refreshes (I've managed to code that in a macro) and then I've filtered the table to exclude blanks and the same macro copies the data into a new sheet called:
"InputSheet". My problem is that I have specified the table range to copy to be A1:H100 (because the pivot table size will vary each month) and so I end up with a lot of empty rows at the end of the "InputSheet". (eg from row 10 to row 100 this month) So when I try and use this sheet as an import to another cloud system, I'm getting a lot of error messages....so I really need to delete these rows.
Please could someone help either with VBA code to delete these empty rows at the end of the sheet? Probably a very simple question but I've been doing a lot of searching on various forums and nothing I've tried seems to work.
Many thanks.