VLOOKUP Copy and Paste Tracking Onto Different Sheets

[Fredbugatti]

I am trying to create a macro Button that will copy the shipment ID On Column C in Sheet 1 and Lookup Order Number On Sheet 2 Column B then Format Tracking Number to Regular Numbers from Scientific Notation and Copy and Paste to Column D in Sheet 1 and also copy and paste Date Shipped on from Sheet 2 Column B to Sheet 1 Column E.

I have attached Spreadsheet as an example.

Would appreciate the help!

[Punnam]

Copy and Paste Tracking Numbers.xlsm

Hi,


Please check this sheet i have provided a simple solution based on my observation with respect to your data


With Regards,
Ravi kumar

[Fredbugatti]

Hi Ravi,
Can you please create a button that will do this for me, I really appreciate it!

[Punnam]

Hi Fredbugatti,

I am not good at macros, creating & assign then to button require knowledge of macros, as i concerned you can just copy and paste formula that will be sufficient any way I will try to find it let u know the status.

With Regards,
Ravi Kumar

[GIS2013]

Hi Fred, I've used Ravi's idea to create a simple macro, see attached file's last sheet ("button"). Let me know if it works for you.

[Fredbugatti]

Hi GIS2013,
This is great works very good,but one minor issue if it can not find order number in Sheet 2 it does not put the rest of the info in it gives me an option to end or debug. Would you be able to make it put all the info in and leave the ones that do not match blank ?

[Punnam]

Hi GIS2013,

Thanks helping

[GIS2013]

Fixed it, see attached. Note that the macro checks USEDRANGE (VBA's property) in sheet1.
If works ok now, please marked as SOLVED.

[Fredbugatti]

Toda! I really appreciate the help!!

[GIS2013]

You are welcome