Unique positioning of data on excel

[simplemanny]

Copy and paste data.docx

THe problem is attacted, please view. Thanks for the assistance.

[amartinez988]

Need more reference for this.

[simplemanny]

This the original problem that was solved

"I would like to create a macro in which i could place a button on to perform the functions below, cant seem to find any code that does all these things. It would be great appreciated if any one could help. Thank you



- 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"

Now with that data pasted i would like to make another modification withe the attachment above. Does this help?