Why not using available [Sort Ascending / Descending] buttons in Auto Filter ?
On 1/26/11, San Pat myitems2...@gmail.com wrote:
Hi All,
I am working on a excel with data in many columns.
I want to add two macro button on each heading to sort data, one for
Ascending sort +and second for
can you explain it in detail also attach the sample worksheet too
On Wed, Jan 26, 2011 at 2:53 AM, Hector Ruiz hector.ru...@gmail.com wrote:
Please help me to make query of cells (data) in Excel. (Macros).
--
try this see if it helps
With OutMail
.to = ActiveSheet.Range(b I).Text
.CC = ActiveSheet.Range(c I).Text
On Wed, Jan 26, 2011 at 1:51 AM, John A. Smith johnasmit...@gmail.comwrote:
I use a file with a macro (which this wonderful group collectively
contributed to)
try this see if it helps
ActiveCell.FormulaR1C1 = =CORREL($B$2:$B$15,R[-14]C:R[-1]C)
On Wed, Jan 26, 2011 at 2:11 AM, Fred jonathanepos...@gmail.com wrote:
I am trying to run a simple script the calculates the correlation
between column B and the column C, then does the same thing for
So.. your script is simply inserting Excel formulas into the cells?
First of all, we need to discuss relative addresses vs Absolute addresses.
If you insert the formula:
In Cell F16, you inserted the formula:
=CORREL(R[-14]C[-4]:R[-1]C[-4],R[-14]C:R[-1]C)
In Excel, that resulted in:
helloo frnds
i want to know what is macro and what is the work of it and how we can
operate this.
thankyou.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hello,
how can I upload the file, as I see in the notification, this is no
longer possible.
However, if you can imagine my situation:
I have data in columns from A to O and in rows from 1 to 100. The data
is in the same rows and columns in all workbooks.
Now I need the data to be copied from
Hello,
I recorded a macro which adds content from certain range of cells to
another range of cells. Each cell serves as a content source for the
target cell comment.
My problem is this. The source content is added periodically and if I
trigger the macro for the second time, when I add source
Thanks for responding:
I have to transport data to ACCESS, because I have consultations there, but
I want to query directly from Excel to automate reports with MACROS.
Hector Ruiz
2011/1/26 ashish koul koul.ash...@gmail.com
can you explain it in detail also attach the sample worksheet too
makes perfect sense. thanks so much!
On Wed, Jan 26, 2011 at 8:06 AM, Paul Schreiner schreiner_p...@att.net wrote:
So.. your script is simply inserting Excel formulas into the cells?
First of all, we need to discuss relative addresses vs Absolute
addresses.
If you insert the formula:
In
try this macro see if it helps
On Wed, Jan 26, 2011 at 4:22 PM, Seba sebastjan.hri...@gmail.com wrote:
Hello,
how can I upload the file, as I see in the notification, this is no
longer possible.
However, if you can imagine my situation:
I have data in columns from A to O and in rows
look here
http://www.contextures.com/xlcomments03.html#Picture
regards
r
2011/1/26 Seba sebastjan.hri...@gmail.com
Hello,
I recorded a macro which adds content from certain range of cells to
another range of cells. Each cell serves as a content source for the
target cell comment.
My
can you attach the sample workbook
On Wed, Jan 26, 2011 at 8:59 PM, roberto mensa robb@gmail.com wrote:
look here
http://www.contextures.com/xlcomments03.html#Picture
regards
r
2011/1/26 Seba sebastjan.hri...@gmail.com
Hello,
I recorded a macro which adds content from certain
I would suggest looking into the documentation for setting up
an external data source.
Excel works nicely with Access.
In one of my applications, I set up the external source,
then, in the macro, have it do a refresh to update the data,
then use the macros to generate summary reports from this
There are a several ways to accomplish this...
Are all of the files in a single folder?
Are there other files there?
Or...how do you want to identify the files?
We can:
A)use a sheet to list all of the files.
then, loop through the list and process each workbook.
B)Place all of the files in one
try
Sub test()
Dim rng As Excel.Range
Dim v As Excel.Range
Set rng = [a1:a10]
For Each v In rng
write_comment v.Offset(, 1), v
Next
End Sub
Sub write_comment(rngc As Excel.Range, rngt As Excel.Range)
If TypeName(rngc.Comment) = Nothing Then
rngc.AddComment.Text
End If
rngc.Comment.Text
Ashish,
Thank you for your quick response. I got it to work thank you. Could you
explain (b I).Text please as it refers to a location? Thank you for
your excellent assistance learning Excel.
John
On Wed, Jan 26, 2011 at 7:40 AM, ashish koul koul.ash...@gmail.com wrote:
try this see if
Hi,
I have a testing scenario where I have Severity (Critical, High, Medium
Low) and I have modules as Insurance, Claims, etc. When I take a pivot, I
want to combine all the module information in the body of the pivot showing
Severity in Row labels and all the other info under summation of Total
Hi Ashish,
Thanks for your help.
Is there any way I can make it cell specific, assign this macro to
particular cell.
For example, separate macro for cell A1, B1, C1, D1 etc.
I want to put two arrows, up down (one for Ascending sort and second for
Descending sort), in each cell.
Regards,
Hi Rohan,
If you are referring to Q18 and down, you have not removed the Data
Validation due to which you still see the drop down.
Remove the validations and see.
Hope this helps.
Pavan
On Fri, Jan 14, 2011 at 12:14 PM, Rohan Young rohan.j...@gmail.com wrote:
Hi,
see the attachement for
Hi,,
Please tell me how to count the number of total records in a worksheet using
the macro or count of non blank cells in a worksheet.
--
*Thanks and Regards,*
Jitendra Kr. Verma| Sr. Software Engineer
Mob: +91.9700695633
--
Thanks Dave nice idea.
Aamir Shahzad
On Wed, Jan 26, 2011 at 6:08 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
IFERROR can be stacked, just like IF can be.
Try this formula in C4, then copy down:
Hi Jitendra,
Not sure how you have arranged the data into your worksheet, but try
below code:-
Sub lastRec()
i = Range(a65536).End(xlUp).Row
MsgBox i-1 'subtract one from i if you have the headers at top
End Sub
To count non blank cells in a worksheet, you can use COUNTA function.
Please get
Hi Sandip,
Please find the attached file. Feel free to ask further for any query.
Regards
Sandeep Kumar
On Wed, Jan 26, 2011 at 10:41 PM, San Pat myitems2...@gmail.com wrote:
Hi Ashish,
Thanks for your help.
Is there any way I can make it cell specific, assign this macro to
particular
use this one if you email adress for to is in cell b1
and email adress for cc is in cell c1
With OutMail
.to = ActiveSheet.Range(b1).Text
.CC = ActiveSheet.Range(c1).Text
and if you want to make it dynamic
Dim I as long
I= 1 '( choose row no)
With OutMail
Thank you both. I hadn't had the chance the above macro. I will report
back how that turns out.
To answer your questions Paul, I already have all workbooks in one
folder and there aren't any other files there.
And any other new workbook I create is also saved in this folder.
Workbooks are named
Hello Roberto,
works like a charm:)
I just have one additional question. How can I define the target range
on a separate sheet.
Example:
Sheet1 = source range
Sheet2 = target range
And to make the matter even harder, the target range is transposed, so
if source = a1:a10, target range = a1:j1
Hi Vikram,
I clearly did not understand your query, however I have rectified the code.
Regards
Umesh Dev
On Wed, Jan 26, 2011 at 9:32 PM, vikram vikramahuj...@gmail.com wrote:
Hi Umesh,
Thanks a lot for your help.
I need one more help regarding below macro for converting PDF files
Sandeep thanks for your help.
Sorry guys for not making it clear first time.
Let me explain it again.
When I click on the specific cell first time, it should arrange the data in
ascending or descending order.
Similarly, when I click the same cell again, it should arrange the data in
reverse
Hi,
How do we calculate the difference between two dates in Hours.
Dates are like mm/dd/ format only.
--
*Thanks and Regards,*
Jitendra Kr. Verma| Sr. Software Engineer
Mob: +91.9700695633
--
--
Some important
Hello Ashish
Excellent Stuff. One Request. Is it possible to freeze the following to
accept only what is in the Drop Down list:?
1. Name of the Waiter (Only Accept what is in the drop down)
2. Order (Only Accept what is in the drop down)
Also, The cursor begins with Table Number. Is it
Sub consolidatefromdifferentworkbooks()
Application.DisplayAlerts = False
'On Error GoTo abc
Dim ask As Workbook
Dim ask2 As Workbook
Dim ASK3 As Workbook
Set ASK3 = ActiveWorkbook
Dim i As Long
Dim j As Long
Dim N, z, r, s, k, d As Long
s = 1
k = 1
Dim x As String
Dim temp As String
Dim
=TEXT(A1-B1,[HH]:MM)
On Thu, Jan 27, 2011 at 10:48 AM, Jitendra Verma
jitendra.kumarve...@gmail.com wrote:
Hi,
How do we calculate the difference between two dates in Hours.
Dates are like mm/dd/ format only.
--
*Thanks and Regards,*
Jitendra Kr. Verma| Sr. Software Engineer
Mob:
OR USE
=INT((A1-B1)*24)
On Thu, Jan 27, 2011 at 11:54 AM, ashish koul koul.ash...@gmail.com wrote:
=TEXT(A1-B1,[HH]:MM)
On Thu, Jan 27, 2011 at 10:48 AM, Jitendra Verma
jitendra.kumarve...@gmail.com wrote:
Hi,
How do we calculate the difference between two dates in Hours.
Dates
34 matches
Mail list logo