Hello all,
I was tasked with combining data from 2 different workbooks with multiple worksheets within them. I need to combine them into one workbook that is formatted uniformly. The problem is that both workbooks have some of the same items within them. I need to take the not redundant items from 'workbook 1' based on the asset number, and then sort them based on their location header value to the corresponding worksheet in 'workbook 2'. The items need to be formatted in the same manner as 'workbook 2'.
I have no idea how to even go about doing this, and I cannot do it manually because it would take days and I don't have that kind of time.
Side note; a lot of these cells are not filled out
If you want a sample I can upload some on my personal computer later, I cannot add the mini sheet add in on my work computer
I was tasked with combining data from 2 different workbooks with multiple worksheets within them. I need to combine them into one workbook that is formatted uniformly. The problem is that both workbooks have some of the same items within them. I need to take the not redundant items from 'workbook 1' based on the asset number, and then sort them based on their location header value to the corresponding worksheet in 'workbook 2'. The items need to be formatted in the same manner as 'workbook 2'.
I have no idea how to even go about doing this, and I cannot do it manually because it would take days and I don't have that kind of time.
Side note; a lot of these cells are not filled out
If you want a sample I can upload some on my personal computer later, I cannot add the mini sheet add in on my work computer