Dear experts
I have attached an excel file containing data of qualification. On the
userform I created check boxes with similar to the datasheet data.
I need action like, only the tickmarked check box data only shown on the
data sheet all other have to go in hidden mode (even in print also).
Dear Amit,
you can also try through VBA..
Sub reverse_order()
Dim i, rw As Integer
rw = Cells(Rows.Count, A).End(xlUp).Row
For i = 1 To rw
Cells(i, B).Value = Cells((rw + 1) - i, A)
Next i
End Sub
See attached sheet.
On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU)
Dear Noor Good Morning,
Still I did not understand the
procedure, please again I repeat the same thing I want to shift the
cells below to top to form a single line order.
Please any code that can help me.
I write one but it doesn't seem to work
Hi Jay,
Thanks, It's done with 2nd option.
Regards
Nilesh
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Zibraan
Sent: Friday, March 16, 2012 12:17 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Missing serial number
Hi,
Check out the below link
http://www.contextures.com/CreatePivotTable.html
On Tue, Mar 20, 2012 at 2:53 PM, Karan Singh karan1...@gmail.com wrote:
Dear All,
Kindly send me some pivot table examples. I want to learn it.
Thanks
Kaяan
http://www.facebook.com/singhkarann
Dear all, pl help me to get the e mail ids that mentioned in a excel to copy at
recipient of lotus notes...
Say suppose that e mail ids mentioned in a excel particular cell i.e. cell c1,
i want that all email ids get copied and paste at receipint of lotus note...
Thanks fot your help in
Dear Prabhat,
Please check below link, hope it help to you.
http://www.excelitems.com/2011/01/send-lotus-notes-email-vba-excel.html
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
Don,
You are absolutely correct, I love it. I got into it and analyzed each and
every line. It is a perfect tool to learn from.
Thank you for your patience and teachings.
John
On Mon, Mar 19, 2012 at 3:26 PM, dguillett1 dguille...@gmail.com wrote:
You really should like this one
No
Dear Aivran,
I hope your requirement is this..
http://www.databasejournal.com/features/msaccess/article.php/3879376/Microsoft-Access-File-Backup-and-Maintenance-Options.htm
On Thu, Mar 15, 2012 at 11:35 AM, Aivi aivran...@gmail.com wrote:
Hi Excel group,
I want to know that in
Dear Talal,
It's really simple but it takes some time.
Spend 2-3 hours a day, every day, in these forums reading posts and trying
the solutions provided. Experiment!
Try to Create simple macro by help of record macro,Google,Books.
Hope your Excel-VBA will surely improve.
--
Thanks regards,
A small primer in the use of specialcells
Sub DeleteBlanksUsingSpecialCellsSAS()
Cells.SpecialCells(xlBlanks).Delete
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Tuesday, March 20, 2012 2:13 AM
To: excel-macros@googlegroups.com
Hi
Create a commandbutton. And put this code in the userform module.
Dim Rng As Range
Private Sub CommandButton1_Click()
Dim i As Long
Application.ScreenUpdating = False
Rng.Rows.Hidden = False
With Me
For i = 0 To .Controls.Count - 1
You may prefer using radio button instead.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Tuesday, March 20, 2012 1:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ checkbox query
Dear experts
I have attached an excel file
Dear Noorain,
Excellent!
Regards,
Muneer,
CC
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Tuesday, March 20, 2012 11:32 AM
To: excel-macros@googlegroups.com
Subject: Re:
Dear Sir, Mr. Don really amaazing!
I am not getting words to praise u'r talent
Again again again thanx
I am thankful to u both Mr. Noor you Mr. Don
U people r OXFORD of our group..
I think u unearthed all that are not seen by this generation
My
Our department has started using XL 2010, and we must respond to a client's
proposal using XL 2007. Based on this article by Microsoft,
http://technet.microsoft.com/en-us/library/cc179167.aspx, we can create a
file in 2010, avoid the new statistical functions, sparklines, slicers,
From looking at your files it appears that you haven’t given us much info to
go on.
what data do you want from the data file and where do you want it?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Monday, March 19, 2012 11:51 PM
To:
Hi All,
Need a small help from you all. I have attached a file with this mail. Now
if you open the file you can see there is a button named Login, if you
click on it, it will take the system time and date.
There are two columns available, Name (Column A) and Login Time (Column B),
now I want if
Using the sub below,anytime you make an entry in col A you get now in col B.
It’s automatic.
Goes in the sheet module. See attached.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 _
Or Target.Row 2 _
Or Target.Column 1 Then Exit Sub
If Len(Application.Trim(Target)) 0
Hi Karan,
Try to download *Excel 2007 PivotTables Recipes.pdf * book by 2007 by Debra
Dalgleish
Or you can search in youtube for Video's tutorial..
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Tue, Mar 20, 2012 at 2:59 PM,
Hi Prabhat,
Try Below links..
http://www.mrexcel.com/forum/showthread.php?t=62381
http://www.ozgrid.com/forum/showthread.php?t=36812
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Tue, Mar 20, 2012 at 4:17 PM,
Hi,
Please have a look on below link..
http://www.tricksmachine.com/2009/07/send-sms-online-from-your-excel-sheet.html
On Sat, Mar 17, 2012 at 12:56 PM, Deba Ranjan drdeva...@gmail.com wrote:
*
*
Dear expert,
I am looking out for sending text sms to numbers by the help of excel.
Excel does a very good job of knowing row 1 is column names even if the
data type is the same for the entire column.
But it is not always correct. If I insert columns of numbers then insert
a new row1 and put in text headers it considers them
column names even if the entire column is set to
Hi Dave,
Actually Excel 20072010 or more or less Samefile Format options..You dont
need to install any Compatibility package and all ...
You can just Save files as a *.XLSX,.XLSM.*..You will not fild any problems
on this..
Also you can set default file save option as .XLSX .
*Best Regards,*
Sorry but this VBA is not working
Can we have some very simple command like Alt+E+S+V+E which is used to
transpose while special pasting!
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 20 March 2012 11:44
To:
Dear Amit,
Pls check attached sheet.
On Wed, Mar 21, 2012 at 7:49 AM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Sorry but this VBA is not working
** **
Can we have some very simple command like Alt+E+S+V+E which is used to
transpose while special pasting!
** **
Best
Good morning
I want to fetch data from the Student data.xls to student marks.xls without
opening the student data.xls file.
regards shankar
On Wed, Mar 21, 2012 at 12:08 AM, dguillett1 dguille...@gmail.com wrote:
From looking at your files it appears that you haven’t given us much
info to
27 matches
Mail list logo