Deal All,
PFA as per your query.
Regards,
Ankit
On Fri, Dec 9, 2011 at 8:19 PM, dguillett1 wrote:
> You need to give examples
> col b. could/should be from data validation list
> col a. incremented automatically when you enter col B. Example of next
> number
> col c. same as col B using DV
>
Dear Tan,
Find “*” with suffix one or two character and replace only selected suffix
Like find “09*” and replace with “09”
Regards
LAKSHMAN
From: tan dennis
To: excel-macros@googlegroups.com
Sent: Friday, 9 December 2011 5:16 PM
Subject: $$Excel-Macros$$
Dear Friends
Anyone has solved assignment of SMU first semester. if you have then Please
forward.
amreshkushw...@gmail.com, mail2sanja...@gmail.com, always...@gmail.com
Please this is very urgent.
--
***Thanks
Sanjay Kumar Maurya*
--
FORUM RULES (934+ members already BANNED for violation)
1
Looking for Payroll Executive / Sr. Executive with 1.5yrs to 3.5yrs of
work experience in Payroll Domain/Statutory compliance / retrial
benefits in a medium or large organization. Good understanding of
salary structures, employee benefits, tax rules and / or retrial
benefits essential. Person Shoul
hi Don
This is what I have managed to come up with so far which seems to work but
I think its a little crude your opinion would be much apprieciated
this is just in a blank worksheet as yet
Sub copy_hours()
col = InputBox("What column do you wish to paste data into?")
Worksheets("sheet1").Range("
got the ans with lots of other things just check this out.
http://support.microsoft.com/kb/187667
>
> From: hanumant shinde
>To: Excel Group
>Sent: Saturday, 10 December 2011 1:40 AM
>Subject: $$Excel-Macros$$ No. of Occurrence of char in string
>
>
>Hi All,
>
Derived this from Noorain wondeful Solution. Some changes in the way
if have used vba.
Sub CF()
Dim CelRng As Range
LastRow = Range("B3").End(xlDown).Row
Set CelRng = Range("B3:B" & LastRow)
For i = 3 To LastRow
If Cells(i, "B").Value <
Application.WorksheetFunction.Aver
Hi All,
it was an interview que.
how will you find number of occurrence of any character from string.
he said you can do it using 1 excel formula or you can use VBA.
can somebody tell me the answer in both Excel as well as in VBA.
eg. if string is "excel" then there are 2 "e"s in this string.
Hi Tan
Try :
Sub Mtest()
Cells.replace What:="~*", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
*special character must be precede by “~” when you use find & replace option
*
Formula : Assuming Date with special c
Wow.. Wonderfull Sheet Mahesh..
Thanks
Nikhil Shah
On Fri, Dec 9, 2011 at 10:34 PM, Mahesh parab wrote:
> its really Amazing!
>
> check this link
>
> http://www.xcelfiles.com/ImageToXL.html
>
>
>
> HTH
> Mahesh
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use con
Dear Excel Gurus,
Does anyone have the link/torrent to download xlecius full + free version?
I checked various sites, but all are providing xlecius paid version.
Any help with this is greatly appreciated!
Thanks,
Krishnan
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (934+ members alread
Really wonderfull Mahesh..
Thanks to share with US.
On Fri, Dec 9, 2011 at 10:34 PM, Mahesh parab wrote:
> its really Amazing!
>
> check this link
>
> http://www.xcelfiles.com/ImageToXL.html
>
>
>
> HTH
> Mahesh
>
> --
> FORUM RULES (934+ members already BANNED for violation)
Hi Ashish,
Thanks for the help once again. It works perfectly.
Thanks and Regards,
Gargee Singh
Date: Fri, 9 Dec 2011 22:47:50 +0530
Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
Sub tests()
Sh
Dear All
If any body have cheque payment voucher template
I shall be thankful if anybody can assist
V.Kiran Kumar
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code P
Sub tests()
Sheets("call audit form").Range("d1:d10").Copy
Sheets("mtd consolidated").Range("A65536").End(xlUp).Offset(1, 0). _
PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Sheets("mtd consolidated").Range("A65536").End(xlUp).O
Hi Ashish,
If you select both the columns ie D and E in audit sheet and do a paste special
- transpose , that is what it should look like .
Thanks and Regards,
Gargee Singh
Date: Fri, 9 Dec 2011 22:21:01 +0530
Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple ro
whr do u want to paste the remark section
On Fri, Dec 9, 2011 at 10:18 PM, gargee singh wrote:
> Hi Ashish,
>
> Done as required . I am sorry it would be e11:e47.
>
> It would be a very short note kind of thing.
>
>
>
> Thanks and Regards,
> Gargee Singh
>
>
>
> --
>
can you add some content to e11: e 490 and show us how would u like to be
pasted on the mtd sheet
On Fri, Dec 9, 2011 at 9:52 PM, gargee singh wrote:
> Hi all
>
>
> I need yet another help. In the above attached workbook i need to copy
> data from audit sheet and paste it into the mtd consoli
Just select the columns ( D & E ) desired and use
edit>replace ~* with (leave BLANK)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: tan dennis
Sent: Friday, December 09, 2011 5:46 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ To remove the character "*
Dear Dennis,
SAM solution is great
You can also use below macro to select area where you want to remove *.
*Sub Remove_star()
Dim rng As Range
For Each rng In Selection
rng.Value = Application.WorksheetFunction.Substitute(rng, "*", "")
Next
End Sub
*
--
Thanks & regards,
Noorain Ansari
=SUBSTITUTE(D9,"*","")
or
=--SUBSTITUTE(D9,"*","") if you want to ensure it is equivalent to the date
value
Regards
Sam Mathai Chacko
On Fri, Dec 9, 2011 at 5:16 PM, tan dennis wrote:
>
>
> Hi All
> I have a spreadsheet with 4000 row of records, I need to remove the
> character "*" in cells w
You need to give examples
col b. could/should be from data validation list
col a. incremented automatically when you enter col B. Example of next number
col c. same as col B using DV
col I. “agreement sheet” ?
col J. populated on what__occurring.
Don Guillett
SalesAid Software
dguille...@g
Dear Expert,
Please help me to solve out query in attached excel.
Here one excel file where I want to do some column automatically.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
http://www.youtube.com/watch?v=9bat12gH3Qs
http://www.cometdocs.com/
third party converters >google xls to xlm
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Iqbal Merchant
Sent: Friday, December 09, 2011 1:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert X
Send me your file with a complete explanation (reply to this msg) and
examples.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: trawets
Sent: Friday, December 09, 2011 2:02 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ choose column when ru
Hi,
Find the attached file.
Regards,
MARIES.
On Fri, Dec 9, 2011 at 12:55 PM, Renukachari Kasee wrote:
> hi thanks for you valuble replay
>
> but i need like this can you see this attachment
>
>
>
> On 8 December 2011 18:56, Renukachari Kasee wrote:
>
>>
>> *(¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨)
hi thanks for you valuble replay
but i need like this can you see this attachment
On 8 December 2011 18:56, Renukachari Kasee wrote:
>
> *(¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!!
> `•.¸.•´
> Thanks & Regards´¨)
> ¸ •´ ¸.•*´¨) ¸.•*¨)
> (¸.•´ (¸.•* ♥♥♥...♪♪
Thanks for your reply
My sheet is probably a bit crude but I'm working on it
the ranges above are just me trying get this working,
what is happening is that I have a list of tasks around 300 or so
which I have to declare a weekly % progress against, these are not
listed from 1 - 300 but something
28 matches
Mail list logo
