markman235
New Member
- Joined
- May 10, 2011
- Messages
- 46
Hi everyone,
I have a sheet with several hundred line items. Columns A - I are only populated at the start of each unique PO.
So if i have a PO with 5 line items, columns A - I would have the PO data in row 1, but 2 - 5 would be blank. Row 6 would be populated with the data from the next PO.
Is there an easy way with either a macro or formula to get these columns to copy data to the blank cells?
Thanks everyone,
Mark
I have a sheet with several hundred line items. Columns A - I are only populated at the start of each unique PO.
So if i have a PO with 5 line items, columns A - I would have the PO data in row 1, but 2 - 5 would be blank. Row 6 would be populated with the data from the next PO.
Is there an easy way with either a macro or formula to get these columns to copy data to the blank cells?
Thanks everyone,
Mark