I have a question.
i have 3 sheets, i like to search for a value for example 3 in the first 2 sheets
and if it is found in sheetsthen copy the row from the sheet and paste it in sheet3, the same for sheet2 if it is also found there then copy it in sheet3.
number of sheets is not always the same so i thought for each ws , but i get lost after it.
anyone knows how to search across multiple sheets and paste it in 1 sheet.
i have 3 sheets, i like to search for a value for example 3 in the first 2 sheets
and if it is found in sheetsthen copy the row from the sheet and paste it in sheet3, the same for sheet2 if it is also found there then copy it in sheet3.
number of sheets is not always the same so i thought for each ws , but i get lost after it.
anyone knows how to search across multiple sheets and paste it in 1 sheet.