View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mona Mona is offline
external usenet poster
 
Posts: 69
Default excel filter question

I have a workbook with worksheet "data" for example (simplified):
A2 B2 C2
milk gallon 1.55
tea gallon 2.00

I have worksheet "results" that I use to filter the data and display the
results. I have written a macro with a button that any user can modify the
criteria and display the results.

My question is I would like to have the ability to MODIFY the RESULTS and
then UPLOAD back to the the "data" worksheet. For example:

RESULTS
tea gallon 2.00

User changes:
tea " quart " 2.00
I would like this row of data to replace original in "data" worksheet with
maybe an upload button ?

Thank you in advance for suggestions/answers