I created a spreadsheet/graph/table workbook with formulas all correctly laid out.
This is with the intention of extracting a report from my CRM system and pasting it into sheet 3.
The plan was for the tables and graphs to populate themselves based on that data. I tested it with todays list, and it worked fine. I demonstrated it to my senior, and it worked fine too.
So how come when I tedst it again using different sample lists, it shows up as #N/A across the board?
Any advice appreciated
This is with the intention of extracting a report from my CRM system and pasting it into sheet 3.
The plan was for the tables and graphs to populate themselves based on that data. I tested it with todays list, and it worked fine. I demonstrated it to my senior, and it worked fine too.
So how come when I tedst it again using different sample lists, it shows up as #N/A across the board?
Any advice appreciated