Reply to thread

Message: [QUOTE="minyeh, post: 3861245"] hmm... i don't get what u mean by: {i assume customer 1 goes inbetween """"} Supposedly, ur data for each customer is stored in each individual sheet named accordingly by the customer's name or id so, for example: if the sheet name is named by customer name, "David Paul" then ur reference should be your customer name 'David Paul'!$D$48; if however, it is named after its ID, "DP001" then ur reference should be your customer ID 'DP001'!$D$48; for summary, it is then 'Summary'!$D$48 For indirect, the first "'" is actually " + ' + " (if u count, it's 5 's instead of 8 's u typed), the second part B$1 is ur sheet name, followed by the third part " + !$48:$48 + " if u still can't get it working, ask me for a sample file. [/QUOTE]