Using Unique Value in Column B. How to find the same row of information on another sheet

[bg_enigma1]

So I currently have a multisheet workbook where the first tab "Pipeline" is where all data is entered, depending on a few other pieces of information that is entered, the row of data is also pasted in one of the other 5 worksheets. Each entry has a unique number with the intention of if I change information on "pipeline" for an entry, on change() it will find that row's uniqueID and search the other 5 worksheets for that same number, and then updates the information on that sheet as well. I currently do not know how to code to search column B of the row that is being changed for the same ID in another sheet and select a cell in that row.

Sorry for not having any code but I don't really know how to start.

[MaczaQ]

hi bg_enigma1

I don't know if I correctly understood what you need but I have following idea

let say we have 3 sheets:
sh1 = main sheet
sh2 = first data sheet
sh3 = second data sheet
and now we have code for searching

Please Login or Register  to view this content.

sorry if there is any bug but I write it without debugging in VBE

[bg_enigma1]

Let me try to explain a little better. I have a tab named "Pipeline" that has all the original data (kind of a repository when data is entered into my workbook) as you can see in Column A is "unique ID" which correlates with the "uniqueID" in the other tab (this tab is named "A2D2") but there are 4 other tabs that look exactly like A2D2 just with data for other categories.
Forecast.png

I want to be able to update data on "A2D2" or any of the other 4 tabs. When a cell is updated, it looks at the row's unique ID (in column B) and goes back to "Pipeline" Column A to match the unique ID. When it matches the unique ID, it will update that entry with what was changed on the previous tab. Does that make more sense?
pipeline.png

[bg_enigma1]

is this even possible to do?