Hi, I have what I hope is an easy question. I have two files containing the following tables:
Table 1, which i will send to Jim to fill out monthly (this is the table that Jim has filled out):
Property Code Comment Manager
VAN1029 This needs a site visit Jim
VAN1022 HVAC needs work Jim
VAN2019 Susan
VAN2011 Jim
VAN2919 Susan
VAN1111 No visit required Jim
Table 2, which i will send to Susan to fill out monthly
VAN1029 Jim
VAN1022 Jim
VAN2019 Probably a site visit Susan
VAN2011 Jim
VAN2919 Susan
VAN1111 Jim
I tried to merge them but i get this:
VAN1029 This needs a site visit Jim
VAN1022 HVAC needs work Jim
VAN2019 Susan
VAN2011 Jim
VAN2919 Susan
VAN1111 No visit required Jim
VAN1029 Jim
VAN1022 Jim
VAN2019 Probably a site visit Susan
VAN2011 Jim
VAN2919 Susan
VAN1111 Jim
In other words, all properties appear twice because excel put the tables on top of each other. What i want is this:
VAN1029 This needs a site visit Jim
VAN1022 HVAC needs work Jim
VAN2019 Susan
VAN2011 Jim
VAN2919 Probably a site visit Susan
VAN1111 No visit required Jim
Can someone help?
Thanks,
Cam
Hi Jim,
Please supply the workbooks so we don't have to type everything in again. We can't write the query without the data 🙂
Thanks
Phil
Hi Cam/Jim (not sure which name to use),
Do you have an Office 365/Microsoft 365 licence? If so, you can use workbook co-authoring to allow both Susan and Jim to work in the same file at the same time, thus avoiding this hassle altogether.
Mynda
Hi All,
Thanks for the reply. Attached are my files. This time i wasn't even able to recreate what i had talked about above, but my goal is still the same. Have both Jim and Susan's tables merge into one.
Thanks,
Cam
Hi Cam,
You didn't answer whether or not you have Office 365?
Attached is a solution. Load Jim's properties in a query, load Susan's in another, then append the two.
Regards
Phil
