CODEWITHSUNDEEP
excelexcel-formulavba
zahedjoy009
zahedjoy009

Reputation: 1

Fetching data from other tabs

I want when I write "Yes" in "Count" column of "IP_Details" tab, it will automatically add (+1) to the "Used IP" column of "Dashboard" tab. So when I am using any IP, I don't need to edit in the Dashboard for that entry.

Here I have attached screenshots of this issue.

1st Tab
1st Tab

2nd Tab
2nd Tab

Upvotes: 0

Views: 37

Answers (1)

Michał Turczyn
Michał Turczyn

Reputation: 37430

Under Used IP you can enter formula: =COUNTIF(IP_details!D2:D100,"=yes"), under Remaining IP you can enter Total IP minus result of given formula.

Apllying OP's remarks below (coments), here's modified answer:

=COUNTIF(Public_IP!D2:D100,"=yes") + COUNTIF(Private_IP!D2:D100,"=yes")

Upvotes: 1

Related Questions