Hello Friends,
I need your help to make macro. I need a macro which work like format
painter for different format not only one format.
*
---
Kαяαη*
--
--
Some important links for excel users:
1. Follow us on TWITTER
Hi Masters,
Needed the VBA code which work similar to VLOOKUP function where I can call
data from master worksheet to fill my report
Attached file will explain you my requirement
Master worksheet contains - GL Code master where each GL code has details and
grouping
While putting GL code in Rep
Hi Rahim,
Look attached file .
*Best Regards,*
*Venkat*
On Thu, Jul 14, 2011 at 10:35 PM, Rahim Sharieff
wrote:
> Hi Experts,
>
> Please refer the attached workbook.
>
> The first sheet here "Schedule" gives the training requirements and
> Training batches, and the second sheet "Trainin
Thank u So much
*Best Regards,*
*Venkat*
*
*
On Fri, Jul 15, 2011 at 6:12 AM, STDEV(i) wrote:
> visit ..
> http://phoenix.phys.clemson.edu/tutorials/excel/regression.html
> http://mallit.fr.umn.edu/fr4218/assigns/excel_reg.html
> http://www.chem.orst.edu/courses/ch361-464/ch464/RegrssnFnl.p
Hi Experts,
Please refer the attached workbook.
The first sheet here "Schedule" gives the training requirements and Training
batches, and the second sheet "Training Planner" needs to be updated based
on this.
I need a formula to be entered in "D4" that will give me the results as show
in the "Tr
Thanks anish.
-Original Message-
From: Anish Shrivastava
Sent: 14/07/2011, 10:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Want to copy two rows in all sheets except few
Hi Ajay,
Attached please find the updated sheet with rows copied in each sheet.
Below is t
Hi,
Why is sumproduct returning a value greater thant a pivot table on the
same data range ? Is it about the number of rows (over 30,000)?
I'd like to be more specific but maybe I can post the file in this
group, if someone can tell me how.
Regards,
Thanks
--
--
visit ..
http://phoenix.phys.clemson.edu/tutorials/excel/regression.html
http://mallit.fr.umn.edu/fr4218/assigns/excel_reg.html
http://www.chem.orst.edu/courses/ch361-464/ch464/RegrssnFnl.pdf
http://faculty.fuqua.duke.edu/~pecklund/ExcelReview/Use%20Excel%202007%20Regression.pdf
http://cameron.econ
-- Forwarded message --
From: syed aliya raza hashim
Date: Mon, Jul 11, 2011 at 6:06 AM
Subject: Fwd: $$Excel-Macros$$ need help
To: "koul.ashish"
-- Forwarded message --
From: syed aliya raza hashim
Date: Mon, Jul 11, 2011 at 6:03 AM
Subject: Re: $$Excel-Mac
Hi
Paste below code in thisworkbook module
Private Sub Workbook_Open()
If MsgBox("Do u want to Disable macro?", vbYesNo, "Information") = vbYes
Then
ActiveWorkbook.Close savechanges:=True
End If
End Sub
Thanks
Mahesh
On Thu, Jul 14, 2011 at 10:07 PM, karthikeyan <
karthikeyansankar...@gmail.
Hi all,
How to call *Macro confirmation Dialog box* open my macro excel book
in excel-2007/10.
If i click *Disable macro* macro excel book should goes to close.How
to do that.Pls help.
Thanks
--
--
Some important li
Hello,
Have a look at the attached file.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de vishwa
Envoyé : jeudi 14 juillet 2011 03:09
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Providing multiple optio
could you please let us knwo in which range or cell u want to paste this
rows in note31
On Thu, Jul 14, 2011 at 7:25 PM, MITTAL AJAY wrote:
> Dear All,
>
> ** **
>
> I want to copy & paste special rows 5& 6 of sheet “Heading” to all the
> sheets starting from “Balance Sheet” to “Note 31”***
HI
What you want do with ActiveX Control array. Will you please explain
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rash
Sent: Thursday, July 14, 2011 12:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Array of CheckBox
Hi all,
Can you please help me in workbook..
Regards,
Subhash yadav
On Tue, Jun 28, 2011 at 2:02 PM, Vasant wrote:
> Sorry...correction.
>
> use this.
>
> Public Function CalculateType(Rng As Range)
> If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value
> = 1050 Or Rng.Value = 1300 O
Hello,
Try :
Sub test()
Dim Wb As Workbook, Sh As Worksheet
For Each Wb In Workbooks
For Each Sh In Wb.Sheets
Sh.Cells.Replace "asdfghjkl", "lkjhgfdsa"
Next Sh
Next Wb
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroup
Hi
I have an issue with suming up numbers..
when I sum up, it shows as -1.776E-13 ... not as Zero.
I know I can fix it by simply changing the format cell to number.
But the issue is that excel doesn't think it is Zero.
in the sample worksheet, Range C54 contains a following formular
Hello Samuel,
Please have a look on the attached file. This might be helpful.
I tried it only on one column since I dont know in how many columns you will
have the data. If you could attach a sample sheet for your data, I can make
it more feasible.
Let me know if it works, otherwise will try a d
G'day everyone
I have no experience in writing macros for Excel, although I do
regularly record and tinker with macros in Word. Please could someone
write the following macro for me :-)
Background: I'm a language translator and I need a macro that would
solve a problem I have with XLSX files. A
Thanx to Hanumant & Anish for giving me responce
I got my mistake with your tips.
thanking you again
regards
sajid memon
--
--
Some important links for excel users:
1. F
Dear All,
Can any one help me on Regression Analysis in Excel with sample data..
*Best Regards,*
*Venkat*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
htt
Hi Rajan,
Good, It is working fine.
A small request, Sell in and sell thru value must be in 2 decimal place with
"1000'separator(,) in base and other two sheets.
Kindly help to amend the same.
regards.
Prabhu.
--
--
22 matches
Mail list logo
