Hi,
Find out the last row of third workbook/sheet,
Workbooks(book3).Activate
Worksheets(sheet3).activate
Finalrow = cells(rows.count,1).end(xlup).row
Range(Afinalrow+1).select
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com
try below code
i = WorksheetFunction.CountA(Range(a:a)) + 1
Range(a i).Select
.
Enjoy
Team XLS
On Fri, Aug 30, 2013 at 10:09 AM, DanJ dante_jul...@yahoo.com wrote:
Dear Experts,
I have a range, * A37:A115,* in my first (1st) workbook where I copy
and paste
Dear Team,
Please find the attached Excel File. I have two queries;
1. I have certain denomination in range A3:A10. If I wish to know the
number of times a denomination has appeared which formula should i use?
2. Adjacent to those denominations there are certain amount of pieces of
that
Hi,
Thank you for your quick reply.
I'm sorry if my question wasn't clear.
What I wanted to find is the next empty row in the first workbook in the range
A37:A115 , i.e., after I copied and pasted thereon the data from
the second workbook.
Again, Thank you.
DanJ
Dear Kushlesh,
You can u with countifs(criteriarange,criteria) and enter
Pl find the attached sheet
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Aug 30, 2013 at 12:04 PM, Kush Shama kushleshsha...@gmail.com wrote:
Hi,
Sorry about that but your question is still not clear to me. Could u plz
send me Screen shot in excel or any excel files if you have.
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dante Julian
Sent: Friday,
Dear Anil,
Thanks for your prompt response. However, I also need solution for second
query i.e If I wish to calculate number of pieces for each of them, how
could i do that using a formula.
On Fri, Aug 30, 2013 at 12:22 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Kushlesh,
You
Hi,
Ok, please see the below code, if still it's not fine then let me know
Sub findlastrow()
Dim rng As Range
Set rng = Range(A37:A115 )
For Each c In rng
If c.Value = Then
storeval = c.Row
MsgBox storeval
Exit Sub
End If
Next
End Sub
Warm
Yes, that's perfect
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dante Julian
Sent: Friday, August 30, 2013 1:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Copy data to next empty row
Have you try something like bellow ?
Sub NextEmpty()
Range(A37).End(xlDown).Offset(1).Select
End Sub
Rgds,
[dp]
Pada 30/08/2013 14:35, Ravi Kumar menulis:
Yes, that’s perfect
//
*/Warm Regards,/*
*/Ravi Kumar./*
*From:*excel-macros@googlegroups.com
These are the actual times. I wasn't sure either if I converted them to
military time if that would help anything.
--
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 @
I have got some data (eg Name, Father Name, Date of Birth, ..) in an excel
sheet. I have to feed that into a website. where there are text boxes, drop
down boxes. Is there a macro or vba code to do this
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
you can add code on worksheet change event
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count = 1 Then
If Target.Column = 3 And Target.Value Then
Target.Offset(0, 2).Value = Target.Value + Target.Offset(0,
1).Value
Target.Offset(0,
can you share the sample file
On Fri, Aug 30, 2013 at 6:08 PM, Diannaha Thompson
littlesqueak2...@gmail.com wrote:
These are the actual times. I wasn't sure either if I converted them to
military time if that would help anything.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Hello, I am new to macros, and to recording them. I created a webquery with
a parameter that it edits a part of the query based on a cell I select. I
now have to run this web query 800+ times. So I recorded myself doing it
with the Use relative references checked. But it always puts the
can you share the website link .
also you can visit below links for ie automation
http://www.excely.com/excel-vba/ie-automation.shtml#.UiDEstKw2zw
http://www.jpsoftwaretech.com/excel-vba/automate-internet-explorer/
http://www.vbaexpress.com/kb/getarticle.php?kb_id=386
Regards
Ashish
On
can u share the sample file and how you would like to see the output
On Thu, Aug 29, 2013 at 2:38 PM, Dhamo dharan dhamulo...@gmail.com wrote:
Dear Friends
Kindly help to export data like name and percentage from all the sheet (30
sheets) to a new file or in a different sheet.
E.g
Name
can u share sample file
On Tue, Aug 27, 2013 at 3:48 PM, Pranav Yadav pranavyada...@gmail.comwrote:
Hi n thanks i want a vba code like if in a row 3 value is abc and on the
cells on (2,1) is correct or incorrect so take the value according to that
row with correct or incorrect example
you can open the attachment in temp folder using vba and copy the range .
how will you identify from which email you need to copy the content , etc
On Wed, Aug 28, 2013 at 6:18 PM, noodnutt noodn...@gmail.com wrote:
Hi all
Someone asked me an interesting question ( Subject Header ).
I know
even if you do this someone can easily break the vba password and change
the code or remove restrictions
On Thu, Aug 29, 2013 at 10:26 AM, pankajinfo pankaji...@gmail.com wrote:
I want to create a excel file with Date limit.
Like in a file there are some contents(Graphs, Dashboards Etc)
check the attachment see if it helps
On Thu, Aug 29, 2013 at 11:45 PM, Diannaha Thompson
littlesqueak2...@gmail.com wrote:
Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for
example. I need to count how many times occur in a range. So 7:00-7:59
occurs twice 8am-8:59
Hi Ahmad
Iam Mahmoud,Ihave a converter gregorian to hijri shamsi.if you need this
tell me.
On Wed, Aug 14, 2013 at 2:15 AM, hansel jose hanselj...@gmail.com wrote:
Pls try with this file . It will convert Hijri date to Gregorian date
format.
Hansel
On Tuesday, September 25, 2012
Try this attached sample, and let us know if it solve your problem
On 30-08-2013 1:15, Diannaha Thompson wrote:
Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for
example. I need to count how many times occur in a range. So 7:00-7:59
occurs twice 8am-8:59 occurs once. I
sorry, On Red Bold i mean ActiveCell.Offset(1,1)
On 31-08-2013 0:56, De Premor wrote:
Try to using Offset
Ex: Before you run your code, active / selected cell was on C3, then
try to run this code
Sub Tes()
ActiveCell.Offset(1,0).Select'Move 1 Cell Down
Stop'See Your Current
I will give it a try. Thanks.
On Friday, August 30, 2013 11:00:09 AM UTC-5, ashish wrote:
check the attachment see if it helps
On Thu, Aug 29, 2013 at 11:45 PM, Diannaha Thompson
littlesq...@gmail.comjavascript:
wrote:
Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc.
I will give it a try thanks.
On Friday, August 30, 2013 1:03:33 PM UTC-5, De Premor wrote:
Try this attached sample, and let us know if it solve your problem
On 30-08-2013 1:15, Diannaha Thompson wrote:
Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for
example. I
I attached a sample of what I am trying to do.
On Thursday, August 29, 2013 1:15:19 PM UTC-5, Diannaha Thompson wrote:
Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for
example. I need to count how many times occur in a range. So 7:00-7:59
occurs twice 8am-8:59
Truthfully I could not get your code to work, but it did open my eyes to a
different way of working through my problem. I was originally hoping for a
macro that would function within an already open document and using
activecell parameters so that the macro could be used on files where the
Try to using Offset
Ex: Before you run your code, active / selected cell was on C3, then try
to run this code
Sub Tes()
ActiveCell.Offset(1,0).Select'Move 1 Cell Down
Stop'See Your Current Selected Cell Now, then back here and
press F8
ActiveCell.Offset(0,1).Select
I would like a formula/macro to highlight the cheapest price, excluding
zero, in a non-contiguous range. The table below is a sample of my
spreadsheet. Note that I want to omit the Lead Time from the condition.
check the attachment see if it helps
On Sat, Aug 31, 2013 at 3:24 AM, Bryan Nim bryan...@gmail.com wrote:
I would like a formula/macro to highlight the cheapest price, excluding
zero, in a non-contiguous range. The table below is a sample of my
spreadsheet. Note that I want to omit the Lead
try attached file see if it helps
On Sat, Aug 31, 2013 at 12:44 AM, Diannaha Thompson
littlesqueak2...@gmail.com wrote:
I attached a sample of what I am trying to do.
On Thursday, August 29, 2013 1:15:19 PM UTC-5, Diannaha Thompson wrote:
Ok so I have this list of times 7am, 8am, 7:30,
pls share
.
Enjoy
Team XLS
On Fri, Aug 30, 2013 at 9:25 PM, mahmoud aqajari
mahmoudaqaj...@gmail.comwrote:
Hi Ahmad
Iam Mahmoud,Ihave a converter gregorian to hijri shamsi.if you need this
tell me.
On Wed, Aug 14, 2013 at 2:15 AM, hansel jose
pls provide the website and some dummy data with excel file.
From: ExcelSteve excel...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, August 30, 2013 7:18 PM
Subject: $$Excel-Macros$$ Data from an excel sheet to a online web from
I have got some
34 matches
Mail list logo