Forum Discussion
spalmer
Jul 12, 2020Iron Contributor
Excel Vlookup or Indirect
hey everyone, hope all is well. i have built a spreadsheet using slicers to track Overtime through out the year. in my spreadsheet i have 26 tabs for 26 pay periods to track 2 different types of ov...
TheAntony
Jul 12, 2020Iron Contributor
spalmer , I went with a Power Query solution in case you need to add more pay period sheets. This will work as long as the new pay period data are in tables. It just excludes the Roster Table.
- spalmerJul 12, 2020Iron ContributorSo not sure if this will matter but my company that bought the excel doesnt have power query. I tried using that and it doesn't show up when inputting it. Is there another way beside power query