plasteredric
03-01-2018, 04:24 PM
I'm having issued with a spreadsheet, when i filter the data I have the category: Blanks in the drop down. When applying the filter and later removing them the row order sometimes changes and I find blank rows in the middle of the data.
Has anyone else experienced this? i'm thinking it may be because I have formulas pre populated in the table meaning some rows contain no data & just the formulas.
If I am correct, is there a way of (using vba) to populate the formulas into only the rows that contain data?
Any help appreciated
thanks
Has anyone else experienced this? i'm thinking it may be because I have formulas pre populated in the table meaning some rows contain no data & just the formulas.
If I am correct, is there a way of (using vba) to populate the formulas into only the rows that contain data?
Any help appreciated
thanks