log and forms (two different files)linked by Macro

Timl65

New Member
Joined
Dec 9, 2004
Messages
4
I have two worksheets one is a log the other is a form that is filled out from the information log. The log automaticly assigns a sequencial number when lines are typed for each row. I have made a macro that takes that sequencial number copies it to the form (different excel file) saves the log and closes the log keepiong the form open. But, by using the macro I have to write the a different macro for ever row in the log as when the log fills then the sequencial number increases and changes the row assingment. Understand that the sequencial number is in different rows in the log as your fill the log.
Is there an easier way to do this please help!
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,437
Members
410,610
Latest member
renatha prado
Top