ppleasebob
Board Regular
- Joined
- Dec 23, 2002
- Messages
- 145
Board,
Would appreciate your advices, is it possible to 'remember' the selections of an auto filter.
I have a scenario where we use a filtered sheet to produce a quotation, (by print workbook to pdf) Each quotation could include different items selected from a filtered list, if my quote is successful I want to be able to issue a formal version but without having to rekey any of the data, so I need a way of saving the selection and then reapplying it to the filter at a later date. The quotation is just over 1mb, and we do about a 100 a week, so I don't want to save each quote as an the individual workbook.
I had in mind a second workbook that would have a single row of data with all of the relevant selections that I could then lookup to recreate the original.
Thanks for looking.
bob
Would appreciate your advices, is it possible to 'remember' the selections of an auto filter.
I have a scenario where we use a filtered sheet to produce a quotation, (by print workbook to pdf) Each quotation could include different items selected from a filtered list, if my quote is successful I want to be able to issue a formal version but without having to rekey any of the data, so I need a way of saving the selection and then reapplying it to the filter at a later date. The quotation is just over 1mb, and we do about a 100 a week, so I don't want to save each quote as an the individual workbook.
I had in mind a second workbook that would have a single row of data with all of the relevant selections that I could then lookup to recreate the original.
Thanks for looking.
bob