I am in the process of creating a dashboard to monitor performance for a small distribution center. On "Sheet 1" I'm designing the layout for a "dashboard" which will contain 4 separate columns (receive, stow, pick, pack). Each column refers to an employee task (i.e: receiver, stower, etc).
On "Sheet 2", I'm importing data from our companies internal system using a web-based query which will refresh every 30 minutes. The data shows the names of the associates who are currently performing which tasks (i.e: receive, stow, etc.). I can easily create formulas on "Sheet 1" that read "A1 on sheet 1 = A3 on sheet 2", but my problem is that the information that i'm pulling from the internal system rearranges itself every time it refreshes. The reason for sheet 1 is to pull only the data I need off of sheet 2 (from web). The data on sheet 2 lists information for the entire distribution center, and I only need certain data for my area.
Since the data from the web is constantly refreshing and moving from cell to cell, is there any way (macro or formula) to force excel to pull data into sheet 1 from sheet 2 that includes only certain text or headers? I.E: if there was a header on sheet 2 that read "receive", the only information that would pull onto sheet 1 would be the names of associates listed in the cells below the "receive" header.
Bookmarks