Problem with Autofilter not recognising new data

[volvodriver]

Hey guys,

I'm having an issue with an autofilter i'm applying. Basically I work in a hotel and through the month staff put all the maintenance jobs that have been done into a spreadsheet throughout the month.

Then i've set up a separate document importing that data into the first worksheet, then transfer the data into other worksheets of each individual unit and filtering to only display the maintenance jobs from that particular unit (eg: 201 or 202 ect) that i use to apply charges to the individual unit owners accounts as i get time throughout the month.

That's all well and good but the problem i'm having is it will not recognise any new data put in either spreadsheet without re-applying the filter, it will input it into the unit spreadsheet but not display on the individual sheets that already have the filter applied. I've tried this with just a regular autofilter or an advance filter using the following code;

Please Login or Register  to view this content.

I would prefer to use the code because it will make setting up new units and applying it to our other properties a lot faster/easier but not sure if that's possible?

Any help will be greatly appreciated because i've just spent the last couple of days trying every possibility i can think of or google will spit out.

[teylyn]

Hello,

have you

- verified that the code runs?
- made sure that the range for the table is sufficient?

Can you upload an acutal Excel file that displays the issue? Please replace confidential data with dummy text before uploading.

cheers,

[royUK]

If the data to be filtered is the only entries on the sheet then use UsedRange

Please Login or Register  to view this content.

If not then

Please Login or Register  to view this content.

[volvodriver]

Ok, haven't uploaded a file here before but here goes.

It's filtering fine, but if i enter new data into the first sheet (or the other document) it will not trickle down into the filtered sheets, if i then go and re-save/re-enter the filter it will import it but i want to avoid doing that every time i go to the document.

P.S. Forgive the poor formatting, was going to deal with that once i see that all formulas work properly.

[royUK]

It seems to have unnecessary formulas in. Why don't you just copy & paste the new entries into the data? Alternatively use Excel's Table feature.

[Roger Govier]

July Unit Charges.xlsm

Ok, haven't uploaded a file here before but here goes.

Hi

Why not just have a single sheet for the Individual Apartment detail, and use Advanced Filter to extract the data just relating to that apartment.
In the attached workbook, I have set up some Dynamic ranges, and then used event code on the Sheet called Apartment, so that when you choose a different apartment number from the dropdown list in cell C2, a macro is run which extracts the data relating to that department and puts in the totals.

Please Login or Register  to view this content.