Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-30 Thread De Premor
you may share your current code, maybe we can find whats wrong with it Pada 30/07/2013 18:36, Puttu * menulis: Really i tried my best, but didn't worked out. thus the reason seeking for help On Tue, Jul 30, 2013 at 3:59 PM, De Premor > wrote: Hi Putu, While

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-30 Thread Puttu *
Really i tried my best, but didn't worked out. thus the reason seeking for help On Tue, Jul 30, 2013 at 3:59 PM, De Premor wrote: > Hi Putu, > > While you're waiting for a groups response, why dont you start writing your > own code, you might want to read more about : > > Select a file usi

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-30 Thread De Premor
Hi Putu, While you're waiting for a groups response, why dont you start writing your own code, you might want to read more about : Select a file using Application.GetOpenFilename Open a workbook using Workbooks.Open Assign a value to variable using Set... = Looping each worksh

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-30 Thread Puttu *
please please advise, it's very important for me... On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote: > Hi Experts, > > Need a help on copying the data from one workbook (Reference) to another > workbook (master). I know asking too much, appreciate could you please help > me on this coding. >

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-30 Thread Puttu *
Experts really need your help on this macro.. please please On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote: > Hi Experts, > > Need a help on copying the data from one workbook (Reference) to another > workbook (master). I know asking too much, appreciate could you please help > me on this c

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-29 Thread De Premor
ups sorry, please ignore my last email, i've replied a wrong topic My bad :-\ Pada 29/07/2013 19:37, De Premor menulis: Try to use this in cell B2 *=VLOOKUP($A2,INDIRECT("'" &B$1 & "'!$B$2:$R$302"),16,FALSE)** * Copy it down Pada 27/07/2013 20:44, Puttu * menulis: Experts your assistance is

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-29 Thread De Premor
Try to use this in cell B2 *=VLOOKUP($A2,INDIRECT("'" &B$1 & "'!$B$2:$R$302"),16,FALSE)** * Copy it down Pada 27/07/2013 20:44, Puttu * menulis: Experts your assistance is much appreciated. On Sat, Jul 27, 2013 at 4:55 PM, Puttu * > wrote: Hi Experts, Ne

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-29 Thread Puttu *
please help me on the macro.. On Sun, Jul 28, 2013 at 10:14 AM, Puttu * wrote: > Any updated on the macro team.. > > > On Sat, Jul 27, 2013 at 7:14 PM, Puttu * wrote: > >> Experts your assistance is much appreciated. >> >> >> On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wr

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-27 Thread Puttu *
Any updated on the macro team.. On Sat, Jul 27, 2013 at 7:14 PM, Puttu * wrote: > Experts your assistance is much appreciated. > > > On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote: > >> Hi Experts, >> >> Need a help on copying the data from one workbook (Reference) to anoth

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-27 Thread Puttu *
Experts your assistance is much appreciated. On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote: > Hi Experts, > > Need a help on copying the data from one workbook (Reference) to another > workbook (master). I know asking too much, appreciate could you please help > me on this coding. > > The work