Guys, Cant figure out what these files do. Please explain with
example, how exactly do you use these two excel files.
Regards,
Rohan.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
*From:* B.N.Chethan Kumar chetankumar1...@gmail.com
*Sent:* Tuesday, November 29, 2011 5:03 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Need Help
Hi,
Thanks these help.
But need some additional input. these work only PST or OST file...can u
help with any
Guillett
SalesAid Software
dguille...@gmail.com
*From:* B.N.Chethan Kumar chetankumar1...@gmail.com
*Sent:* Tuesday, November 29, 2011 4:04 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need Help
Hi All,
I got these Macro template from one guys of these group some
: B.N.Chethan Kumar
Sent: Tuesday, November 29, 2011 5:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help
Hi,
Thanks these help.
But need some additional input. these work only PST or OST file...can u help
with any file pattern..like .DOC, XLS,.XL.PPT ,etc
Thank you!
On Tue, Nov 22, 2011 at 10:30 AM, Jedi Spencee jedi.spen...@gmail.comwrote:
Hello- I am trying to write a formula that would return the COUNT and
SUM, with 3 criteria elements.
IF(AND(data!F:F = A),and(data!B:B, = 04 - Closed Won), and(data!
D:D, = Oct-11),count, 0)
Can this
Hello- I am trying to write a formula that would return the COUNT and
SUM, with 3 criteria elements.
IF(AND(data!F:F = A),and(data!B:B, = 04 - Closed Won), and(data!
D:D, = Oct-11),count, 0)
Can this be done?
Thank you.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use
Hi,
If you are using Excel 2007 or 2010, then you can use the SUMIFS or
COUNTIFS to achieve the same.
Cheers
Andy
On Tue, Nov 22, 2011 at 11:00 PM, Jedi Spencee jedi.spen...@gmail.comwrote:
Hello- I am trying to write a formula that would return the COUNT and
SUM, with 3 criteria elements.
You can also try...
=SUMPRODUCT((data!F:F = A)*(data!B:B=04 - Closed
Won)*(data!D:D=Oct-11)*(data!K:K=0))
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On
, otherwise false.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jedi Spencee
Sent: Tuesday, November 22, 2011 9:30 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need Help with IF(AND formula
Hello- I am trying to write
-Original Message-
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Tuesday, November 22, 2011 7:38 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Need Help with IF(AND formula
If you are using Excel 2007+, use COUNTIFS for count and SUMIFS for sum.
If using an older Excel
[mailto:excel-macros@googlegroups.com]
On Behalf Of kavita ahuja
Sent: Monday, November 14, 2011 10:17 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help on Access VBA automating outlook
Hi Group members,
I have one access tool which is automating outlook. Earlier
Dear Friends,
Request you to help me on a Query of Open Office Excel.
The Query is as fallows.
1. Can we protect the sheet as we do protect worksheet in XL.
2. Request you to help me in creating a macro to consolidate 40
files(Open Office Excel) in a XL sheet(2007).
3. All Heading
Object Library, for the 2010 version?
** **
Aas
** **
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
*Sent:* Tuesday, November 15, 2011 5:15 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros
-Macros$$ Need help on Access VBA automating outlook
Hi Kavita,
See attachement.
On Tue, Nov 15, 2011 at 11:46 AM, kavita ahuja kavitaahuja2...@gmail.com
wrote:
Hi Group members,
I have one access tool which is automating outlook. Earlier it was working
fine on all the systems in our
hi kavita,
you should add outlook reference in your excel workbook, which contains
this code
open visual basic editor (press Alt+f11)
go on tool menu
click on reference... option
Microsoft Outlook 12.0 object library
Divaker
9582060233
On Tue, Nov 15, 2011 at 11:46 AM, kavita ahuja
HI Team,
I had created one sheet in which i made the Groups Now i want to link
the Buttons which i created in the sheet (When i click the Button it should
expand the group and wen again click the button it needs to be close).
Please help me on this
*
*
*Regards,*
*Jocky*
--
FORUM RULES
Use this code in Sheet1 VBA code module
Private Sub CommandButton1_Click()
ActiveSheet.Range(B4:B32).EntireRow.Hidden = Not
ActiveSheet.Range(B4:B32).EntireRow.Hidden
End Sub
Private Sub CommandButton2_Click()
ActiveSheet.Range(B35:B50).EntireRow.Hidden = Not
Hey Thanks Sam It's working..
*
*
*Regards,*
*Jocky*
On Mon, Nov 14, 2011 at 8:30 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Use this code in Sheet1 VBA code module
Private Sub CommandButton1_Click()
ActiveSheet.Range(B4:B32).EntireRow.Hidden = Not
All - I need some help with screen tips... Basically I have a jpg image in
excel and all I want to do is to display some numbers at specific places with
my mouse movement... And I do not want a macro for this Is there any way to
get it done?
Thanks in advance..
Krishnan
Sent on my
Hi Sean
you can use it will all xls or all xlsx
On Fri, Oct 21, 2011 at 9:20 AM, Sean flanagan.se...@gmail.com wrote:
Hi sir, and thank you for your assistance.
I like your macro very much. Sadly, it does not bring joy. However,
it has helped me to discover that the problem is not with
May be best to post your code and even your file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Sean
Sent: Thursday, October 20, 2011 3:38 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need help resolving runtime errors and crashes
file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- From: Sean
Sent: Thursday, October 20, 2011 3:38 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need help resolving runtime errors and crashes
(or different approach)
Hi and thanks for your
hi Sean
try this macro. select the folder which is having all the excel files.
On Fri, Oct 21, 2011 at 2:08 AM, Sean flanagan.se...@gmail.com wrote:
Hi and thanks for your interest in my post.
I'm using in MSExcel 2007 and using code I've found in various forums
and published by MVPs, to
As a follow-up, running the macro against files which have been
converted (using OpenOfficeCalc) to .xls files produces a spreadsheet
that is very useful, proving that my difficulty is not in the macro.
And oh, how I wish I could use it against all the .xlsx files!
Warm regards,
-Sean-
On Oct
Good evening experts,
Please assist me in this concern i am looking for a excel macro which can
give details of folders and their respective size.
for example i have Main folder with name Excel with in the folder i have
many other sub folders, so i am looking for a macro which can list the
-Macros$$ Need help
Good evening experts,
Please assist me in this concern i am looking for a excel macro which can give
details of folders and their respective size.
for example i have Main folder with name Excel with in the folder i have many
other sub folders, so i am looking for a macro which
-
From: Rajasekhar Praharaju rajasekhar.prahar...@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, October 14, 2011 11:18:13 AM
Subject: Re: $$Excel-Macros$$ Need help
Hi Paul,
Thanks for your quick reply, Only the first sub folder names and their
respective sizes.
Thanks,
Raj
On Fri
:18:13 AM
*Subject:* Re: $$Excel-Macros$$ Need help
Hi Paul,
Thanks for your quick reply, Only the first sub folder names and their
respective sizes.
Thanks,
Raj
On Fri, Oct 14, 2011 at 8:45 PM, Paul Schreiner schreiner_p...@att.netwrote:
are you wanting all sub-folders within
Subject: Re: $$Excel-Macros$$ Need help
hi Paul,
i am getting bug here,
ub List_Folder_Size()
Dim fso, fldr, sfldr, FolderName
Dim Sht, R
FolderName = D:\C-backup
Sht = FolderList
Set fso = CreateObject(Scripting.FileSystemObject)
Sheets(Sht).Range(A2:Z65000
:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Fri, October 14, 2011 11:31:34 AM
*Subject:* Re: $$Excel-Macros$$ Need help
hi Paul,
i am getting bug here,
ub List_Folder_Size()
Dim fso, fldr, sfldr, FolderName
Dim Sht, R
See if it helps :
https://sheet.zoho.com/excelviewer
On Tue, Oct 4, 2011 at 9:33 AM, syed aliya raza hashim
hashim...@gmail.comwrote:
Can excel file such as reports be access from web or can be acccess as web
pages suppose we have 10 sheets but from some url we want to see the reports
--
Not clear as to what you want. Pls provide sample sheet and urls and what you
need.
From: syed aliya raza hashim
Sent: Monday, October 03, 2011 11:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help
Can excel file such as reports be access from web or can be acccess
Can excel file such as reports be access from web or can be acccess as web
pages suppose we have 10 sheets but from some url we want to see the reports
--
syed aliya
--
--
Some important links for excel users:
1.
It looks like you are forecasting daily ship $ correctly. Is the
problem in summing up the total for the month or in showing cumulative
totals in your month-to-date (column L)? If the latter is the case,
you can simply use an if function to grab from column M when column
E has a null value.
Try
=FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down
HTH,
Sam Mathai Chacko (GL)
On Sun, Sep 25, 2011 at 11:12 PM, Steve Weaver steveweave...@comcast.netwrote:
Each day I update the attached spreadsheet with with our previous days
shipments. I would like to use the daily ship data to
Thank you Sam for your suggestion but I still can't get the formula to
work. In case it makes a difference, I'm using Excel 2002 with SP3
installed.
What am I missing?
Steve
On 9/25/2011 2:48 PM, Sam Mathai Chacko wrote:
Try
=FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down
HTH,
Sam
Simply deleting the un-needed rows and columns reduced the file by one half.
Combining like sheets with an extra column and using autofilter would help. Etc.
From: syed aliya raza hashim
Sent: Sunday, September 25, 2011 1:32 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need
Thanks noorain, It solved my prb...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Hi Haseeb,
Thanks for you help on this query but recently I noticed onething, this
formula works when we have to match strings from left. In this case it works
fine. But when I have the below scenario, it doesnt work properly.
For example, in source sheet I have Analex Corporation and in
Hi all,
I have an excel file in attachment with user form.
When I click on Trip1 in / out --- Its respective data gets fitted in cell
C6 and D6.
Similarly when I click on Trip2 in / out --- Its respective data should get
stored in E6 and F6.
Constraint: Trip 1 to Trip 6 are
-
From: Rsh rashmiv.ni...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wed, September 21, 2011 3:43:40 AM
Subject: $$Excel-Macros$$ Need help to locate data on same row each time i
click
OK
Hi all,
I have an excel file in attachment with user
:* $$Excel-Macros$$ Need help on String Matching
** **
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data populated
column A.
I want to find the best possible match in Column B on 2nd Sheet
, 2011 3:43 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need help on String Matching
** **
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data populated
column
Hi All,
Currently I am working as a MIS-Lead but I want to build my carrier in SAS
and I have done MCA so could you tell me the best institute for SAS in
DELHI region,so that after doing i can get the good JOB
--
syed aliya
--
try this
select any rep name in col a and run the macro
Sub filter()
Application.ScreenUpdating = False
If ActiveCell.Column = 1 Then
Z = Sheets(Input Data).Range(a1).End(xlDown).Row
On Error Resume Next
Sheets(Input Data).AutoFilterMode = False
Sheets(Input Data).Range($A$1:$I Z).AutoFilter
Did you get what I sent?
From: Steve Weaver
Sent: Saturday, September 10, 2011 1:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help with advance filter
Thank you very much Ashish!!!
How would you modify the code below to place the appropriate data from
@googlegroups.com
Subject: $$Excel-Macros$$ Need help with advance filter
Hi,
Every month I download a single commission file which contains between 3
- 4 representatives. Currently I copy and paste the data for each rep
into a unique work sheet so that the appropriate reports can be produced.
I tried
Hi Team,
I had create Compound Calculator in Excel VB sheet , i had already set
the Formula in VB but when i Click on the Calculate Button it shows error,
hence i request you to help me on this.
Regards
--
--
Your Worksheet Doesnt have any Code to Calculate on Click.
On Sun, Aug 28, 2011 at 12:20 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I had create Compound Calculator in Excel VB sheet , i had already set
the Formula in VB but when i Click on the Calculate Button it shows error,
Hi,
Can you create same for me?
The Formula is given below.
*FORMULA - A = P* (1 + r/12)12
*P* is the principal (the initial amount you borrow or deposit) - *TextBox1*
*r* is the annual rate of interest (percentage) - *TextBox2*
*n* is the number of years the amount is deposited or
Hey Jocky,
please find the attachment.
On Sun, Aug 28, 2011 at 7:08 PM, jocky Beta jocky6...@gmail.com wrote:
Hi,
Can you create same for me?
The Formula is given below.
*FORMULA - A = P* (1 + r/12)12
*P* is the principal (the initial amount you borrow or
add this macro to each box
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
' method 1 in this u have to change the shape names as per the sheet names
'For i = 2 To Sheets.Count
'Sheets(i).Visible = True
'If Sheets(i).Name Application.Caller Then
'
Aug 2011 11:35:59
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help in maro
add this macro to each box
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
' method 1 in this u have to change the shape
Hi Prasad,
Ashish's Code working fine..See the attached Sheet.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Suryaprasad
Sent: Tuesday, August 23, 2011 10:56 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help in maro
Hi All
Hi All,
I was trying to write a macro which is not working well, attached is the
sheet where is require a small code the below is the what i require:
I have a main sheet which is assgined with controls and i have 5 TABS , what
i want is when i click on the first control named with Sheet1 in the
Hi Erick,
Please see attached sheet...
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Aug 12, 2011 at 12:34 AM, Erick C boricua2...@gmail.com wrote:
Hi everybody -
I am hoping someone can help me out. I
Hi Erick,
Look attached..see if helps...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Fri, Aug 12, 2011 at 12:34 AM, Erick C boricua2...@gmail.com wrote:
Hi everybody -
I am hoping someone can help me out. I have a spreadsheet that I am
currently making a macro in VBA. I would like to
12:35 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need Help With an Imput Box in VBA
Hi everybody -
I am hoping someone can help me out. I have a spreadsheet that I am
currently making a macro in VBA. I would like to have an imput box or
text box that will pop up and ask the user
booking can not be Done, vbCritical
Exit Sub
End If
End If
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alisha malhotra
Sent: Thursday, August 04, 2011 9:59 PM
To: undisclosed-recipients:
Subject: $$Excel-Macros$$ Need help in Meeting room
Team,
Can you please help me on my query.
I want you to work on attached file itself.
Waiting for your response
Regards,
-- Forwarded message --
From: hemant shah hemanthin...@gmail.com
Date: Wed, Aug 3, 2011 at 9:26 PM
Subject: $$Excel-Macros$$ Need help on Email from Excel
Dear Team,
I need a help on emailing from excel itself.
I have explained all the steps in the attached excel.
Regards,
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
try this
http://akoul.wordpress.com/category/email-through-excel-using-outlook/
On Wed, Aug 3, 2011 at 9:26 PM, hemant shah hemanthin...@gmail.com wrote:
Dear Team,
I need a help on emailing from excel itself.
I have explained all the steps in the attached excel.
Regards,
--
*To:* excel-macros@googlegroups.com
*Subject:* RE: $$Excel-Macros$$ Need help on MIS
** **
Dear All,
** **
Please help me on this at the earliest…
** **
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Amit Desai
*Sent
Hi All,
Need help for SUMIF Function i am doing time sheet conslidation i am
not able sum up all days for one resource in other TAB
Example:
Resource7/1/20117/2/20117/3/2011
7/4/20117/5/20117/6/20117/7/20117/8/2011
can you attach the sample sheet
On Tue, Jul 26, 2011 at 4:39 PM, Venkatesh Narla nvenki...@gmail.comwrote:
Hi All,
Need help for SUMIF Function i am doing time sheet conslidation i am
not able sum up all days for one resource in other TAB
Example:
Resource7/1/2011
*Sent:* Friday, July 22, 2011 9:37 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ need help
** **
cjeck the attachment have applied conditional formatting
** **
** **
** **
On Fri, Jul 22, 2011 at 8:47 PM, Akshay akshaya.mal...@gmail.com wrote
Hey Haseeb,
This formula is AWESOME man... Tooo goood.. helped me big time..
A big THANK YOU :)
Thanks,
Anish
On Tue, Jul 12, 2011 at 8:25 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello, Try this Array Formula. Must hit CONTROL+SHIFT+ENTER, rather than
ENTER.
-- Forwarded message --
From: syed aliya raza hashim hashim...@gmail.com
Date: Mon, Jul 11, 2011 at 6:06 AM
Subject: Fwd: $$Excel-Macros$$ need help
To: koul.ashish koul.ash...@gmail.com
-- Forwarded message --
From: syed aliya raza hashim hashim...@gmail.com
Shrivastava
*Sent:* Monday, July 11, 2011 3:43 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need help on String Matching
** **
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data
is the Column of Client Name.??*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *syed aliya raza hashim
*Sent:* Saturday, July 09, 2011 1:10 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ need help
** **
Hi,
Hi
Hi,Thanks for taking initiative ,
See there are two Clients:-
1 Genentech
2 Lifetech
Both have three tabs Open,closed,Rejection that means total 6 tabs but i
want only three tabs named Open,close,Rejection,in Open tab i want to put
all GenentechLifetech Open data same in closed tab i want to put
try this
VLOOKUP(A1*,Sheet1!$A:$A,1,0)
On Mon, Jul 11, 2011 at 3:42 PM, Anish Shrivastava anish@gmail.comwrote:
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data populated
column A.
I want to find the best possible
Hi Ashish,
This one looks great but it will only help if few of the characters at the
end of the text is missing.
For Example - Guitar Center, . (row # 1650) in the 2nd sheet is not able
to find the value because it's Guitar Center, Inc. in sheet one.
*I wanted something like which matches the
Which is the Column of Client Name.??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of syed aliya raza hashim
Sent: Saturday, July 09, 2011 1:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need help
Hi,
Hi ,
I have the two client
-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from by loop
Daneil, that is what i want but the same code is not working.in my
sheet.
what is Me.contol ?
On Fri, Jul 8, 2011 at 10:22 PM, Daniel dcolarde...@free.fr wrote:
Give
: samedi 9 juillet 2011 00:32
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from by loop
Daneil, that is what i want but the same code is not working.in my
sheet.
what is Me.contol ?
On Fri, Jul 8, 2011 at 10:22 PM
@googlegroups.com]
*De la part de* shariq khan
*Envoyé :* samedi 9 juillet 2011 13:01
*À :* excel-macros@googlegroups.com; dcolarde...@free.fr
*Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in
user from by loop
** **
Please find the attached workbook. on login page use Mudit
I’m trying to assign the value in excel user from thought loop.
Name of the textboxes are TB1,TB2,TB3…….. TB22 .
Below is the code which I’m using ,but its not working.
For num = 1 To 22
txtbox_val = TB num .value
txtbox_val = num
End If
Next num
@googlegroups.com
Objet : $$Excel-Macros$$ Need Help Help Help.Putting value in user from
by loop
I’m trying to assign the value in excel user from thought loop.
Name of the textboxes are TB1,TB2,TB3…….. TB22 .
Below is the code which I’m using ,but its not working.
For num = 1
I’m trying to assign the value in excel user form thought loop.
Name of the textboxes are TB1,TB2,TB3…….. TB22 .
Below is the code which I’m using ,but its not working.
For num = 1 To 22
txtbox_val = TB num .value
txtbox_val = num
End If
Next num
The same
= OLECont.Object.Value
End If
Next OLECont
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of shariq khan
Sent: Friday, July 08, 2011 2:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help Help Help.Putting value in user from
:* $$Excel-Macros$$ Need Help Help Help.Putting value in user
from by loop
** **
I’m trying to assign the value in excel user from thought loop.
Name of the textboxes are TB1,TB2,TB3…….. TB22 .
Below is the code which I’m using ,but its not working
Which line gets the error ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : vendredi 8 juillet 2011 13:11
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from
@googlegroups.com] De
la part de shariq khan
Envoyé : vendredi 8 juillet 2011 13:11
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from by loop
Hi Daneil,
Thanks but it didnt worked..
Run-time error '-2147024809
Could
@googlegroups.com]
*De la part de* shariq khan
*Envoyé :* vendredi 8 juillet 2011 13:11
*À :* excel-macros@googlegroups.com
*Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in
user from by loop
** **
Hi Daneil,
Thanks but it didnt worked
-macros@googlegroups.com]
*De la part de* shariq khan
*Envoyé :* vendredi 8 juillet 2011 18:17
*À :* excel-macros@googlegroups.com
*Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in
user from by loop
** **
Daneil,
This one txtbox_val = Me.Controls(TB num
Sub bubblesort()
Dim i As Integer, j As Integer, n As Integer, temp As Single
n = Selection.Rows.Count
For j = n To 3 Step -1
For i = 1 To j - 1
If Selection.Cells(i, 1) Selection.Cells(i + 1, 1) Then
temp = Selection.Cells(i, 1)
Selection.Cells(i,
Thanks for helping.
On Sun, May 8, 2011 at 6:31 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
Sub ExpandTable()
' by siti Vi / jakarta, 8 may 2011
Dim SrcRng As Range, ResRng As Range, pDate As Date
Dim i As Long, r As Long, u As Integer
Set SrcRng = Cells(1).CurrentRegion
hi
find attached File
On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com
anvesh.gw...@gmail.com wrote:
Hi,
I need help in VBA code.
I have excel sheet on which data is write as below mention
Input
A BC D
1 X1 1.511/11/2008
hi STDV(i)
Your macro only working with 3 Rows.. if he want to add more data in that
table it will not expend all table..
On Sun, May 8, 2011 at 1:40 PM, rajan verma rajanverma1...@gmail.comwrote:
hi
find attached File
On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com
dear Mr. Verma,
et us try both macros with the NEW source table (as New Input) like this
please find attached:
** a workbook containing this data
** a workbook containing both macros
X1 1.7 11/11/2008 01/11/2010
X2 2.4 11/12/2009 01/11/2010
X3 3.8
Hi,
I need help in VBA code.
I have excel sheet on which data is write as below mention
Input
A BC D
1 X1 1.511/11/2008 01/11/2010
2 X2 2.511/12/2009 01/11/2010
3 X3 3.511/01/2010 01/11/2010
I want
When copying excel files, the following problems:
PROBLEM 1
1). The settings of the Margins are getting disturbed
PROBLEM 2
Also when you take a print out, the @age of the page fluctuates
Do you or your friends have any solution
Please revert
Thanks regards
On 5/6/11, mayur
try this
(VLOOKUP(MAX(G:G),G:K,5,0)+VLOOKUP(MAX(G:G)-1,G:K,5,0)+VLOOKUP(MAX(G:G)-2,G:K,5,0))/3
On Fri, May 6, 2011 at 5:20 PM, mayur zinknax.zin...@gmail.com wrote:
Hi All,
I need help on get pivot formula for getting average of last three days
score.
Please find attached sheet, is more
Thank you all... Have a great Weekend :)
On Fri, May 6, 2011 at 8:54 AM, rajan verma rajanverma1...@gmail.comwrote:
Find the attached File..
On Fri, May 6, 2011 at 5:20 PM, mayur zinknax.zin...@gmail.com wrote:
Hi All,
I need help on get pivot formula for getting average of last three
Dear,
pls let me know how i can create excel macros in MS ACESS 2003.
thanks in advance...
regards,
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Create a Object of Excel in Access...the work with that Object.
On Mon, May 2, 2011 at 5:44 PM, rohit gupta gupta1.ro...@gmail.com wrote:
Dear,
pls let me know how i can create excel macros in MS ACESS 2003.
thanks in advance...
regards,
--
Hi Experts,
Due size constance i am sending in two zip folders please check second mail
for excel files dump.
(This is Second mail please check this one as well -- thanks
for cooperation)
This report is sent on daily basis please help in this concern if it is
automated
it could be very much
Hi,
In my sheet there are three tab 1)UPS tab 2)Router tab 3)SMPS tab
so there are date column as well is there
my question :when we open the excel file it should prompt me the message the
date is going to expire on which tab
for example :suppose in UPS tab for product no 10021003 date is 26 Apr
I have an excel file with a list of column data. first of all, after the
data is sorted based on the Col D, then I need a routine to check if any row
data in Col D occurs more than once. If it occurs more than once..
For example: Column D has data on Row 2 and Row 3 same but the Date on
Column I
601 - 700 of 908 matches
Mail list logo