simplemanny
07-10-2015, 08:46 AM
- I have two worksheets namely “profile types” and “data input”.
- I wish to have a user enter a unique number in cell F4 of the data input worksheet.
- The “profile types” worksheet is then opened, where the unique number entered is cross checked with the numbers present in
cells from ranging from B3 to K3.
- When the same number has been found in the range of cells, on the column in which the unique number was found. Data is then copied from the range of cells with rows 5 to 79. Thus, same column but varying rows from 5 to 79. Example: x5,x6,x7,…x79 are all copied.
- The “data input” worksheet is then opened up and the data copied is then pasted on cells B16 to B90
- I wish to have a user enter a unique number in cell F4 of the data input worksheet.
- The “profile types” worksheet is then opened, where the unique number entered is cross checked with the numbers present in
cells from ranging from B3 to K3.
- When the same number has been found in the range of cells, on the column in which the unique number was found. Data is then copied from the range of cells with rows 5 to 79. Thus, same column but varying rows from 5 to 79. Example: x5,x6,x7,…x79 are all copied.
- The “data input” worksheet is then opened up and the data copied is then pasted on cells B16 to B90