I am working on a project that has information on employees on sheet 1 labeled "ALL". I have a sign-in roster on sheet 2 labeled "Training Roster".
Some of the information on sheet 1 I need to auto update to sheet 2 as I type or end the line to include, borders, fonts, and background fills. Also, deletions.
The cell columns on sheet 1 are D, E & J. The cell columns in sheet 2 are A, B & C.
Sheet 1 starts data at Row 2. Sheet 2 starts data at Row 3.
Sheet 1 complete page is A1:AB118
Sheet 2 complete page is A2:C133
Is there a macro that can help me with this? I have tried numerous types of macros but they are not all fitting to the plan. Some are only doing part of the job.
Can anyone help?
Bookmarks