Hi all,

This is what I am trying to do:

1) Launch macro
2) macro will prompt me to select a cell
3) I will use my mouse to click on the cell within a table
4) macro will then use the row value of that cell to grab data off the whole row
5) using the data I will populate another sheet

Problem is step 3. How do I get an input from cell selection?