JJ EXCEL1234
New Member
- Joined
- Jan 30, 2018
- Messages
- 12
Hey all,
Just registered and this is my first post! I have a question that I wasn't able to find on your forum. I use masOS Sierra ver 10.12.6 and MS excel 2016 for mac ver 16.9. I don't have any experience using VBA or MACROs, but if my question requires the use of one or the other I am willing to learn.
Please take a look at my worksheet:
https://imgur.com/cgHYjm3
Each cell is a unique document with various information about the document in that row. The unique document number is the Vol/Page. I have copied documents from an old worksheet that have information filled in already for some of these documents. I need a way to find duplicate rows based on VOL/PAGE only, and then merge the information from the duplicate value that has the data already inputted then delete the duplicate. Is this possible?
thanks
JJ
Just registered and this is my first post! I have a question that I wasn't able to find on your forum. I use masOS Sierra ver 10.12.6 and MS excel 2016 for mac ver 16.9. I don't have any experience using VBA or MACROs, but if my question requires the use of one or the other I am willing to learn.
Please take a look at my worksheet:
Each cell is a unique document with various information about the document in that row. The unique document number is the Vol/Page. I have copied documents from an old worksheet that have information filled in already for some of these documents. I need a way to find duplicate rows based on VOL/PAGE only, and then merge the information from the duplicate value that has the data already inputted then delete the duplicate. Is this possible?
thanks
JJ
