Create a automatic note for each cell when you cellect it

[ids_73]

hi there

attached i have 2 files which are connected. the book2 has transaction and the book1 has the totals for these transaction by date.
what i am looking to do is to find a way when i select a cell with a value to show me which are the transactions let as say as a dynamic note probably or a message or any other idea will be welcome.

the format i would like to be as follows:
if we select the cell b3 to show us
1/5/2017,sp1,150
1/5/2017,sp2,175
1/5/2017,sp3,25

when we select another cell the note to disappear

note that the sheet will be locked

thanks in advance
IDS

[dflak]

This program makes use of a selection change event. When you select a cell, the program runs.

The program looks in the directory with this spreadsheet for the source data file (the one with the transactions) specified in cell B2 on the control panel.

It copies data from that file to the Pivot sheet – you can hide this sheet if you wish.

When you select a cell, the program passes the transaction type and date to the pivot table filters. It then copies the data to a string and displays the string.

[ids_73]

hi there
thank you for the reply

as you have develop that solution we are going to have the data of the transaction in the same file as the report. but this is not something that i want to have

[dflak]

The spreadsheet reads the data from the second file as entered in Cell B2 on the control panel sheet.

[ids_73]

yes i see that but is it possible not to have them the