VBA code to copy cell contents from one sheet to another
 

Hi

I have a workbook with two sheets. Each sheet contain a pivot table.
The first sheet lists the bottom 25 files based on revenue and some of
the detail. The second sheet has the same setup but list one file at
a time.

What I would like to do is from the bottom 25 sheet click on a file
number, which would be located in column A, then have that file number
or the contents then be pasted into the second sheet and then that
seconnd sheet updated or refreshed to show all the detail on the file.

In other words, I want a user to be able to just select a cell and
have it copied to the other sheet or pivot table...make sense?