Hi Expert,
Plz give me any formula for diff in string
example-
If cell A1 contain Ashish & B1 contain Ashish
& we want to diff in A1 & B1 then how we can formulate it
Thanks & Regards,
Ankit
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. P
Dear Ashish,
I have copied it but when i am running the code it showing error msg pls
help.
On 3 November 2011 10:53, ashish koul wrote:
> Sub copy_first_sheet_from_different_workbooks_to_single()
> Application.DisplayAlerts = False
> Application.ScreenUpdating = False
>
> Dim fld As Object, fi
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"
.InitialFileNam
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 origina
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 wrote:
> Hello John,
>
> If
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 Membe
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 Pleas
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 codingope
Thanks.your formula is working.
On Wed, Nov 2, 2011 at 4:40 AM, dguillett1 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 file name, etc
>
>
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
$$$
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 will
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
Sal
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 respectiv
I thought I had replied?? Anyway, you need to construct your project so that ab
and bc are the same to col G. Then use a macro like this to copy the
appropriate columns to the bc sheet>and copy that sheet to another file and
save it.
Sub doeach1()
With Sheets("bc")
For i = 5 To 38 Step 13
fname
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 wha
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, Mah
Can anyone help me
From: shashank bhosle
To: "excel-macros@googlegroups.com"
Sent: Wednesday, 2 November 2011 9:28 PM
Subject: Diffrent Sheets to Create from one $
I have an INDI sheet which includes details of each member
Ashish,
Wonderful. Works just as I need. Thank you for your continued help.
John
On Wed, Nov 2, 2011 at 9:02 AM, ashish koul wrote:
> see if it helps
>
>
>
>
> On Wed, Nov 2, 2011 at 4:38 PM, John A. Smith wrote:
>
>> I receive a download which shows Arrival Time as “09/14/2011 0938” and I
>
Thanks both of u for the solution :-) I have different cells in my sheet
which are to be added which includes both text and number. I am not able
generate result with these formulas. Once again help needed.
On Wed, Nov 2, 2011 at 12:11 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> H
I would recommend that you structure your AB sheet and BC sheets the SAME>copy
the columns desired from ab to bc >copy the bc sheet which will make it a new
file>name it>delete the rows NOT needed>save the file. Loop to the next
something like this. However, your project needs to be fixed so tha
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.
2)
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
Congratulations Sam, you are wonderful.
Regards,
DILIPandey
On 2 Nov 2011 01:20, "Sam Mathai Chacko" 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
> the learning.
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, wrote:
> Dear all,
>
> I have many work book in a single folder. I need a macro which if I run
> wi
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 WB
25 matches
Mail list logo
