Hi,
Please share details in Delhi
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Mon, Feb 8, 2016 at 12:33 PM, Prabhakar Thakur <
prabhakarthak...@gmail.com> wrote:
> Hi Group Member
>
> I need excel macro training please share best training institute details
> or share link
>
>
> Thanks,
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 ujjwal1...@gmail.com wrote:
Thanks Vaibhav !!!
Your file is working perfectly matching with my requirement.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
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,
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 ujjwal1...@gmail.com wrote:
Hello ,
I am in need of a macro which will help me to get a consolidated report of
daily data saved
Thanks Mahesh Vaibhav,
Its working fine :)
Thanks,
Waheed
On Tue, Sep 9, 2014 at 11:27 AM, Mahesh Patil zmpa...@gmail.com wrote:
Hi,
PFA
On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi friends,
I need your help to create a macro, its motive is to find out
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 waheedb...@gmail.com wrote:
Hi friends,
I need your help to create a macro, its motive is to find out the variable
cost of
Hi,
PFA
On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed waheedb...@gmail.com 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
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,
try below link
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Thu, Aug 15, 2013 at 1:13 PM, jmothilal gjmothi...@gmail.com wrote:
Dear All
Request to send basic macro commands like for loop, assigning value ,
detecting row and column value .. etc
thanks
On Sat, Aug 17, 2013 at 10:22 AM, xlstime xlst...@gmail.com wrote:
try below link
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Thu, Aug 15, 2013 at 1:13 PM, jmothilal gjmothi...@gmail.com wrote:
Dear All
Request to send basic
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
Any update experts?
On Mon, Dec 10, 2012 at 2:02 PM, Puttu * puttu...@gmail.com 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
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
please help on this request..
On Mon, Dec 10, 2012 at 6:46 PM, Puttu * puttu...@gmail.com wrote:
Any update experts?
On Mon, Dec 10, 2012 at 2:02 PM, Puttu * puttu...@gmail.com wrote:
Thanks for your response David,
Sorry If I wasn't clear. Below is the answer for your questions.
SOME ONE HELP ME PLS
On Sun, Dec 9, 2012 at 4:42 PM, Puttu * puttu...@gmail.com 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
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 * puttu...@gmail.com wrote:
SOME ONE HELP ME PLS
On Sun, Dec 9, 2012 at 4:42 PM, Puttu * puttu...@gmail.com wrote:
Yogananda
any help
Moderator could you please help on this
On Mon, Dec 10, 2012 at 11:24 AM, Puttu * puttu...@gmail.com 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
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
Experts please help me
Need multiple data to pasted in one single workbook
On Sat, Dec 8, 2012 at 7:38 PM, Puttu * puttu...@gmail.com 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
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
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
see attached file
On Wed, Jul 4, 2012 at 11:53 AM, vijay yadav
vijay.ganesh.ya...@gmail.comwrote:
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
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
Try
Sub FooterSAS()
selectcase InputBox(Enter 1=Confidental, 2=For Internal Use Only 3=Other)
Case Is = 1: x = Confidental
Case Is = 2: x = For Internal Use Only
Case Is = 3: x = Restricted
Case Else
End Select
For Each wk In Application.Workbooks
For Each sh In wk.Worksheets
OOPS
Put a space between select and case
selectcase
select case
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: jonnie...@gmail.com
Sent: Monday, June 18, 2012 4:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need
Thanks a lot NOORAIN
I got it...
On Thu, Apr 19, 2012 at 2:47 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Vijay,
Please try below code to change folder path in red color...
See attached sheet..
Sub Spilit_in_Workbook()
Dim rng As Range
Dim i, j, c As Long
Dim wb As
Why create a workbook for each user when all you have to do is filter
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Vijay Mane
Sent: Wednesday, April 18, 2012 12:03 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help--macro
Hi Experts,
Hi Don,
Thanks for reply
see I have team with 30 members and I have to allocate exceptions or cases
to each team member on daily basis. Once they complete the work then they
send same file to me with updated status,reason.
I have macro which collate the all files. But what i want is-- I
Hope this file serve your needs
Regards
Kumar
On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
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
exactly...
thank you so much..
Regards
Amresh
On Mon, Mar 26, 2012 at 5:35 AM, BNS kumar chimir...@gmail.com wrote:
Hope this file serve your needs
Regards
Kumar
On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya
amreshkushw...@gmail.comwrote:
Hi Friends,
We have 77 campaign and 77
*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
Thanks again for your assistance Don, your help is very much appreciated.
John
On Mon, Feb 6, 2012 at 10:03 AM, dguillett1 dguille...@gmail.com wrote:
Place in a module and save the file as macro enabled. xls or .xlsM
‘==
Option Explicit
Sub lineemupSAS()
Dim i As Long
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
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
@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Need A Macro To Move Rows
Thanks again for your assistance Don, your help is very much
appreciated.
John
On Mon, Feb 6, 2012 at 10:03 AM, dguillett1 dguille...@gmail.com wrote:
Place in a module and save the file as macro enabled. xls or .xlsM
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
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 sheets of master
Sorry, but i could not find any way
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).EntireRow.Delete
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 dguille...@gmail.com wrote:
Best to ATTACH your file. Code could be simplified. ie:
last = Cells(Rows.Count,
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 vijvaru...@gmail.com wrote:
Sorry, but i could not find any way of attaching excel in my mails
here. Could some one please let me know how
http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html
On Fri, Jul 15, 2011 at 12:29 PM, karan 1237 karan1...@gmail.com 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
It's working...Thank you so much...
*
Kαяαη*
On Fri, Jul 15, 2011 at 12:33 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html
On Fri, Jul 15, 2011 at 12:29 PM, karan 1237 karan1...@gmail.com wrote:
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 koul.ash...@gmail.com
Friends,
Any update on this?
Thanks,
AJ
On Tue, Jul 5, 2011 at 11:49 AM, Abhishek Jain abhishek@gmail.comwrote:
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
I will give this a shot. Thank you so much.
Sent from my iPhone
On Mar 10, 2011, at 9:20 PM, Dave Bonallack davebonall...@hotmail.com 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
This worked perfectly! Thank you!
Sent from my iPhone
On Mar 10, 2011, at 10:12 PM, Karla Haman karlaha...@hotmail.com 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 davebonall...@hotmail.com wrote:
Hi,
One approach
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
48 matches
Mail list logo