Dear users,

My workbook contains two worksheets. One is my "database", the other
one is a sheet in which I filter my database (special filter).

Each row in my database is a special case with several cells of
information.

My colleagues will be using the filter to find specific cases filtered
by different criterias. Therefore, the result will always be a
different amount of rows.

To their comfort, I would like to offer them the possibility to change
the cell value right in the filter.

Each "case", when it is created, has in column "A" a case-number. This
number might not be identical with the row number.

My idea is the following:

I would like to offer a sub, which can be started by a Shortcut (I can
handle that, I guess). The Sub should do then the following:

- ActiveWorksheet: ActiveCell find out Column XYZ, find out Case-
Number on the same row in Column A
- In other Worksheet: Find matching Case-Number, in the same row, go
to Column XYZ (as in ActiveWorksheet) and copy Copy Value of
ActiveCell into this cell

Thanks a lot for your help.

If you can also help me to restrict the short-cut to work only in a
specific area like Worksheets("Name").Range("A8:AA1000"), I would be
very thankful.

Thank you very much to anybody who contributes to this post.

Sincerely,

Rico