hello..I have a Transmittal in Excel for sending out our
drawings to customers and I want to log all transmittals.
If i have the "To:" (company name) in Cell A3 and the date
in Cell D3,the transmittal number in Cell D4, the project
name in Cell D5 and we start listing the drawings and
descriptions in Cells B7 (drawing number), C7 (description)
and if there is more than one drawing the next drawing
number would fall under Cell B7 (in B8) and its
description would fall under C7 (in Cell C8) How would I
have each transmittal data logged in the same worksheet
under a tab named "Transmittal Logs"?
I did this before to copy data from a particular column
have it transpose the column data into a row (transpose =
false) and use XLdown to find the next available row in
the "transmittal log" worksheet and paste that column into
the next blank row.
my question is how would you tell VBA to select certain
cells (ie:A3,D3,D4,D5,B7,C7) from the transmittal
worksheet and copy them to the transmittal log worksheet
transposing into rows in the next available row? Keeping
in mind that some transmittals may have more than one
drawing which would fill in B8 and C8 and possibly B9 and
C9 if there are three drwaings to send out.
Thank you for your help

..

Dick,

See my reply in .worksheet.functions

HTH,
Bernie
MS Excel MVP

"Dick" wrote in message
...
hello..I have a Transmittal in Excel for sending out our
drawings to customers and I want to log all transmittals.
If i have the "To:" (company name) in Cell A3 and the date
in Cell D3,the transmittal number in Cell D4, the project
name in Cell D5 and we start listing the drawings and
descriptions in Cells B7 (drawing number), C7 (description)
and if there is more than one drawing the next drawing
number would fall under Cell B7 (in B8) and its
description would fall under C7 (in Cell C8) How would I
have each transmittal data logged in the same worksheet
under a tab named "Transmittal Logs"?
I did this before to copy data from a particular column
have it transpose the column data into a row (transpose =
false) and use XLdown to find the next available row in
the "transmittal log" worksheet and paste that column into
the next blank row.
my question is how would you tell VBA to select certain
cells (ie:A3,D3,D4,D5,B7,C7) from the transmittal
worksheet and copy them to the transmittal log worksheet
transposing into rows in the next available row? Keeping
in mind that some transmittals may have more than one
drawing which would fill in B8 and C8 and possibly B9 and
C9 if there are three drwaings to send out.
Thank you for your help

.