Hello...I have a tranmittal on a worksheet tab
named "transmittal" and I need to log the drawings sent or
listed to a "Transmittal Log" worksheet tab every time we
fill out a new transmittal.
the range of info I need is in Cells D23:G36 (4 columns
wide) on the "Transmittal" worksheet. Sometimes only rows
23,24 may be filled in, other times 23,24,25,26 may be
filled in and so on. I used range ("D23, Range D23
(xldown).Address).end to have the cursor start in D23 and
go down till it hits a blank row but im not sure how to
tell VBA to hilite it across to column G. Column D is
labeled "Quantity", E is labeled "Dwg. No.", F is
labeled "Drawing Description", and F is labeled "Dated".
Once the appropiate cells are hilited it will be copied to
the Transmittal Log worksheet tab on the next available
row down. I forget how to tell VBA how to go to Column A
on the transmittal log worksheet and xldown to it hits the
next blank row in column A.
the next time someone uses this transmittal for different
drawings it will then have to be logged also to the log
sheet on the next blank row down.
your help will be appreciated.
God Bless