You are welcome. . .
Regards,
DILIPandey
On 7/2/11, Atul wrote:
> Thnaks you Pandeyji. ITs working fine
>
> On Jun 29, 2:45 am, Dilip Pandey wrote:
>> Hi Atul,
>>
>> You were clear in the first email itself. It is my mistake that I had
>> overlooked the point.
>> Now I have revised the macro a
hi kurikkal
get files from the link below, i had uploaded there. i tried to
attach files but due to excess size of files, it cant be attached .
http://cmaankur.webs.com/apps/documents/
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not l
Use this Function
Function ConCat(ParamArray arr() As Variant) As String
For i = 0 To UBound(arr())
ConCat = ConCat & " " & Format(arr(i), arr(i).NumberFormat)
Next
End Function
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ICWAI Help
Sent
See if it helps
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Friday, July 01, 2011 5:17 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ need required for data validation value query
sorry , i forget to attach a sa
*
*
Chandra Singh Bohra
Champawat
Uttrakhand
09717336333
chandu...@gmail.com
chandu...@rediffmail.com
chandu.u...@yahoo.co.in
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and l
Hi All,
Thanks for the prompt support.
Regards
Pooja Sharma
Sent from BlackBerry® on Airtel
-Original Message-
From: ashish koul
Sender: excel-macros@googlegroups.com
Date: Fri, 1 Jul 2011 21:24:01
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I want to lea
Hi Ankur,
Nice Sharing...Good stuff thank u so much...
*Best Regards,*
*Venkat*
*
*
On Sat, Jul 2, 2011 at 3:17 PM, ankur wrote:
> hi kurikkal
> get files from the link below, i had uploaded there. i tried to
> attach files but due to excess size of files, it cant be attached .
>
> http://c
Dear Chandra Singh,
I think you are very new to excel , this group will be more profitable for
you,
See if it help,
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Singh Bora
Sent: Saturday, July 02, 2011 4:41 PM
To: excel-macros@googlegroup
Hi All.
As m working in a import house for that i have to sales bills on daily basis
i just want a help that makes me easy to make that
If someone tell that how to make 5 random numbers selection between 197.001
to 203.999 which gives the total of 1000.000
Please help meurgent guys
Cheers
Hi All.
As m working in a import house for that i have to sales bills on daily basis
i just want a help that makes me easy to make that
If someone tell that how to make 5 random numbers selection between 197.001
to 203.999 which gives the total of 1000.000
Please help meurgent guys
Cheers
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anshul Gupta
Sent: Saturday, July 02, 2011 7:39 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required!!
Hi All.
As m working in a import house for
Hi
I know a bit of SQL.. can write a bit of complicated query..
At work, I don't have Write right to SQL server.. because my role is to
investigate and report.
I would create a stored procedure and simply bring records I want using
'From other source' in Data tab.
But that's not possib
Hi
I can think of a way to write this macro.
What I want is to find any possible combination of numbers from given
numbers to a given total. For example,
Let's say
Given numbers: 1, 2, 3, 4, 5
total = 30
Will it be possible to get any combination of Given numbers adding up to
30?
Mac
Sir,
Do u have any idea of auto filling magic squre for a particular sum total.
Iam interested
to know it. Thanks if u could help.
-R.Karunanithi
--- On Sat, 7/2/11, Rajan_Verma wrote:
From: Rajan_Verma
Subject: RE: $$Excel-Macros$$ Urgent Help required!!
To: excel-macros@googleg
HI,
I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY
SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS.
THANKS IN ADVANCE
-R.KARUNANITHI,2/7/2011.
--
--
Some important links for excel users:
1
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with reference to different ranges for the same criteria , and summing
different ranges.
I tried SUMPRODUCT(SUM(IF...
I tried SUM(IF and inserting a + before each proceeding IF
Neither of those worked.
What about u
see if it helps
SUMIF($D$2:$D$81,G3,E2:E81)+SUMIF(Sheet3!D:D,Sheet1!G3,Sheet3!E:E)+SUMIF(Sheet2!D:D,Sheet1!G3,Sheet2!E:E)
On Sat, Jul 2, 2011 at 9:52 PM, Susan wrote:
> Hi Dilip,
> The formula only returned the first sheet, I need it to sum all sheets
> with reference to different ranges for th
try this
http://www.ozgrid.com/forum/showthread.php?t=83016&page=1
On Sat, Jul 2, 2011 at 9:09 PM, Markkim wrote:
> Hi
>
> I know a bit of SQL.. can write a bit of complicated query..
>
> At work, I don't have Write right to SQL server.. because my role is to
> investigate and report.
>
> I
Dear Susan,
You select all sheets(Group it ) and then try this formula.You may get
result in all sheets
*Best Regards,*
*Venkat*
*
*
On Sat, Jul 2, 2011 at 9:52 PM, Susan wrote:
> Hi Dilip,
> The formula only returned the first sheet, I need it to sum all sheets
> with reference to different
Hi Susan,
Here's two ways to solve it
1. With a simple combo of sumif formulas
=SUMIF(D2:D6,"C Wagner",E2:E6)+SUMIF(Sheet3!D11:D18,"C Wagner",Sheet3!
E11:E18)+SUMIF(Sheet2!D13:D23,"C Wagner",Sheet2!E13:E23)
2. With an array formula.
{=SUM((D2:D11="C Wagner")*(E2:E11)+(Sheet3!D11:D20="C Wagner"
I mean copy without the curly braces. They are inserted by Excel when
you use the CSE keys
On Jul 2, 9:22 pm, Susan wrote:
> Hi Dilip,
> The formula only returned the first sheet, I need it to sum all sheets
> with reference to different ranges for the same criteria , and summing
> different rang
Can you post an example? Not sure how a magic square works.
Sam Mathai Chacko
On Jul 2, 9:17 pm, karunanithi ramaswamy wrote:
> HI,
> I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY
> SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS.
> THANKS IN ADVANCE
> -R.KARUNANITH
Unable to open file
Sam Mathai Chacko
On Jul 2, 1:45 pm, ali abbas wrote:
> Dear All,
>
> Attached a word 2007 file that contain a permanant/protected HEADER AND
> FOOTER.
>
> Can anyone know how to protect Header and Fooer in Word and Excel 2007 ?.
>
> Please check this file and GUIDE OT ALL M
No dude its not owrking proerly which buttun you give to generate thats is
also not working and the random numbers are not coming in decimels there
coming in proper figure.
Anyone else who can help me out buddy's
please help me out
cheers!!!
On Sat, Jul 2, 2011 at 8:25 PM, Rajan_Verma wrot
http://support.microsoft.com/kb/888184
On Sat, Jul 2, 2011 at 10:47 PM, Venkatesan c wrote:
> Dear Tigarman,
>
> Find attached protected header&footer...
>
> way to protect Just check the attached image..
>
>
> *Best Regards,*
> *Venkat*
> *
> *
>
>
> On Sat, Jul 2, 2011 at 2:15 PM, ali abbas
Recruiter dilpreet.bha...@zensar.in
Greetings!!
This is with reference to your resume on a job portal which is an excellent
match for an opportunity in VBA development with Zensar Technologies at our
PUNE office.
Please mail me your updated resume alongwith the following details if this
opport
hi
can you explain it in detail
On Fri, Jul 1, 2011 at 11:44 AM, Rash wrote:
> Hi I am using the attached bill of material. I need to search the whole
> sheet to find unique product numbers. Explained in more detail in the
> attached .docx file.
>
> Attached .xls is my excel file in which i nee
Hi Ashish,
First of all congrats! You are a big help to all of us :)
Also, Thanks a lot for your help. you. I tweaked your code a bit and
got it to work the way I needed. now I have another problem:
I am combining files from different location into one sheet (a new
workbook). The list of files t
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook
On Sun, Jul 3, 2011 at 11:33 AM, Nasim wrote:
> Hi Ashish,
>
> First of all congrats! You are a big help to all of us :)
>
> Also, Thanks a lot for your hel
29 matches
Mail list logo