Hello. I would like to write a macro for the following. I have a "data" sheet with Id's in the first column (through row 11) they are number 1-10 but not in order. There are also 3 additional columns of information to the right of these Id's. I would like to select each ID number and that row and copy it into cell A of the corresponding sheet. So, if the ID is 1, I would like to copy that into row into "Sheet1". I already have created 10 sheets with the names (Sheet1, Sheet2,...., Sheet10). Thanks.
Bookmarks