Hi I have 2 different excell spreadsheets...... One is on the network and one resides on my desktop


Spreadsheet 1 (on network) has the following columns
Color, date, solids, ph



I wish to connect the 2 spreadsheets (link the two), such that when data is updated on the network, it updates my desktop

Plus most importatnly, I only want my desktop updated when pH is greater than or equal to 10.0 (so if ph>= 10.0 I want it to record date and color only.....don't want solids data)

Thx in advance