$$Excel-Macros$$ how to lock selected cell or rows

Dear experts, please give me some advice or macro about the locking of selected rows or columns as i want and nobody can change or edit that. thanks ROHAN -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Macro Help - Please!

HI Kamal, Here is the sample workbook. Regards, Mrinal Saha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN grou

Re: $$Excel-Macros$$ Help needed to extract data by MM/Year

Thanks this is what I was looking for! On Fri, Feb 18, 2011 at 11:36 PM, ashish koul wrote: > > see if it helps > > On Sat, Feb 19, 2011 at 11:13 AM, San Pat wrote: > >> Hi Group, >> >> I need a urgent help to extract data by given MM/Year from a raw data. >> >> Basically, I am looking for a ma

Re: $$Excel-Macros$$ CODE DOESN'T WORK

Paul Dada, You are great .. Thanks for the explanation will work on your suggestions and get in touch with you again. *Many Regards,* *Rakesh* On Mon, Feb 21, 2011 at 9:51 PM, Paul Schreiner wrote: > Let's step through the code: > > RowCounter = 1 > > > > For ColName = 1 To 750 > > > > I

$$Excel-Macros$$ Macro Help - Please!

Hello Excel Gurus, Need small favour from experts, I have two columns in Excel, I need a macro, where if Column A contains value as "Step", column B should populate "Complete". If column A contains VP, Column B should populate "Pass". Step Complete VP Pass Step Complete VP Pass VP Pa

Re: $$Excel-Macros$$ Help required in excel

Hi Jitender, it's done without using vba coding just change CODE On Mon, Feb 21, 2011 at 8:50 PM, Jitender kumar wrote: > > > On 21 February 2011 10:25, anil panchal wrote: > >> please send sample file. >> >> >> On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < >> panwar.jaibeersi...@gma

Re: $$Excel-Macros$$ Diff excel Sheet based on Name & test

Hi mahesh, both r the same as i have mentioned on my prev mail dont look any value just want to delete complete column based on process name and the eg will remain same (pls refer earlier mail). Still if u want we can communicate via phone. If u can give me ur cell no or if u want u can also call

Re: $$Excel-Macros$$ Help required in excel

On 21 February 2011 10:25, anil panchal wrote: > please send sample file. > > > On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < > panwar.jaibeersi...@gmail.com> wrote: > >> Hi Jitendra, >> >> If you have that excel sheet forward it to us.. empty one will do.. >> Regards, >> Jaibeer >> >>

Re: $$Excel-Macros$$ Diff excel Sheet based on Name & test

Hi Maulik do u want to delete column which contain only "NA" , not "Na" is both are different or same On Mon, Feb 21, 2011 at 12:08 PM, maulik desai wrote: > Hi mahesh, > > in a simple manner u have given instruction to macro to del column > which contains "na" value in any columns right but i w

RE: $$Excel-Macros$$ I need to extract data from a sheet to another in the same workbook - please help.

Hello, I have to know which enterprise owns a particular sheet and which one is grouped in the "others" sheet. Maybe one more column in the "Main" sheet ? Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Suhas Envoy

Re: $$Excel-Macros$$ CODE DOESN'T WORK

Let's step through the code: RowCounter = 1   For ColName = 1 To 750           If Sheets("1").Cells(2, ColName) = Sheets("Name").Cells(RowCounter, 1) Then         Sheets("1").Cells(1, ColName) = 1         RowCounter = RowCounter + 1         Else         Sheets("1").Cells(1, ColName) = 0         En

RE: $$Excel-Macros$$ Printing Query using a excel sheet

Hello, Try : With ActiveSheet.PageSetup .CenterHeader = "original for the buyer" ActiveSheet.PrintOut .CenterHeader = "Duplicate for the seller" ActiveSheet.PrintOut .CenterHeader = "Transporter's Copy" ActiveSheet.PrintOut 'etc. End With Daniel -Message d'origin

RE: $$Excel-Macros$$ CODE DOESN'T WORK

The code is correct. Simply, there is no match and the test is always false. Can you post your data ? Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de rakesh kumar Envoyé : dimanche 20 février 2011 21:35 À : excel-macros@googlegroups.com Objet : Re

excel-macros@googlegroups.com

Thank U On Mon, Feb 21, 2011 at 12:35 PM, saggi wrote: > Just Go on DATA ribbon in Xl, Then Other Sources, then Give the path > of SQL table this exercise need to done once. > > after onward same u can pull from Existing Connection just need to > given Username & Password. > > Regards >

excel-macros@googlegroups.com

Thank U On Sun, Feb 20, 2011 at 12:55 PM, yogananda muthaiah < yogananda.mutha...@gmail.com> wrote: > Hi Venkatesh, > > Install SQL DTS (Data transformation services) available in microsoft > download center for export and importing the data from SSIS. > > Do revert if any clarification on the sa

$$Excel-Macros$$ Printing Query using a excel sheet

Hello Members Good Day! I have a excel sheet (invoice copy) which i want to print 7 copies I have a problem with the header that i want to print. The header is different for all the 7 pages while all the other content remains the same. the header of the invoice in the first page to be printed shou

Re: $$Excel-Macros$$ -- Please Help Code Doesn't Work

Plz share your code On Feb 21, 2:06 pm, rakesh kumar wrote: > Hi Dearests, > > Please Help Code Doesn't Work > > On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar > wrote: > > > > > > > > > > > *thanks Daniel Ji for the reply... here what I need and what the code > > doesn't do.* > > * > > * > > *Th

Re: $$Excel-Macros$$ -- Please Help Code Doesn't Work

Hi Dearests, Please Help Code Doesn't Work On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar wrote: > *thanks Daniel Ji for the reply... here what I need and what the code > doesn't do.* > * > * > *This code runs as long as the Sheets("1").Cells(2, ColNumber) = > Sheets("Name").Cells(RowCounter, 1)