Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Nasir Saikh
Yes but its not working one one user is using at a time when other opening its showing read only On Wednesday, March 18, 2015 at 8:26:24 PM UTC+5:30, Swapnil Palande wrote: > > Hi Nadir, > > If you share work book you will not get this error. Are you sure you have > share it? > > Regards, > > S

$$Excel-Macros$$ Macro to Copy Active Sheet

2015-03-18 Thread Stephen E. Hale
I have written a macro that copies from a master sheet and places the new sheet after the last sheet. The macro is triggered by the "New Week >" button on the master sheet. I want the macro to copy from the active sheet instead of the master sheet. Any help is much appreciated. If anymore info

RE: $$Excel-Macros$$ Re: vba recorded macro not working

2015-03-18 Thread Mike Barrett
Hi Mandeep, I was wondering all of the data that your macro produces on a daily basis amounts to a large table which I then append to the master table which has the entire months’ worth of data, then I update the range on my Pivot table and RefreshAll to update the Pivot table; is this somet

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Swapnil Palande
Hi Nadir, If you share work book you will not get this error. Are you sure you have share it? Regards, Swapnil On 18-Mar-2015 4:30 pm, "Nasir Saikh" wrote: > Dear Anil, > > Thanks for your reply but the query have not solved. > I already given the access to the users but only one user can use

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

2015-03-18 Thread saravanan R
Hi Mandeep, Thanks a Million. I have one more query related to the same file, is it possible to split the file based on "Status" OK wrt to each Coleague. and file name should be QueryDup-FK & QueryDup-BD (colleague name will be dyanmic) thanks in advance. On Wed, Mar 18, 2015 at 5:25 PM, Mande

$$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

2015-03-18 Thread Mandeep baluja
Try this .. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote: > > Hello Team, > > I have an Query regarding Duplicate check for certain Crite

$$Excel-Macros$$ Query Regarding Duplicate and Update Status

2015-03-18 Thread saravanan R
Hello Team, I have an Query regarding Duplicate check for certain Criteria in filter. I need this to be in VBA Code . Please see the details below and find the sample attached file with expected result mentioned. I have to filter for FK (Column "B"), Then find duplicate DOC.no for this colleague

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Nasir Saikh
Dear Anil, Thanks for your reply but the query have not solved. I already given the access to the users but only one user can use at a time if another wants to use then previous user is closing the excel then an other user can use otherwise it is showing in read only. I want that if one user al

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Michael Vinoth
Hi Nasir Saikh, Try this:- https://support.office.com/en-ca/article/Use-a-shared--workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61?ui=en-US&rs=en-CA&ad=CA Regards, MV > On 18-Mar-2015, at 3:51 pm, Nasir Saikh wrote: > > Anybody Can help me out on this > >> On Wednesday, March 18,

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Anil Gawli
Dear Nasir, You need to share with specific people by specifying with their username On Wed, Mar 18, 2015 at 3:51 PM, Nasir Saikh wrote: > Anybody Can help me out on this > > On Wednesday, March 18, 2015 at 1:46:59 PM UTC+5:30, Nasir Saikh wrote: >> >> Hi, >> >> I need help to make a excel work

$$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Nasir Saikh
Anybody Can help me out on this On Wednesday, March 18, 2015 at 1:46:59 PM UTC+5:30, Nasir Saikh wrote: > > Hi, > > I need help to make a excel workbook which should use by more than 5 > members at a single time and all can save the workbook at a time. > > Please help me i am stuck on it > > Rega

$$Excel-Macros$$ Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Nasir Saikh
Hi, I need help to make a excel workbook which should use by more than 5 members at a single time and all can save the workbook at a time. Please help me i am stuck on it Regards Nasir Shaikh 876702 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:I