Hi all,
Got what I will assume is gonna be an easy enough answer to you Excel gurus, and there are probably a million examples readily available from Google but I simply can't seem to phrase my query properly, so I'll try here, bear with me.
I have a workbook with a number of sheets that track various information/progress of setting up new pc's for an organisation. Now it works perfectly fine for what it does, but I am hoping to improve on the entry by having some of the cells update once information is entered elsewhere in the Workbook.
I have attached a screen grab of 1 section that I simplified with snippets from sections of 2 worksheets that will give the visual aide to my written query.
For ease of reference Rows 1-7 would be Sheet1 and Rows 8-14 would be on Sheet2
So A3-A6 basically lists the name of the PC as entered of it's company assigned label, which is automatically updated on A10-A13, have that workinng no problem.
The red cells of B10-E13 get a "Y" entered when that particular task has been carried on the relevant pc, and change to a green for a quick visual guide for what is left to be done to the pc.
What I am looking to do is when the Teamviewer ID for example is entered in its relevant cell, that the corresponding cell on the the other sheet would update to a "Y"
Example: Teamviewer ID is entered in C3, then B10 would update from an "N" to a "Y" and if D5 has an AnyDesk address entered C12 would update to a "Y" as the software has obviously been installed.
I hope this is a bit clearer than mud and look forward to your responses.
I enjoy learning new things with Excel, so this will be a nice addition to my limited arsenal.
Thanking you all in advance
Got what I will assume is gonna be an easy enough answer to you Excel gurus, and there are probably a million examples readily available from Google but I simply can't seem to phrase my query properly, so I'll try here, bear with me.
I have a workbook with a number of sheets that track various information/progress of setting up new pc's for an organisation. Now it works perfectly fine for what it does, but I am hoping to improve on the entry by having some of the cells update once information is entered elsewhere in the Workbook.
I have attached a screen grab of 1 section that I simplified with snippets from sections of 2 worksheets that will give the visual aide to my written query.
For ease of reference Rows 1-7 would be Sheet1 and Rows 8-14 would be on Sheet2
So A3-A6 basically lists the name of the PC as entered of it's company assigned label, which is automatically updated on A10-A13, have that workinng no problem.
The red cells of B10-E13 get a "Y" entered when that particular task has been carried on the relevant pc, and change to a green for a quick visual guide for what is left to be done to the pc.
What I am looking to do is when the Teamviewer ID for example is entered in its relevant cell, that the corresponding cell on the the other sheet would update to a "Y"
Example: Teamviewer ID is entered in C3, then B10 would update from an "N" to a "Y" and if D5 has an AnyDesk address entered C12 would update to a "Y" as the software has obviously been installed.
I hope this is a bit clearer than mud and look forward to your responses.
I enjoy learning new things with Excel, so this will be a nice addition to my limited arsenal.
Thanking you all in advance