Multi Tab Auto Data

Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Add this to the Worksheet Module and type in the Serial Numbers in Column 8

Please Login or Register  to view this content.

mike7952 thanks very much. Had to save file as macro enabled, but afterwards works like a charm. I have one more request that would make this perfect.

once I enter the serial on the weld map tab, it will enter the rest of the data in the weld map tab thanks too you. I would also like that data to get highlighted on the trucks tab that way I can see what got used. Any pipe not highlighted would let me know what hasn't been used yet.

No problem, Not sure what color you wanted. Just add the code below highlighted in red to the If Not Found Is Nothing Then

Please Login or Register  to view this content.

Only thing that comes to me right now is to create a macro with an InputBox to select the cell or cells that you have entered the wrong serial number for. I would add a button to the sheet and link the button to this macro. See attached workbook. Click the button In cell H5. Inputbox will prompt to select cells you want to clear. Select cell or cells in Column H and click okay. Code will clear the values on the Weld Map sheet and also un-highlight the cells on Truck Sheet.