Tuesday, 13 February 2018
  1 Replies
  5.8K Visits
0
Votes
Undo
I have a worksheet with thousands of rows of data. In column a it is Part # and Column B is Quantity. There are multiple rows for each Part #, but the Part # is only input on the first line and none of the corresponding lines. I am needing to copy down the Part # to all of the blank cells below it and repeat for each new Part #. I am having to do this, because in the end I will be doing an Advanced Row Combine based on Part # and have it add the Quantity. Is there a much easier way to do this rather than me constantly copying and pasting or dragging down to copy the cells?

Thanks,
Chad
6 years ago
·
#1466
0
Votes
Undo
Hello,
Please try to create some sample data in a new workbook to demonstrate your operation.
Please contact me via
  • Page :
  • 1
There are no replies made for this post yet.