Great.. Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Oct 17, 2014 at 1:42 AM, Ujjwal Desai wrote:
> Thanks Vaibhav !!!
>
>
> Your file is working perfectly matching with my requirement.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d
Thanks Vaibhav !!!
Your file is working perfectly matching with my requirement.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, ac
hey
somehow not able to take time in preparing macro for you, emantime you can
use this code to consol your files & do manually PVT.
Run macro & select folder to import data directly...
Hope this helps // Cheers
+
*I did not do this for you. God is here working through me for you.*
On Tue,
can you share sample for conso file too..
+
*I did not do this for you. God is here working through me for you.*
On Mon, Oct 13, 2014 at 1:27 AM, Ujjwal Desai wrote:
> Hello ,
>
> I am in need of a macro which will help me to get a consolidated report of
> daily data saved in the folder.
>
Thanks Mahesh & Vaibhav,
Its working fine :)
Thanks,
Waheed
On Tue, Sep 9, 2014 at 11:27 AM, Mahesh Patil wrote:
> Hi,
> PFA
>
>
> On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed wrote:
>
>> Hi friends,
>>
>> I need your help to create a macro, its motive is to find out the
>> variable cost of ph
Hi,
PFA
On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed wrote:
> Hi friends,
>
> I need your help to create a macro, its motive is to find out the variable
> cost of physicians >4000.
>
> Attached is the sample data for your reference.
>
> Thanks in advance.
>
> Waheed
>
> --
> Are you =EXP(E:RT)
Hi
Click blue button to run macro..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed wrote:
> Hi friends,
>
> I need your help to create a macro, its motive is to find out the variable
> cost of physicians >4000.
PFA, first select paths.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kartik Dale
Sent: Tuesday, December 17, 2013 1:54 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need a macro to open & copy data from a given path
Hello Experts,
Thanks a lot Ashish, this is what exactly what i am looking.
I small addition required, Once the Formula is placed and formula resulted
converted to % format, the value should highlight in red font if the value
is more than > 10% only for that result row.
Is this possible?
On Tue, Dec 11, 2012
please help on this request..
On Mon, Dec 10, 2012 at 6:46 PM, Puttu * wrote:
> Any update experts?
>
>
> On Mon, Dec 10, 2012 at 2:02 PM, Puttu * wrote:
>
>> Thanks for your response David,
>>
>> Sorry If I wasn't clear. Below is the answer for your questions. Attached
>> is the reports an
Yogananda thanks for your prompt response.
My requiements is below
1. I have more than 5-10 work book in the folder
2. Macro should open one workbook and copy the data and past it new
workbook called as master and close the source workbook
3. Again it should open 2nd workbook and copy and past th
Any update experts?
On Mon, Dec 10, 2012 at 2:02 PM, Puttu * wrote:
> Thanks for your response David,
>
> Sorry If I wasn't clear. Below is the answer for your questions. Attached
> is the reports and master excel how i am expecting.
> Let me know if you need any other details
> On Mon, Dec 10,
Insufficient information provided.
You have posted 4 apparently identical workbooks although Report1.xls is
slightly larger than the others so there must be some difference. What is
it?
Could you provide a workbook called, say, Result.xls with at least 2 or the
source reports included. This wil
any help
Moderator could you please help on this
On Mon, Dec 10, 2012 at 11:24 AM, Puttu * wrote:
> can any one please...
>
> Need a macro to 5 workbook data to paste in single workbook, on one by one
> in the same sheet
>
>
> On Mon, Dec 10, 2012 at 12:05 AM, Puttu * wrote:
>
can any one please...
Need a macro to 5 workbook data to paste in single workbook, on one by one
in the same sheet
On Mon, Dec 10, 2012 at 12:05 AM, Puttu * wrote:
> SOME ONE HELP ME PLS
>
>
> On Sun, Dec 9, 2012 at 4:42 PM, Puttu * wrote:
>
>> Yogananda thanks for your prompt response
SOME ONE HELP ME PLS
On Sun, Dec 9, 2012 at 4:42 PM, Puttu * wrote:
> Yogananda thanks for your prompt response.
>
> My requiements is below
>
> 1. I have more than 5-10 work book in the folder
> 2. Macro should open one workbook and copy the data and past it new
> workbook called as master
Experts please help me
Need multiple data to pasted in one single workbook
On Sat, Dec 8, 2012 at 7:38 PM, Puttu * wrote:
> Hi Experts
>
> I need a macro where i can use multiple workbooks to in single new workbook
>
> 1. I have multiple workbook in perticular folder, all that workbook used
> r
Dear NRao,
Please try it...
Change path as per your requirement and Select Tools-Reference-Microsoft
Scripting Runtime before run the macro
Sub Consodilate_workbook()
Dim wb As Workbook
Dim rng As Range
Dim fil As File
Dim i As Integer
Set wb = ThisWorkbook
Dim fld As Folder
Dim
see attached file
On Wed, Jul 4, 2012 at 11:53 AM, vijay yadav
wrote:
> Hi,
>
> how to conditional format for a changed alpahnumerical cell value? is it
> possible?
>
> if i have a filled worksheet where
>
> tb3 is value in cell A1 and
>
> *tb4 is value in cell A2*
> and
>
> I change cell *A1
Hi,
how to conditional format for a changed alpahnumerical cell value? is it
possible?
if i have a filled worksheet where
tb3 is value in cell A1 and
*tb4 is value in cell A2*
and
I change cell *A1 value to tb4*
the "macro" would
*change only cell A1 background*.
It *shouldn'*t
Dear Vijay,
For this you may use conditional formatting. There is no need to make macro.
Thanks & Regards,
Gawli Anil
On Wed, Jul 4, 2012 at 11:00 AM, vijay yadav <> wrote:
> Hi Members / Experts
>
> I need a macro to change the background color of a cell as soon as i
> change the value (alph
*For, Compaign:
=INDEX($A$4:$A$80,CEILING(COUNTA($E$3:E3)/COUNTA($A$4:$A$80),1))
For, Location: =INDEX($B$4:$B$80,COUNTIF($E$4:E4,E4))*
Oops. Deleted too many rows on test sheet
>>
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* Amresh Maurya
exactly...
thank you so much..
Regards
Amresh
On Mon, Mar 26, 2012 at 5:35 AM, BNS kumar wrote:
> Hope this file serve your needs
>
> Regards
> Kumar
>
>
> On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya
> wrote:
>
>> Hi Friends,
>>
>> We have 77 campaign and 77 city lists , now what i need
Hope this file serve your needs
Regards
Kumar
On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya wrote:
> Hi Friends,
>
> We have 77 campaign and 77 city lists , now what i need , each campaign
> has 77 cities.
>
> We have attached file for reference. kindly check
>
> Regards
> Amresh
>
>
> --
> FO
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* John A. Smith
>> *Sent:* Monday, February 06, 2012 9:11 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Need A Macro To Move Rows
>>
>> Than
Nice
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Monday, February 06, 2012 2:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows
If your rows go in to the thousands, using autofilter will add a bit more
(~40
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: John A. Smith
Sent: Monday, February 06, 2012 9:11 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows
Thanks again for your assistance Don, your help is very much appreciated
Thanks again for your assistance Don, your help is very much appreciated.
John
On Mon, Feb 6, 2012 at 10:03 AM, dguillett1 wrote:
> Place in a module and save the file as macro enabled. xls or .xlsM
> ‘==
> Option Explicit
> Sub lineemupSAS()
> Dim i As Long
> Application.ScreenUpdati
Place in a module and save the file as macro enabled. xls or .xlsM
‘==
Option Explicit
Sub lineemupSAS()
Dim i As Long
Application.ScreenUpdating = False
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
Rows(i).Delete
Next i
Columns
Dear Atul,
Please use below code to update Chart Automatic..
*
Private Sub Workbook_Open()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.Calculate
Next
Set wks = Nothing
End Sub*
also visit on below web link..
http://spreadsheetpage.com/index.php/tip/upda
Please explain your need
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Atul vishwakarma
Sent: Thursday, December 15, 2011 8:29 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need a macro to update charts automatically
Hi Friends,
I need a macro to update charts automati
s todays date in col A
End If
Next ws
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Varun
Sent: Sunday, October 23, 2011 10:58 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Need a macro to update data from raw file to
individual s
Click on reply to this post via your gmail account. And then upload the file
as you would normally in any mail.
Sam
On Mon, Oct 24, 2011 at 9:28 AM, Varun wrote:
> Sorry, but i could not find any way of attaching excel in my mails
> here. Could some one please let me know how I should go abot t
Sorry, but i could not find any way of attaching excel in my mails
here. Could some one please let me know how I should go abot that.
Many thanks.
Varun
On Oct 23, 6:24 pm, "dguillett1" wrote:
> Best to ATTACH your file. Code could be simplified. ie:
> last = Cells(Rows.Count, "B").End(xlUp).Row
Best to ATTACH your file. Code could be simplified. ie:
last = Cells(Rows.Count, "B").End(xlUp).Row
For i = last To 1 Step -1
If (Cells(i, "B").Value) = "ABC" Then
Cells(i, "A").EntireRow.Delete
End If
If (Cells(i, "B").Value) = "XYZ" Then
Cells(i, "A").Enti
It's working...Thank you so much...
*
Kαяαη*
On Fri, Jul 15, 2011 at 12:33 PM, NOORAIN ANSARI
wrote:
>
> http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html
>
>
> On Fri, Jul 15, 2011 at 12:29 PM, karan 1237 wrote:
>
>> Hello Friends,
>>
>> I need your help
http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html
On Fri, Jul 15, 2011 at 12:29 PM, karan 1237 wrote:
> 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α
Thanks a lot Ashish but this doesn't do what i need. I want the available
quantity and amount against negative and zero values. In other words I want
to set off those negatives and nulls with the positives.
Thanks & regards,
AJ
On Wed, Jul 6, 2011 at 12:39 PM, ashish koul wrote:
> Option Comp
Option Compare Text
Sub test()
Dim i, j, w As Long
w = Sheets(1).Range("a65356").End(xlUp).Row
For i = 2 To w
If Range("e" & i).Value = 0 And Range("f" & i).Value < 0 Then
Range("h" & i).Value = Range("d" & i).Value
Range("d" & i).Value = ""
Range("i" & i).Value = Range("e" & i).Value
Range("e
Friends,
Any update on this?
Thanks,
AJ
On Tue, Jul 5, 2011 at 11:49 AM, Abhishek Jain wrote:
> Dear friends,
>
> Attached along a data wherein in some rows, quantity and amount for items
> nos are both positive which is my inventory.
>
> In other rows one of the either or both are negative or
You're welcome.
Regards - Dave.
CC: excel-macros@googlegroups.com
From: karlaha...@hotmail.com
Subject: Re: $$Excel-Macros$$ Need a Macro
Date: Fri, 11 Mar 2011 19:19:00 -0800
To: excel-macros@googlegroups.com
This worked perfectly! Thank you!
Sent from my iPhone
On Mar 10, 2011, at
This worked perfectly! Thank you!
Sent from my iPhone
On Mar 10, 2011, at 10:12 PM, Karla Haman wrote:
> I will give this a shot. Thank you so much.
>
> Sent from my iPhone
>
> On Mar 10, 2011, at 9:20 PM, Dave Bonallack wrote:
>
>> Hi,
>> One approach is to insert a new blank sheet, call i
I will give this a shot. Thank you so much.
Sent from my iPhone
On Mar 10, 2011, at 9:20 PM, Dave Bonallack wrote:
> Hi,
> One approach is to insert a new blank sheet, call it "END" and move it to
> become the last sheet in the workbook.
> Whenever adding new sheets, make sure they sit before
Hi,
One approach is to insert a new blank sheet, call it "END" and move it to
become the last sheet in the workbook.
Whenever adding new sheets, make sure they sit before the "END" sheet.
If your SUM formula was, for example:
=SUM(Sheet2:Sheet8!A1)
change it to:
=SUM(Sheet2:END!A1)
All sheets bet
44 matches
Mail list logo
