Re: $$Excel-Macros$$ Re: Number sequentially, skipping blank cells

2011-01-07 Thread Maries
Find the attached file... Rgds, Maries On Fri, Jan 7, 2011 at 12:46 PM, siti Vi villager.g...@gmail.com wrote: please check this formula (written in A2) =IF(A1=COUNTA($B$2:B2),,COUNTA($B$2:B2)) best regards, On Fri, Jan 7, 2011 at 1:06 PM, Rahul Gandhi myname.ra...@gmail.comwrote:

Re: $$Excel-Macros$$ Multiple Selection of cells copying the same using macro

2011-01-07 Thread Raj Mahapatra
kindly help on this On Thu, Jan 6, 2011 at 6:03 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi group, requesting you to tell me the macro codes for Multiple Selection of cells copying the same thanks Rajesh --

Re: $$Excel-Macros$$ Multiple Selection of cells copying the same using macro

2011-01-07 Thread ashish koul
can you send sample sheet On 1/7/11, Raj Mahapatra rajafs...@gmail.com wrote: kindly help on this On Thu, Jan 6, 2011 at 6:03 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi group, requesting you to tell me the macro codes for Multiple Selection of cells copying the same thanks

Re: $$Excel-Macros$$ How to get the system name using macro

2011-01-07 Thread Rajesh K R
Hi Thanks for the code , its what I want exactly. Regards Rajesh kainikkara On 1/7/11, lawrence hordy lawreph...@gmail.com wrote: is this how you name your computer ? On Thu, Jan 6, 2011 at 3:47 PM, Daniel dcolarde...@free.fr wrote: Hi, MsgBox Environ(computername) Regards. Daniel

Re: $$Excel-Macros$$ Multiple Selection of cells copying the same using macro

2011-01-07 Thread Paul Schreiner
Raj, I'm sorry to say that this post has been largely ignored because it contains almost no usable information! --- requesting you to tell me OK.. you're asking a question... the macro codes Since you're here, we can assume it's VBA

$$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread Erick C
Hello everybody, I am in desperate need of some assistance, and I am hoping someone may be able to give me a hand. I am still a bit of a novice when it comes to vba code writing, so I am hoping that it may just be something that I am not aware of. I have some code that makes a string of text

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread ashish koul
can you attach the sample sheet On Fri, Jan 7, 2011 at 8:40 PM, Erick C boricua2...@gmail.com wrote: Hello everybody, I am in desperate need of some assistance, and I am hoping someone may be able to give me a hand. I am still a bit of a novice when it comes to vba code writing, so I am

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread Paul Schreiner
Align-left and Align-Right is irrelevent (I think) because alignment is a paragraph property, not a string property. What you're saying is that you need the string padded with spaces either on the left or right... So, by example, if you were padding with underscores (_), then the results you're

$$Excel-Macros$$ Fwd: need help

2011-01-07 Thread Rajasekhar Praharaju
Hi , In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if one activity is performed twice

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread Erick C
Paul - Thank you, this is exactly what I was looking for! On Jan 7, 11:37 am, Paul Schreiner schreiner_p...@att.net wrote: Align-left and Align-Right is irrelevent (I think) because alignment is a paragraph property, not a string property. What you're saying is that you need the string

$$Excel-Macros$$ Distribution-Supply Chain/Retail Sector

2011-01-07 Thread Ramkesh Maurya
Dear All, *Wish u a happy New Year -2011.* Can anybody help me in distributiing Stocks from Warehouse to Branches. For example current position of DEL Warehouse is *DEL Warehouse* *Noida* *Gurgaon* *Faridabad* 100 (20) 50 (10) (Data in brackets is negative i.e.

$$Excel-Macros$$ Fixing chain of if then statements

2011-01-07 Thread larry
I have a series of if then statements that trigger different instructions, numbered by Phase. Ideally, I only need the first one that applies. If I get a second true if then stement that changes the path and the program goes off track. Is there a better way to write the following: Phase=6 If

Fwd: $$Excel-Macros$$ Fwd: need help

2011-01-07 Thread Rajasekhar Praharaju
Hi , Please help me in this concern, In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if

Re: $$Excel-Macros$$ Fwd: need help

2011-01-07 Thread Rajasekhar Praharaju
Please find the attached sheet i could able to build formula for single line item But i want if the criteria is having mulitple line items the results should display as Date description, Date description, Date description. Please help me in this concern, Thanks, Raj On Sat, Jan 8, 2011 at