Hi Expert
I need a VBA Macro that will:
1) Open a word document one by one that is there in a given folder
2) Left align all the paragraphs that is there in each document (except -
graph & tables) in one go
3) close the word with changes as per 2) applied
4) open another word doc and repeat
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,
Hi Group Member
I need excel macro training please share best training institute details or
share link
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
--
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
Hi Experts
i need a vba macro code for the excel sheet got corrupt after a specific
period.
Regards
Rohit Badola
--
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 @
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 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) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
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
Hello Experts,
I need a macro to open a particular folder from excel and should copy the
file name sheet name A1 value from each sheet. PFA
Thanks
Kartik
--
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
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
Dear All
Request to send basic macro commands like for loop, assigning value ,
detecting row and column value .. etc
i know the c programming , foxpro commands.
Thanks with
Mothilal.J
--
*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*
--
Are you
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
I have a macro that runs well to update a workbook every month. There are
25 workbooks, so we need to open every one and run the macro. I would like
to have a macro that would open them one-by-one and nun my macro. My macro
could be embedded or launched by this new macro. I know the various
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 Team,
I have a morethan 10 workbooks in a folder , I need a macro for
consoldate all workbooks into single workbook.
1) some of the sheets have morethan 70,000 recoreds (rows) filled
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
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
Hi Members / Experts
I need a macro to change the background color of a cell as soon as i
change the value (alphanumeric).
The background is originally yellow and as soon I change a value it should
become no fill (or white ).
Sometimes the changed value might be same as previous value ..in
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
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help!!! MACRO
Hi All,
I need help with macros. Attached (Macro for Footer) is the existing file
with macros for labeling an excel sheet, It asks for Yes or no for label the
sheet as Confidential or Internal Use Only.
I need your help
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
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Vijay Mane levb...@gmail.com
*Sent:* Wednesday, April 18, 2012 12:03 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need help--macro
Hi Experts,
pfa refer attachment
Query I want macro which
Hi Experts,
pfa refer attachment
Query I want macro which will create different workbooks according
tounique user column. and all workbooks will have name of user and
their data respectively in same format
Please help me.
--
FORUM RULES (986+ members already BANNED for violation)
1)
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
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
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
...@gmail.com
*Sent:* Monday, March 26, 2012 7:02 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ need a macro
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
Dear Team,
I want a macro for message names export to excel with received dates.
thanks in advance
Simha
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
:* John A. Smith johnasmit...@gmail.com
*Sent:* Monday, February 06, 2012 8:21 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need A Macro To Move Rows
Thank you for your ongoing Excel help. I need a macro to correct a
download issue. The download places one event on two
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
Hi Everyone,
I need a code for the following steps to be enacted
1. Save a backup file with the name counts - date.xls (this will be a
daily file)
2. remove rows with name (column B) matching with name in to be
removed sheet
3. copy value in name field and open the corusponding sheet in the
Software
dguille...@gmail.com
-Original Message-
From: Varun
Sent: Sunday, October 23, 2011 3:43 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need a macro to update data from raw file to
individual sheets of master
Hi Everyone,
I need a code for the following steps
Message-
From: Varun
Sent: Sunday, October 23, 2011 3:43 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need a macro to update data from raw file to
individual sheets of master
Hi Everyone,
I need a code for the following steps to be enacted
1. Save a backup file with the name
AND VBA MACROS
Subject: $$Excel-Macros$$ Need a macro to update data from raw file to
individual sheets of master
Hi Everyone,
I need a code for the following steps to be enacted
1. Save a backup file with the name counts - date.xls (this will be a
daily file)
2. remove rows
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
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
2011 16:16:37 -0800
Subject: $$Excel-Macros$$ Need a Macro
From: karlaha...@hotmail.com
To: excel-macros@googlegroups.com
I have a tab that totals all of the other tabs in the spreadsheet. I
need to be able to add new tabs and have the formulas in the totals
tab automatically update
(and including) Sheet2 and END will be included, no
matter how many there are.
Hope this helps
Regards - Dave.
Date: Thu, 10 Mar 2011 16:16:37 -0800
Subject: $$Excel-Macros$$ Need a Macro
From: karlaha...@hotmail.com
To: excel-macros@googlegroups.com
I have a tab that totals all
I have a tab that totals all of the other tabs in the spreadsheet. I
need to be able to add new tabs and have the formulas in the totals
tab automatically update.
How do I do this?
--
--
Some important links for
between (and including) Sheet2 and END will be included, no
matter how many there are.
Hope this helps
Regards - Dave.
Date: Thu, 10 Mar 2011 16:16:37 -0800
Subject: $$Excel-Macros$$ Need a Macro
From: karlaha...@hotmail.com
To: excel-macros@googlegroups.com
I have a tab that totals all
Hi all
How's everyone doing?
I am novice to macro, I need a help from you guys. I hope it should be
simple.
Present Scenario: I have a macro which remove non-breaking space
from all the cells at once in the worksheet. (If anyone need, I can
share the code).
Usefulness of the Macro: When you
64 matches
Mail list logo