EXCEL - HELP WITH LINKING WORKSHEETS AND CREATING FORMULAS

Occasional Reader

Hi,

 

I am trying to pull information from Tab A into Tab B, and then making a few calculations and a variance flag.   Looking for guidance on how to accomplish this.   I dont see where I can upload a sample file, so here are some pictures.  

 

Thank you!

NorthStarx2_0-1727478462815.png

This one is called counts

File to pull the tag info is called Tags

Sample data from tags is below:

NorthStarx2_1-1727478542279.png

 

 

 

 

3 Replies

@NorthStarx2 

 

https://filetransfer.io/

 

If possible,Share files here and post back the download url.

Thank you for that information. Uploaded sample file.
https://filetransfer.io/data-package/XuFzGJdR#link
I think I figured out the formulas and used conditional formatting. I am still stuck with trying to figure out how to get the data from my tags tab onto my count sheet tab. Thank you.