Forum Discussion

NorthStarx2's avatar
NorthStarx2
Copper Contributor
Sep 27, 2024

EXCEL - HELP WITH LINKING WORKSHEETS AND CREATING FORMULAS

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!

This one is called counts

File to pull the tag info is called Tags

Sample data from tags is below:

 

 

 

 

3 Replies

    • NorthStarx2's avatar
      NorthStarx2
      Copper Contributor
      Thank you for that information. Uploaded sample file.
      https://filetransfer.io/data-package/XuFzGJdR#link
      • NorthStarx2's avatar
        NorthStarx2
        Copper Contributor
        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.

Resources