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 @
https://www.facebook.com/di
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.
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 o
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 Exp
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 thi
hi,
Happy new year,
I need a macro that would copy cells based upon values in other cells. I
am using Excel 10.
I have a worksbook that has about 20 worksheets in it. Each of these
worksheets has 2 columns A8:A108 & B8:B108.. I want a macro that would do
the following:
1. Select the act
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
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
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
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
mail.com
>>
>> *From:* Amresh Maurya
>> *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 , eac
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
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 Pleas
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 Problem,
>> 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
t
> SalesAid Software
> dguille...@gmail.com
>
> *From:* John A. Smith
> *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 macr
ete
Next i
Columns.AutoFit
Application.ScreenUpdating = True
End Sub
‘=
Don Guillett
SalesAid Software
dguille...@gmail.com
From: John A. Smith
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 yo
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
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
> > Select Case UCase(Cells(i, "B"))
> >Case Is = "ABC", "XYZ", "RES": Rows(i).Delete
> > End Select
> > Next i
> >
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> >
> >
>
Row To 1 Step -1
> Select Case UCase(Cells(i, "B"))
> Case Is = "ABC", "XYZ", "RES": Rows(i).Delete
> End Select
> Next i
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
>
).Row To 1 Step -1
Select Case UCase(Cells(i, "B"))
Case Is = "ABC", "XYZ", "RES": Rows(i).Delete
End Select
Next i
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Varun
Sent: Sunday, October 23, 2011 3:43 AM
To: MS EXCE
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
maste
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α
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
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
it to:
>> =SUM(Sheet2:END!A1)
>> All sheets 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:
.
>
> 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
2:END!A1)
All sheets 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:
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 e
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 co
56 matches
Mail list logo
