I have 2 Spreadsheets
- Spreadsheets 1 has my main Data E.g. client Name, email, Contact Number, Payment done
enter image description here
- spreadsheet 2 where I’m importing the data from Spreadsheet 1 using query and importrange and I marked yes where call audit done for client.
enter image description here
The problem here is when updating the spreadsheet let’s take an example of row 1 where the current data is from a spreadsheet is for Name – Abs and I marked yes for Name ABC. But when I make changes in Spreadsheet 1 i.e. row number 4 client Name “SPS” marked payment completed.
enter image description here
Then my spreadsheet showed the changes but where I marked yes for the client Name in spreadsheet 2 it’s not moving along with for which I marked yes for the client name. My Yes it is there as it is.
enter image description here
I want it to move along with the same client name for which I marked yes
enter image description here
Vineet Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.