Here I go again!

Sumeluar

Board Regular
Joined
Jun 21, 2006
Messages
241
Hello all!

I have two templates.
One is used by all the technicians to enter the equipment they worked on during the day, each individual entry is copied, saved and printed.
The second template I have to go sheet by sheet for that specific date and enter the daily activity manually.
Is there a way to create to copies of each and have the second teplate to automatically acquire the entries and copy them in to the first empty cell, starting from c5, c6 and so on?

Kind regards!

Sumeluar
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
yes there are ways of doing it. Without knowing the layout of your files, I can't help. however you can write macro with the following code, put it in a suitable loop (for next or do while) and get what you want.

Cells(5,3) = workbooks("file name.xls").worksheets("sheet1").cells(5,3)

change parameters to suit your conditions. let me know if you still need help

ravi
 

Watch MrExcel Video

Forum statistics

Threads
1,113,984
Messages
5,545,345
Members
410,678
Latest member
glasi
Top