Dear all,
I have many work book in a single folder. I need a macro which if I run will
copy the 1st sheet of every workbook in a single workbook (though as separate
sheet).
Like if I have 2 workbook viz WB1 and WB2 then I want the 1st worksheet of WB1
as 1st worksheet in a new workbook (say
Hi Sandeep,
Save this attachment in the folder where you have all the workbooks and try
to run the macro (Button) on page 1 of this file.
Hope this helps,
Mrinal
On Wed, Nov 2, 2011 at 2:08 PM, chhajersand...@gmail.com wrote:
Dear all,
I have many work book in a single folder. I need a
Congratulations Sam, you are wonderful.
Regards,
DILIPandey
On 2 Nov 2011 01:20, Sam Mathai Chacko samde...@gmail.com wrote:
Dear Noorain, Dear Haseeb,
Thank you. Noorain, you've already been there. Have learned things
from you. Haseeb, you are a gem of a formula champion. thanks for all
Hi Sam,
I see your point about using the other formatting conditions; it
turns all my significant values after the decimal place to zero. I have gone
through our correspondences and have uncovered this format you previously
suggested: # ### ### ### ###\,00
I have two general issues
So, no takers huh ? .. Anyone .. ?
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
Can anyone help me
From: shashank bhosle catchshashankbho...@yahoo.co.in
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wednesday, 2 November 2011 9:28 PM
Subject: Diffrent Sheets to Create from one $
I
Mahreen, I am getting 1 and -2 as answers, and after looking at the
formula, I don't think there's anything wrong with the result. I am also
able to select NA, or the Scores. Are you facing some other problem? If
yes, please explain.
Regards,
Sam Mathai Chacko
On Wed, Nov 2, 2011 at 7:29 PM,
Kent, that is where I had specifically mentioned that the numbers you write
has to be equivalent to the multiple of that value with hundred. So 0.54
should be mentioned as 54 for the format to work. I did some search myself,
and I couldn't come up with another format that will really do exactly
Dear Friends,
I have an INDI sheet which includes details of each member
I want to make a different workbooks for each of them with the details of
each member
First 3 columns are common for each member and remaining columns from E to
Q changes according to member name in cell E13,R13
First, your asking for a project. Second, your existing code is very
inefficient and should have been included IN the file.
example
selectcase
case =”abc”,”def”,”ghi”:cells(1,3).interior.colorindex=6
case else
end select
==
You should provide after examples using cell references.
Don Guillett
I want to hank all members of this group VERY much for the help! We
did as suggested, but found it became a somewhat arduos task! It was
more accurate to match the 300 vendor-names by eye after both lists
were sorted. We divided and conquered! Job creation!! I appreciate
all the help, and
Why do you keep sending this so often. Have you not seen any replies?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: shashank bhosle
Sent: Wednesday, November 02, 2011 10:58 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Diffrent Sheets to Create from one
Thanks.your formula is working.
On Wed, Nov 2, 2011 at 4:40 AM, dguillett1 dguille...@gmail.com wrote:
If you only have that many why not just do thru a formula where the
file does not have to be open. Notice the placement of the '
You could even use indirect to put in the
You are welcome. As I said, it would be easy to change the variables.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Indrajit $nai
Sent: Wednesday, November 02, 2011 4:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Required help in macro / vba
Mahreen,
If you have multiple ratio values define a name for them each, like Table1,
Table2 choose which table to use.
See the attached.
HTH
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Congrats Sam!
Lots of generous effort on your behalf.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Haseeb Avarakkan
Sent: Tuesday, November 01, 2011 12:21 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Most Helpful
If you only want the finish time without splitting it in to Date and Time,
you could also use
=LEFT(TRIM(A23),10)+TEXT(RIGHT(TRIM(A23),4),00\:00)+(B23/(60*24)) in
mm/dd/ hh:mm format
Regards,
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 5:52 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com
Haseeb, thank you so much for your efforts, that is amazing I must say.
I'm frankly staggered how you achieved that with formulas. Now I must admit
I'm lost as to how you did so, but I kind of need to know if I am to repeat
the task with the next days report. The end of day data that the
Sub copy_first_sheet_from_different_workbooks_to_single()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim fld As Object, fil As Object
Dim ask As Workbook, ask2 As Workbook
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = Choose the folder
.InitialFileName
19 matches
Mail list logo
