I have say worksheet 1
it has a column with figures in it
worksheet 2
has data filtering on
i want to copy the figures fom worksheet 1 into a column in worksheet 2 which has data filtering on it and the row numbers change eg: 3
7
15 etc etc when i want a certain value in that column...
but when the row numbers change i want them to copy the data from worksheet 1 in its order..
like worksheet 1 row 1= 5
row 2= 11
i want to copy those values into worsheet 2 in the same order as worksheet 1
when i filter worksheet 2 the row numbers change eg 3 , 7 , 15 etc but i want row 3 to have the data in row 1 of worksheet 1
row 7 to have the data of row 2 from worksheet 1
row 15 to have the data of row 3 from worksheet 1
is this possible??
i hope i have explained this properly
Thankyou
Dazza
Bookmarks