Prompt For User Mouse Input In Macro?
 

Greetings all.

I am currently completing a large project that deals with a set of
source documents (Excel) that contain data (multiple cells) which must
be consolidated into one file (Excel). The information is located in
DIFFERENT cells in every source document so I am trying to create a
macro that will prompt me for each piece, allow me to indicate the
cell that info is located in by clicking in that specific cell, and
then paste the data in the order it was captured from left to right
(it could even paste it into a line at the bottom of the source
document itself).

Anyone have any idea how I can achieve this?


Thanks in advance!

- oBis