Ur welcome friend, yaa it happens most of the time and with most of the
people also.
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pankajinfo
Sent: Tuesday, September 03, 2013 9:21 AM
To: excel-macros@googlegroups
Dear Prajakt Pande,
Has it has lots of rows init. It will take nearly 5 min, so have patients.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 3, 2013 at 10:07 AM, अनिल नारायण गवली
wrote:
> Dear Prajakt Pande,
>
>
Thank You Ravi So Much for providing this code.
this code can be used by Excel users whose data is used for presentations
but they do not get credit for data compiling.
On Fri, Aug 30, 2013 at 11:32 AM, Ravi Kumar wrote:
> Dear Pankaj,
>
> ** **
>
> ** **
>
> There is some changes in the c
Ups Sorry, i've forgot a line code for unlocking you sheet protection
See at Line 4 and last line that i've bold
Sub check()
Dim Birth As Range, PANo As Range, UserInput, Arr
Set Birth = [G2]
Set PANo = [j2]
*Sheet5.Unprotect
*If IsEmpty(Birth) Then
Birth.Interior.Col
Hi Pankaj,
On column C you could write the following formula
=trim(a1)& " " &trim(b1)
You will have no leading or trailing spaces when paste the content of
column C in the Notepad for instance.
HTH,
OS
2013/8/14 Pankaj
> Thanx for your great help. Only one issue - I was able to merge the
>
Got it. Much appreciated. I think I grasped it.
Clark
On Sunday, September 1, 2013 8:30:31 PM UTC-5, Sam Mathai Chacko wrote:
>
> I'm sure you've figured out the 'with' part. The formular1c1 just passes
> the formula mentioned there to all blank cells. The trick is in using it as
> an r1c1 form
Hi Thameem,
Suppose you have the total for everyone of the 40 sheets on cell B100. The
following formula would sum every total of the 40 sheets you have.
I guess this is what you want.
=SUM(Plan2!B100;Plan3!B100;Plan4!B100)
Best regards.
OS
2013/8/12 ashish koul
> can u share the sample fil
Try this
Sub check()
Dim Birth As Range, PANo As Range, UserInput, Arr
Set Birth = [G2]
Set PANo = [j2]
If IsEmpty(Birth) Then
Birth.Interior.Color = 255
Birth.Interior.Pattern = xlSolid
If MsgBox("Birth Date is empty, Do you want to enter data now
?", vb
Hello All,
I have duty schedule for various Staffs on various Stores. All Sheets are
of same pattern.
I am enclosing a Sheet with my Problem only for one Store as a Sample.
I have many sheets in the workbook (50+).
Each Staff name appears in a Row. Sometimes two Staff Names are in a Row
(See
