Hi All,

Thanks for the wonderful resource. Generally find answers to my questions rather quickly without needing to ask, but in a bit of a crunch this time

I have a sheet set up w/vb interfact to collect results data against existing rows of inventory data. Each row has a unique ID number that is used to track the inventory record, with a handful of blank columns for results to update into.

Due to system limitations, I'm stuck using excel for now, and will be distributing multiple copies of this book to collect data, and then need to combine these back to the existing master sheet. Everyone will have the same set of data, but will be filling in results against different segments of the dataset.

Basically, if results columns have data, match the corresponding ID# in column A and update columns Q - Z, for multiple copies of wb.

Thanks in advance!