Hi, I am trying to populate a spreadsheet based on what cell is selected in a different worksheet. Ie, I have a worksheet1 with all information (names in column A) and I want to select a name in column A (say cell A2) and have an additional worksheet2 generate with info from cells a2,b2, c2, etc (from worksheet1). I think I need to use an activecell command in vba but I am not sure how to go about it. Any help is much appreciated!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Populate a sheet based on selected cell
- Thread starter soccer504
- Start date
-
- Tags
- activecell export vba
Similar threads
- Question
