Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

are you using 2003 On Sun, Jun 1, 2014 at 12:18 PM, Michael Lovin wrote: > Wellit appears that it is doing something. (i see as if files open but > just for a second) .but still not populating the master_file...I renamed to > master_file1...and place in the same directory as my student >

$$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

Also I did chck that the files were *.xls and not *.xlsx... even tried that in the VB to see if it worked...but also failed On Sunday, June 1, 2014 11:55:15 AM UTC+8, Michael Lovin wrote: > > I am sure this has been asked many times but I cannot find a thread that > answers my questions.

$$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

Wellit appears that it is doing something. (i see as if files open but just for a second) .but still not populating the master_file...I renamed to master_file1...and place in the same directory as my student files.because of a prompt that your file was "read only"... (idid notice t

Re: $$Excel-Macros$$ Coloms in many workesbooks to rows in a master workbook?

Here is the layout of the source of the datain student1 (sheet1) ... there are many student workbooks , so I need to grab from each workbook the same data (same cell ..row and collum) Score by Category Grammar 67% Reading / Writing 60% Vocabulary 53% Speaking / Listening 68% Here

Re: $$Excel-Macros$$ Coloms in many workesbooks to rows in a master workbook?

do you want data to be pasted in same column ? Can you share a sample input files and output yo like to see? On Sun, Jun 1, 2014 at 9:25 AM, Michael Lovin wrote: > I am sure this has been asked many times but I cannot find a thread that > answers my questions. I have code (pasted below)

$$Excel-Macros$$ Coloms in many workesbooks to rows in a master workbook?

I am sure this has been asked many times but I cannot find a thread that answers my questions. I have code (pasted below) but it does not work and it does not error(no highlight or pop up error message) I have several workbooks with sequential file names..student1, student2, etc. .In

Re: $$Excel-Macros$$ Worksheet Consolidation

Perfect. Thank you !! On Saturday, May 31, 2014 2:44:42 AM UTC-4, Vabz wrote: > > Hi > > Check Attachment.. You can goto sheet Autocopy to do the task.. > > Cheers!! > > > On Sat, May 31, 2014 at 3:10 AM, Bill Q > > wrote: > >> Hi, >> >> I am looking for a macro that would: >> >> - Copy all

Re: $$Excel-Macros$$ Macro Required

Cheers!! On Sat, May 31, 2014 at 3:15 PM, Shrinivas Shevde wrote: > Dear Vibhav > Good Work Very very thanks > > Regards > Shrini > > > On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi wrote: > >> Hi >> >> PFA >> >> All data will be merged into Result sheet, with sheets name in first col. >> >>

Re: $$Excel-Macros$$ Macro Required

Dear Vibhav Good Work Very very thanks Regards Shrini On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi wrote: > Hi > > PFA > > All data will be merged into Result sheet, with sheets name in first col. > > Cheers!! > > > > On Sat, May 31, 2014 at 11:51 AM, Shrinivas Shevde > wrote: > >> Dear al

$$Excel-Macros$$ Minimum difference needed

I need a minimum or zero difference, against the target totals i have set. i have 3 columns, juggle around with figures.there is no barrier to how many you can put in column but use only the figures i give you. I think maybe using a solver or goal-seek is in order. sleek12 I -- Are you =EX