Good Morning,
Hope you are having a great day!
*Objective: I want to convert all the excel files (.xls,.xlsx etc) in a
folder to .csv files (with original file names) & place the csv file in
another target folder.*
I am not an excel expert, however I managed to write the below piece of
cod
please paste this code in worksheet module
On Fri, Jun 6, 2014 at 7:36 PM, Eugene Bernard
wrote:
> Dear Ashish,
>
> Thanks for the code !!
>
> I just copied and tested, it is not giving expected result.
> What i am doing wrong. Please guide.
>
> Regards
> Eugene
>
>
> On Fri, Jun 6, 2014 at 10
Dear Ashish,
Thanks for the code !!
I just copied and tested, it is not giving expected result.
What i am doing wrong. Please guide.
Regards
Eugene
On Fri, Jun 6, 2014 at 10:13 AM, ashish koul wrote:
> Try this
> Private Sub Worksheet_Change(ByVal Target As Range)
> Dim arr, i As Long
> arr
Try this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim arr, i As Long
arr = Range("a2:d" & Range("a65356").End(xlUp).Row - 1)
'On Error GoTo err:
Application.EnableEvents = False
If Target.Count > 1 Then Application.Undo
If Target.Column = 2 Then
For i = LBound(arr) To UBound
Hi all,
Please find attahced sheet.
I have a requirement like this.
In this scenario, I have parts with unique ID which passes thro' 3 stages
like S1,S2,S3.
whenever user updates a new row, based on ID and Stage as well as qty, the
status should get updated automatically.
in this example, aft
Hello Rafael,
check the below sub and call the sub @ 'Need help here to do something with
the data collected from Sql Server
'
*
Private Sub WriteDate(rs As Recordset)
On Error GoTo ErrorMessage
Thank you so much for your quick help
On Monday, May 27, 2013 9:28:25 AM UTC-5, bé trần văn wrote:
> Cell D3:D9 and :D24 to enter data.
> Input data in is complete, Click Button "Enter data into the sheet
> Format",
>
> See Attachment.
>
> 2013/5/27 David Grugeon >
>
>> Bulloo Shire Counc
Thanks David for your quick help..
On Monday, May 27, 2013 5:40:01 AM UTC-5, David Grugeon wrote:
>
> Bulloo Shire Council in Thargomindah Queensland Australia.
>
> Regards
> David Grugeon
>
>
>
> On 27 May 2013 16:13, VBA VABZ > wrote:
>
>> hey
>>
>> for which co you work.
>>
>> thx
>>
>>
>>
is it resolved?
On Mon, May 27, 2013 at 7:58 PM, Bé Trần Văn wrote:
> Cell D3:D9 and :D24 to enter data.
> Input data in is complete, Click Button "Enter data into the sheet
> Format",
>
> See Attachment.
>
> 2013/5/27 David Grugeon
>
>> Bulloo Shire Council in Thargomindah Queensland Australia
Cell D3:D9 and :D24 to enter data.
Input data in is complete, Click Button "Enter data into the sheet Format",
See Attachment.
2013/5/27 David Grugeon
> Bulloo Shire Council in Thargomindah Queensland Australia.
>
> Regards
> David Grugeon
>
>
>
> On 27 May 2013 16:13, VBA VABZ wrote:
>
>> he
Bulloo Shire Council in Thargomindah Queensland Australia.
Regards
David Grugeon
On 27 May 2013 16:13, VBA VABZ wrote:
> hey
>
> for which co you work.
>
> thx
>
>
> On Mon, May 27, 2013 at 7:20 AM, Bv Dileep wrote:
>
>> Hello,
>>
>> ** **
>>
>> Please find attached the sheet.
>>
>>
hey
for which co you work.
thx
On Mon, May 27, 2013 at 7:20 AM, Bv Dileep wrote:
> Hello,
>
> ** **
>
> Please find attached the sheet.
>
> ** **
>
> Macro Requirement : I will receive the data for 20 associates in my team
> in a separate sheets (20 Sheets) in the attached format. Now
Which bit of this are you not able to do yourself? Have you tried
recording the steps, examining and understanding the code produced, and
then stringing it together to make a complete routine to do what you want?
I operate on the "teach a man to fish" principle. If you want me to
produce the ent
Hello,
** **
Please find attached the sheet.
** **
Macro Requirement : I will receive the data for 20 associates in my team in
a separate sheets (20 Sheets) in the attached format. Now I want a macro
which should consolidate the data in the shown format (Format Tab).
** **
For
why using macro?... just select hole column and change format
Regards,
Team XLS
On Mon, Mar 4, 2013 at 11:21 AM, Prashant Pawle wrote:
> Dear Team,
>
> Please amend macro in attached sheet to automatically select range based
> on cell value.
>
> Thx in advance
>
> Regards,
>
> Prashant
>
> -
Dear Team,
Please amend macro in attached sheet to automatically select range based on
cell value.
Thx in advance
Regards,
Prashant
--
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.face
Will you please elaborate ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 17 October 2012 11:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro Help: Repeat
all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Sundarvelan N
To: excel-macros@googlegroups.com
Sent: Wed, October 17, 2012 8:13:09 AM
Subject: Re: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move
Please find
ll the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* Sundarvelan N
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, October 17, 2012 2:10:40 AM
&g
all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Sundarvelan N
To: excel-macros@googlegroups.co
Dear Gurus,
Please help me in repeating the macro for each cursor move.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor th
Hi ashish,
Is there any way to keep common code for all sheet?
Because i may have to use this code on various sheet on many time.
On Sat, Apr 16, 2011 at 11:35 AM, ashish koul wrote:
> change
>
> Sheets(1)
>
> as per your requirement
>
> activesheet or Sheets(" name of sheet")
>
>
>
> On Fri
change
Sheets(1)
as per your requirement
activesheet or Sheets(" name of sheet")
On Fri, Apr 15, 2011 at 11:57 PM, Prabhu wrote:
> Hi Ashish,
>
> Thanks, But when i run the macro i had an issue
>
> 1) It is woking only on the Sheet 1 only not other sheet
>
> 2) I want to use this code with
Hi Ashish,
Thanks, But when i run the macro i had an issue
1) It is woking only on the Sheet 1 only not other sheet
2) I want to use this code with other macro as a Continuation Plz help from
which line i have to copy to my exising macro code.
Regards,
Prabhu
--
---
Hi
Try
Sub Test()
Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 1 Step -1
If IsError(Cells(i, "A")) Then
Cells(i, "A").EntireRow.Delete
End If
Next i
End Sub
On Fri, Apr 15, 2011 at 3:24 PM, Prabhu wrote:
> Hi,
>
> I want to delete particular rows only in my work sheet which cont
I processed 3,000 records (and removed 1,000)
in about 30 seconds
Paul S
From: Prabhu
To: excel-macros@googlegroups.com
Sent: Fri, April 15, 2011 6:29:18 AM
Subject: $$Excel-Macros$$ Macro Help in Excel 2007?
Macro Help in Excel 2007?
I want to delete parti
try this code
assuming you have data in col a to col c and you want to delete all records
with #n/a in col C
Sub TEST()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
If Sheets(1).FilterMode Then
Sheets(1).ShowAllData
End If
Sheets(1).Range("A1:C" & R
Macro Help in Excel 2007?
I want to delete particular rows only in my work sheet which contains #N/A
in a particular column?
Assuming the column containing the #N/A errors is column A, and i need to
delete the entire row where '#N/A' if found in column A.
Plz help with macro code which should
Hi,
I want to delete particular rows only in my work sheet which contains #N/A
in a particular column?
Assuming the column containing the #N/A errors is column A, and i need to
delete the entire row where '#N/A' if found in column A.
Plz help with macro code *which should delete enter #N/A at
Thanks Ashish
Hugs & Love
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Thursday, February 24, 2011 5:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro Help - Please!
hi
+ sign was earlier
Thanks a ton Rohan!
Long Live, Excel-Macro group.
Cheers
Kamal
On Wed, Feb 23, 2011 at 5:15 AM, Rohan Young wrote:
> HI Kamal,
>
> Please see the attachment if it helps,
>
>
> Regards
>
> ROHAN
>
>
> On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Kamal,
>>
>> Please see a
Hello,
Some people have this habit ; it’s useless.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jenie
Envoyé : mercredi 23 février 2011 20:38
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Macro Help - Please!
Hello excel
el-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rohan Young
> *Sent:* Wednesday, February 23, 2011 8:15 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Macro Help - Please!
>
>
>
> HI Kamal,
>
>
>
> Please
"Complete",""))
Thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rohan Young
Sent: Wednesday, February 23, 2011 8:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro Help - Please!
HI Kamal,
I think, it could be with IF Formula
For Example
'(=IF(D7="step","complete",IF(D7="vp","pass",""))'
if value in D7 Cell.
On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote:
> Hello Excel Gurus,
>
> Need small favour from experts,
> I have two columns in Excel, I need a macro, where if Column A
HI Kamal,
Please see the attachment if it helps,
Regards
ROHAN
On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI wrote:
> Dear Kamal,
>
> Please see attached sheet..if it help..
>
> On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote:
>
>> Hello Excel Gurus,
>>
>> Need small favour from experts
Dear Kamal,
Please see attached sheet..if it help..
On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote:
> Hello Excel Gurus,
>
> Need small favour from experts,
> I have two columns in Excel, I need a macro, where if Column A contains
> value as "Step", column B should populate "Complete".
> If
HI Kamal,
Here is the sample workbook.
Regards,
Mrinal Saha
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN grou
Hello Excel Gurus,
Need small favour from experts,
I have two columns in Excel, I need a macro, where if Column A contains
value as "Step", column B should populate "Complete".
If column A contains VP, Column B should populate "Pass".
Step
Complete
VP
Pass
Step
Complete
VP
Pass
VP
Pa
Dear All,
Please find attached a file. It contains four sheets. Sheet branches
contains details for branches, sheet data contains data for the branches and
sheet report contains the rough format in which I need the report to be in.
My quest is that when ever a new branch is opened, for example, b
Thanks
Its difficult to understand for me
Thanks Once again - my purpose is solved
Dharmesh Shah
On Fri, Oct 15, 2010 at 11:44 AM, Vishal Angre wrote:
> *code is Thisworkbook in VBAproject *
>
>
> On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah
> wrote:
>
>> Thanks Vishal
>>
>> Its working
>>
*code is Thisworkbook in VBAproject *
On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah wrote:
> Thanks Vishal
>
> Its working
>
> Can u explain how u done this (If its posible)
>
> Once Again Thanks
>
> Dharmesh Shah
>
>
>
>
>
> On Wed, Oct 13, 2010 at 5:21 PM, Vishal Angre wrote:
>
>> NOW OPEN FI
Thanks Vishal
Its working
Can u explain how u done this (If its posible)
Once Again Thanks
Dharmesh Shah
On Wed, Oct 13, 2010 at 5:21 PM, Vishal Angre wrote:
> NOW OPEN FILE AND U WILL SEE ADDIN MANU AND DHARMESH SUB MANU
>
>
> On Tue, Oct 12, 2010 at 12:39 PM, Dharmesh Shah
> wrote:
>
>
Dear Group
I have created one macro, I want to use this macro as add ins, how can I use
this pls help
regards
Dharmesh Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and li
Hi
The best and the easiest way.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 12:12 am, Umesh Dev wrote:
> Hi Sundervelan,
>
> I have enclosed a file which will automatically update the moment you make a
> change in the Master sheet.
>
> Regards
> Umesh
>
>
>
> On Wed, Aug 18, 2010 at 12:06
Hi everybody -
I am hoping someone can help me out with a problem that I am having.
I am trying to edit a macro, but I do not have a lot of experience
writing macros and I cannot figure out the issue.
I have a spreadsheet with a macro that does some formatting and
refreshes a pivot table in a diff
Dear Maulik,
There are some materials uploaded in "Files" section of this group itself.
http://groups.google.com/group/excel-macros/files
You can also search google for other learning materials.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gma
Hi,
I would like to learn macro
specially i would like to learn that how to write macro code in excel
if anyone can provide me related to Macro it will be very helpful for
me
Kindly proive any kind of stuff like notes how to write macros, links
or PDF file anything which can help other also who l
Hi All,
Q1) - Some cells/columns/sheets doesn't allow the paste values(copy
from one sheet)
e.g : if i copied from one sheet to another sheet , excel show popups
enter manually,don't copied form other sheet.
Q2) - If I put the value in one cell then click enter , cell value
automatically change
Hi All,
I have create a macro and sent to others these people open that
particular file excel says popups
'ENABLE / DISABLE macros' they clicked DISABLE macros so macros are
not working.
How can i avoid this Proplem? Anybody knows let me know.
thanks
karthik
--~--~-~--~~
Hi,
I have enter E-mail id in one cell with space:e.g(karthi keyan
sankar...@gmail.com).
Excel automatically validate when i click enter button popup message :
don't use space enter E-mail id. How to write coding.pls let me know.
Thanks
--~--~-~--~~~---~--~~
--
I'm making excel macros for the first time and getting things figured
out, but I have a few questions:
What code do I use to delete columns that have all empty cells EXCEPT
the top cell (row 1) that contains any of a number of headings? I need
to insert this into an existing macro.
What code do
Dear All,
I have an invoice template, which reads different data from other
worksheets in the workbook through a for loop. Each iteration of the
loop is a different customer and hence a new invoice. Currently, I am
searching for a way to print these invoices (a few hundred) in a
single print job,
Hi,
Please help me on doing below macro
I want an Excel spreadsheet put together where employees can log their hours
worked ie - Started at 9am and finished at 7:30pm. It is to be a fortnightly
timesheet. I want the spreadsheet to populate the penalty rate hours
(normal/1.25/1.5/2) with the f
Hi,
Is there a way to create a Macro that will allow an image to
automatically popluar in cell A1? This would also need to work when a
new worksheet is created.
Any thoughts and/or samples would greatly be appreciated.
--~--~-~--~~~---~--~~
Hi guys
i m trying to make a macro but i m not able to get it
can any1 help me in making a macro. I need a macro whcih gives me the
foll :
1)the cel in whcih i press the macro short cut - it should add 8 - 10
lines above that cell and then,
2)on that 8 - 10 lines it should have the foll :
MP
Okay guys, I can't get this one. I've been trying for hours to make
this work and I am missing something small.
Here's the deal: This is part of a larger set of macros I am writing.
This snippet shows that I am looking for the next available row and
then copying from a worksheet called RAW and th
57 matches
Mail list logo
