RE: $$Excel-Macros$$ Filter based on coulmns

2013-04-27 Thread Amit Desai (MERU)
You are right. Can you please suggest some macro for that? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 26 April 2013 17:17 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Filter based on

Re: $$Excel-Macros$$ Filter based on coulmns

2013-04-27 Thread Paul Schreiner
So... you're saying copy/paste traspose isn't an option and you want a macro. do you know anything about macros? or are you wanting someone to write one for you? either way, if you want help with a macro, you'll have to provide WAY more information than you've given.   Paul

Re: $$Excel-Macros$$ Create Sheets by given name.........

2013-04-27 Thread priti verma
Hi Kuldeep, You can also try this. Sub CreateSheet() For Each rngCell In Selection ThisWorkbook.Worksheets.Add.Name = rngCell.Value Next rngCell End Sub Regards Priti verma On Fri, Apr 26, 2013 at 7:26 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Experts, I want to

$$Excel-Macros$$ Copy/Paste Problem

2013-04-27 Thread Bill Q
Hi, When copying and pasting from a particular site in question - for whatever reason it will not copy the color. Is there anyway to keep the original color ? The link is

Re: $$Excel-Macros$$ Create Sheets by given name.........

2013-04-27 Thread Bé Trần Văn
1/ Create one sheet Sub CreateSheet() Worksheets.Add End Sub 2/ Remove 1 sheet named THANH, and create a new one sheet called TRUNG Sub CreateSheet() On Error Resume Next Application.DisplayAlerts = False Sheets(THANH).Delete On Error GoTo 0 Worksheets.Add

Re: $$Excel-Macros$$ Copy/Paste Problem

2013-04-27 Thread David Grugeon
I think you will Nero download the source code and go through it to extract the indicator (probably a CSS class) that turns a particular item green. It probably could be done in VBA but a big exercise. On Sunday, 28 April 2013, Bill Q wrote: Hi, When copying and pasting from a particular