I want to simplify something in my excel sheet. But don't know how to do it. The idea describes below.
I have a large datasheet name bill. In this sheet Column, I9:I1200 has data but not in every cell.
Now when I select one of the cell in between of I9:I1200 which cell has data,
The vba code automatically copies the selected cell data to another two sheets name 'Bill Info' to D12 and sheet 'Other' to G13 for calculating those sheets.
If multiple cells or the cell which have no data select in the range of I9:I1200, It returns nothing.
Is it possible? If possible please let me know What will be the code.