Based on user input go to cell

[jaggiebunnet]

hi

I have this scenario, spreadsheet with 4 tabs. 3 of the tabs will have 4 columns and when a particular row, for column 3 is selected, I would like to copy the corresponding value from the other tab into the clipboard for pasting into another app. How easy would this be to do?

Cheers
R.

 

[electricpete]

You can use the worksheet.selection event to trigger your action. Then a case statement based on which range is selected. I can't go much farther without specific details what you are trying to do. The logic of which row in which sheet triggers copying of which data from which sheet is not clear to me.

 

[electricpete]

And do you intend require the user to select an enritre column, or just a cell within the column?

 

[jaggiebunnet]

The problem is this:

I have 4 worksheets. Worksheet a contains a list of items which i will do a manual find on, when i find it and select the cell I want it to read worksheet b, column x, cell z say and read that value into the clipboard for pasting into another application. This isn't for any business process I am really just trying to remove a repetitive task for some manual work that needs doing. So if I have the sub as below - How do I search another workbook for the activecell value and then how do I put that into the clipboard - if it is possible?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

ActiveCell.Select

End Sub

 

[SkipVought]

The ActiveCell is ALREADY selected, is it not?

"...when i find it and select the cell I want it to read worksheet b, column x, cell z..."

Do you want to find the ActiveCell VALUE in each and every sheet and copy each of those ROWS? The explaination of your PROCESS, is not very clear.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]