how can manual entries be added in advanced filtered data

[Shilpa M]

I have created a advanced filter for a bulk data but other people will update the comments, name and date column manually in filtered data

If manually the comments column is entered and if we again filter those details are disappearing.

Can you suggest an idea for this problem

 

[awoohaw]

Hi, do you know if the comments field is one of the fields being filtered? Or, is the team putting data into a filtered value that would remove the record from consideration of filtering?

If you can post some sample data (anonymized if you need to) using the xl2bb add in it would be helpful. Link is below.

 

[Shilpa M]

Once the data is filtered. If we have to say something specific about particular product. It has to be mentioned in comments column. So if i add and filter, the comments disappears.

Is there any solution to manually input the comments

 

[awoohaw]

Thanks but, that repeats your requirment, but it does not answer my question about what you are filtering.
If you are filtereing for something like <> "* xyx *" and the user types "xyx" in the comment then it will be removed.

 

[Fluff]

Hi & welcome to MrExcel.
Are you filtering in place, or using copy to another location

 

[Shilpa M]

Thanks but, that repeats your requirment, but it does not answer my question about what you are filtering.
If you are filtereing for something like <> "* xyx *" and the user types "xyx" in the comment then it will be removed.

I have criterias which i filter and sometimes for those criterias we have to add comments. If we add comment and save it will stay but if i filter for another criteria it disappears.

I need a solution as how to retain those comments in advanced filter sheet.

Please help.

 

[Shilpa M]

Hi & welcome to MrExcel.
Are you filtering in place, or using copy to another location

I am using copy to another location. I have a raw data; in one sheet which i update regularly with new entries.

Those entries i have made a advanced filter opton ot another sheet with criteria But i am not able ot add comments which disappears., if i filter again.

Please help

 

[awoohaw]

can you please share those filtering requirements? and give an example of before and after rows that are not showing up?

 

[Fluff]

Those entries i have made a advanced filter opton ot another sheet with criteria But i am not able ot add comments which disappears., if i filter again.

No you wont, the comments need to be added to the original data. Changing something on the filtered list will not affect the master list.