aamirsq
Member
What i am trying to achieve is create a file and link all files on network drive (as i have to copy manually), File names are always 01 Jan 2013, 01 Feb 2013,01 Mar 2013, ... so on & usually Data is only on Sheet1 Starting from A6 to O100.
Problem is sometimes other peoples have opened these files & i have 'readonly' access only.
Btw when i tried pasting the link i came up with this
{=Excel.Sheet.8|'192.100.6.180Sales3 Request For Quotations1 RECEIVED RFQs20131 Jan 2013 - RFQ Received.xls'!'!Nov 2012!R6C1'}
i was think...separate sheet for each month..
Regards
Problem is sometimes other peoples have opened these files & i have 'readonly' access only.
Btw when i tried pasting the link i came up with this
{=Excel.Sheet.8|'192.100.6.180Sales3 Request For Quotations1 RECEIVED RFQs20131 Jan 2013 - RFQ Received.xls'!'!Nov 2012!R6C1'}
i was think...separate sheet for each month..
Regards