I have a little problem, i have 5 worksheets with data column a is always a article number
column b and c are used for descriptions i want to have a function in sheet6 which looks in all 5 sheets if the number i put in cell a1 on sheet6 is found so if the number is found in sheet1 the row where the number is is copied over to sheet6, if the number is also in sheet3 this row is also copied to sheet 6. when the search is done i have in sheet 6 all rows where the number in column a is the number i searched for.
how can i do this
column b and c are used for descriptions i want to have a function in sheet6 which looks in all 5 sheets if the number i put in cell a1 on sheet6 is found so if the number is found in sheet1 the row where the number is is copied over to sheet6, if the number is also in sheet3 this row is also copied to sheet 6. when the search is done i have in sheet 6 all rows where the number in column a is the number i searched for.
how can i do this