Search within many Sheets for a specific formula, select cell, offset and copy a value

[jgiordano]

Hi guys!

First, i want to warn you that i'm new in VBA (yep another one!) and i know this question is quite simple but every answers/explanations i found were to complicated for me to understand and didn't suit my needs.

Here the problem :

I created a very simple Userform that use combobox that gather names from a specific sheet. No problem here. Once i select a name and click a button, i want it to copy on every other sheets starting from specific sheet and end to another specific sheet. My principal problem is that the location (cell) where i want to copy the information is not fixed !

So the solution i found is to create a macro that will, for example the first sheet :
- Search for "='Home Page'!$B$117" within the formulas (yes because all the text in my worksheets refer to another sheet, this one simply return "Done by :". I guess (not sure) i can't simply search for the string "Done By :"...
-Select the cell and offset by 1 to the right
-Paste a value that i previously stored in a variable (DoneBy = DoneByCombobox.Value) which is the name of a person selected
- Go to next sheet, repeat the operation (im really not into loops right now, dont know how it works yet)

I want this operation done starting with the Sheets(4) till ...Sheets(???) I couldnt figure how to solve this problem but i guess that if there is no cell containing formula "='Home Page'!$B$117" in the sheets where i don't want the pasting apply, it will stop at the right sheet...

Since i'm a noob in VBA is it possible to identify the different part of the code so it will easier to understand and learn...

Hope my problem description isnt to confusing.

Thanks a lot !

[jgiordano]

I would accept any hint :I like what to google or which function i will need to use especially for the "search" part of my problem

thanks