Hello, new to the forum. I'm somewhat familiar with VBA, just enough to get me by.
I have created a script that deletes certain rows/columns in an Excel Template my company has, then it looks at a certain column and if there is no value, it deletes the row. So essentially it condenses a large template into just the information our accountant needs to extract. The script works fine, except now we need the flexibility for a user to add/delete rows as they wish. I'm just not sure how to incorporate that. Here's a longer explanation of why.
My initial script deletes entire columns from J to the end. Then it deletes entire rows from like 1550 all the way down. The reason for this is because for our accountant to import our data to their program, these have to be deleted. If they're not, the program reads a comma (,) in place of these fields. This doesn't affect anything except then they get an error report when importing. This is what we're trying to avoid. So, the user of the excel sheet is going to be able to add/delete rows as needed which then messes up my set rows to delete.
Any suggestions?
I have created a script that deletes certain rows/columns in an Excel Template my company has, then it looks at a certain column and if there is no value, it deletes the row. So essentially it condenses a large template into just the information our accountant needs to extract. The script works fine, except now we need the flexibility for a user to add/delete rows as they wish. I'm just not sure how to incorporate that. Here's a longer explanation of why.
My initial script deletes entire columns from J to the end. Then it deletes entire rows from like 1550 all the way down. The reason for this is because for our accountant to import our data to their program, these have to be deleted. If they're not, the program reads a comma (,) in place of these fields. This doesn't affect anything except then they get an error report when importing. This is what we're trying to avoid. So, the user of the excel sheet is going to be able to add/delete rows as needed which then messes up my set rows to delete.
Any suggestions?