I have a "Start" sheet that the user adds a 6 digit ID in B:2, selects a username from a dropdown in B:3. B4 has today's date.
I need to copy the ID, Name and Date to Sheet "Complete" into Column B(ID), C(Name) and D(Date) where column A(Comment) will have unknown # of rows.
Start Sheet:
ID 999999
Name Doe, John
Date 11/29/13
Complete Sheet:
Comment ID Name Date
Test1 999999 Doe, John 11/29/13
Test2 999999 Doe, John 11/29/13
Test3 999999 Doe, John 11/29/13
Test4 999999 Doe, John 11/29/13
Test5 999999 Doe, John 11/29/13
Thanks in advance!
Bookmarks