Need a Macro code to copy and paste cells

[mole_man]

I every day have to open up an Excel File that a rep created the previous day (Job Card).

I then copy certain info from that file and then paste it in a different Excel File (Fitment List For The Year). I do this to have all the info for the different clients for the year in one Excel File.

This is time consuming as I have to copy +/- 10 cells, each 1 at a time in the Job Card and then paste it in the Fitment File. This means I copy and paste about 10 times just to transfer info from 1 file to the other.

I have tried using the MACROS method where you record your actions. This works great but only for the specific job card. When I try to do the same for a different Job Card the code pics up the previous Job Card’s name and does not work.

Please help me, I would greatly appreciated it.


P.S: I can attach an example of the 2 Files (Job Card & Job List) and indicate exactly what I am trying to explain above. I use office 2013.

[TMS]

I can attach an example of the 2 Files (Job Card & Job List) and indicate exactly what I am trying to explain above. I use office 2013.

1. yes please.
2. your profile says you use 2007

Regards, TMS

[mole_man]

Job List.xlsxJob Card.xlsx

Ok I have attached the 2 files. The cells that I highlighted in green in the Job Card file is the cells that I would copy into the Job List file.

Thank your for your help!

your profile says you use 2007

Oops I must change that.

[mole_man]

I want to cry with your title.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#1 and amend your title
Then anyone will be able to help you.

Oops, I apologize!

How would I amend the title?

[Fotis1991]

Use the link that i provided. See rule#1. There is the description for how to change the title there.

[mole_man]

Ok so will it be possible for me to create a Macro to copy and paste cells as requested or am I living in a dream world?