Thanks group for your overwhelmed response on this topic.
@Shyam : Thanks for sharing tips and bugs. you are excellent member of
group. I am proud that you are part of this group. Keep Posting.
@Sudhir : Thanks for idea but it appears tedious to edit the file and
upload in the group. There will be two many copies. Very difficult to
consolidate all tips into one.
If you want consolidated output then we I can upload
these tips on our group blog @ exceldailytip.blogspot.com . Here you
will already find more than 50 tips published.
@draco664 : Thanks for sharing Best Practice. I loved it.
Best regards,
Ayush Jain
Group Owner.
On Mar 18, 7:28 pm, draco664 <draco...@hotmail.com> wrote:
> Personally, whenever I start a new job, or install a new version of
> Excel, the first thing I do is record the following macro.
>
> Sub CopyPasteSpecialValues()
> '
> ' CopyPasteSpecialValues Macro
> ' Macro recorded 27/11/2008
> ' Keyboard Shortcut: Ctrl+Shift+V
> '
> Selection.Copy
> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
> SkipBlanks _
> :=False, Transpose:=False
> Application.CutCopyMode = False
> End Sub
>
> Most of my job involves data manipulation/extraction. To do this, I
> often write temporary functions which take existing raw data and turn
> it into more easily-readable formats.
>
> Since I share this data with sub-contractors and clients, I'm not
> permitted to release what is in effect, my employer's intellectual
> property. The macro allows me to highlight a range of cells, and with
> one keystroke, replace the existing functions with the values.
>
> On 18 Mar, 04:26, Ayush <jainayus...@gmail.com> wrote:
>
> > Hello Everyone,
>
> > I request you all to share any tips or tricks that you have about MS
> > Excel in the group. It really helps.
>
> > The tip can be anything like formula, most used calculation, excel
> > trick, hidden truth or could be anything which you think can be done
> > in an easier way.
>
> > It can be any bug of excel also. Anything about excel that you
> > know....anything
>
> > Sharing just increases the knowledge.
>
> > Keep Posting...
>
> > Best regards,
> > Ayush Jain
> > Group Owner
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
