Hi
I am working on a Quotes Database which records daily quotes. Each week I need to send this out to various offices to follow up on the status of these quotes. Instead of giving them access to my master sheet (Tab MasterDB) I would like to have them enter their feedback in the tab Feedback. So I need all the data (all columns and rows) to be copied into the tab feedback automatically. Also any new entries in the Master tab should automatically update in Tab Feedback.
I tried using a Microsoft Query but it keeps giving me an Error of "Too few parameters. Expected 1" and I have no idea what that means or how to resolve it. Is there any other way of achieving this? Or please help to resolve this error..
Secondly, in Microsoft Query there was an option to filter the data - so I could have a tab for each office and when I update the master tab, the office tabs would update automatically. If possible, I would like to set up my database in this manner so each individual office can access the quotes relevant to them without sorting through other offices.
Thanks for your help.
(attached file for your reference)
Bookmarks