T
thead
I have 4 worksheets and a master sheet. Each of the 4 worksheets
contains rows of information (line items) on tasks being performed at
4 work sites. I would like to check a specific column (for those rows
that actually contain content) on each of the 4 worksheets. If the
specific column ("Date Completed") does NOT contain content, I would
like to copy the entire row from that worksheet to the master sheet.
The idea behind all of this is to document work that is still in
process and have it pasted to the master sheet. The lack of content
(no completion date entered) in the subject row/column on each of the
4 worksheets indicates that the line item is still in process at the
work site. Hope this make sense. If anyone can assist, it would be
greatly appreciated. I am researching also, but I only have a few days
to address this and I am completely new to Excel programming.
Thead
contains rows of information (line items) on tasks being performed at
4 work sites. I would like to check a specific column (for those rows
that actually contain content) on each of the 4 worksheets. If the
specific column ("Date Completed") does NOT contain content, I would
like to copy the entire row from that worksheet to the master sheet.
The idea behind all of this is to document work that is still in
process and have it pasted to the master sheet. The lack of content
(no completion date entered) in the subject row/column on each of the
4 worksheets indicates that the line item is still in process at the
work site. Hope this make sense. If anyone can assist, it would be
greatly appreciated. I am researching also, but I only have a few days
to address this and I am completely new to Excel programming.
Thead