Re: $$Excel-Macros$$ Cell to multi cell.

2012-04-24 Thread Deba Ranjan
*Great job Thanks shaik. * Thanks & Regards,* * On Wed, Apr 25, 2012 at 12:15 PM, Shaik Waheed wrote: > HI ranjan, > > I just used the text to columns wizard from tool bar menu, converted into > it columns, then transposed the data to columns i.e, one below the > otherthats it > > On

Re: $$Excel-Macros$$ Cell to multi cell.

2012-04-24 Thread Shaik Waheed
HI ranjan, I just used the text to columns wizard from tool bar menu, converted into it columns, then transposed the data to columns i.e, one below the otherthats it On Wed, Apr 25, 2012 at 12:07 PM, Deba Ranjan wrote: > *Dear Shaik, > > Thank you very much but what ie the formula for

Re: $$Excel-Macros$$ Cell to multi cell.

2012-04-24 Thread Deba Ranjan
*Dear Shaik, Thank you very much but what ie the formula for that ?? can you please explain me that ?? * Thanks & Regards,* * *Deba Ranjan P*** On Wed, Apr 25, 2012 at 12:05 PM, Shaik Waheed wrote: > Hi Ranjan, > > PFA, hope this is what u r luking for... > > On Wed, Apr 25, 2012 a

Re: $$Excel-Macros$$ Cell to multi cell.

2012-04-24 Thread Shaik Waheed
Hi Ranjan, PFA, hope this is what u r luking for... On Wed, Apr 25, 2012 at 11:54 AM, Deba Ranjan wrote: > * > *Hi Experts, > >Please find the attached file. i have a problem in that , the words pr > numbers are in only one cell. i want to make separate out of that cell to > many cell. plea

$$Excel-Macros$$ Cell to multi cell.

2012-04-24 Thread Deba Ranjan
* *Hi Experts, Please find the attached file. i have a problem in that , the words pr numbers are in only one cell. i want to make separate out of that cell to many cell. please find the attached, i have expalin with those example. thanks in advance. Thanks & Regards,* * *Deba Ranjan P*** -

Re: $$Excel-Macros$$ Re: Block cell editing

2012-04-24 Thread Abdulgani Shaikh
I am new to this, can you please explain in detail how to do this Regards On Tue, Apr 24, 2012 at 2:47 PM, CoRe wrote: > Hello Rd > > > In the Review tab , Protect Workbook/Structure , create a password , after > in the same tab go on Protect Sheet create a password and it is done. > > > > On Tu

$$Excel-Macros$$ data download from different Sites, Through VBA Coading

2012-04-24 Thread prince sethi
Hi Can you please guide me as i have to download the data from Different sites for reporting purpose. For that i have to click several links copy from there & paste it to Excel sheets. Could someone guides me or if someone has any material where can i learn the same. Regards Prince -- FORU

$$Excel-Macros$$ Please suggest as i want to learn MS-Access (Noida)

2012-04-24 Thread prince sethi
I am not aware whether i should have to write this or not.. If it not adequate post please discard this one but not banned me from this Forum. what will be the duration for the same. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread t

$$Excel-Macros$$ Need help creating vba logic for timeclock data spreadsheet

2012-04-24 Thread Theron
Hi everyone I'm having a tough time trying to figure out how to work vba code for data results from a time clock spreadsheet (I've attached a sample of the data). Any advice/help would be much appreciated. thanks in advance for any of your expertise and patience- I hope I'm explaining in detai

$$Excel-Macros$$ Direct Client Req: Solutions Architect( ITKO)

2012-04-24 Thread Mastan Shaik
Please reply me at *mas...@sariansolutions.com* Hi, Let me know if you have any consultant available for one of our direct client requirement and please fill details: *Consultant Details:* Full Name of the Candidate Contact Number E-Mail ID Best time to call Availability

$$Excel-Macros$$ Sure Shot 20-20: Java Developer Tampa, FL in Tampa, - 20 positions - NO END CLIENT INTERVIEW

2012-04-24 Thread DK
We have a *VERY URGENT* Requirement in for *Java Developer *in Tampa, FL*.* Please let me know if you have any matching resumes for the below mentioned position ASAP. *Minimum qualifications:* * * *Java Developer* *Location: Tampa, FL* *Duration: 12 months+* *No of openings: 20* *Max Billi

$$Excel-Macros$$ Custom functions not being performed on "L39", but they are performed on "L40-L42"

2012-04-24 Thread Anil Pandit
Hi all, I hope someone can help me, because I cannot see any reason why this isn't working. No action is taken for cell L39, however cells L40-L42 behave as expected. *Step 1: A value is changed in cell "L39"* Private Sub *Worksheet_Change*(ByVal Target As Range) Application.EnableEvents = Fa

$$Excel-Macros$$ Re: Need help in ranking with multiple criteria

2012-04-24 Thread CoRe
Hello Vijay. PFA. On Tuesday, April 24, 2012 8:31:29 AM UTC+3, Vijay Mane wrote: > > > Hi Experts, > > Please refer file for more information > > I want to calculate top performer agent according to achieved target and > quality > If there are multiple agent with same achieved target and qua

$$Excel-Macros$$ Re: Block cell editing

2012-04-24 Thread CoRe
Hello Rd In the Review tab , Protect Workbook/Structure , create a password , after in the same tab go on Protect Sheet create a password and it is done. On Tuesday, April 24, 2012 12:03:51 PM UTC+3, Rd wrote: > > I ant to block cell editing or editing a sheet without using a password > in

$$Excel-Macros$$ Block cell editing

2012-04-24 Thread Rd
I ant to block cell editing or editing a sheet without using a password in the sheet, can u please help me out with the codes -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro

Re: $$Excel-Macros$$ Problem to filter in pivot table

2012-04-24 Thread Shekhar Sharma
Hi Ashish, In the pivot you can add one more entry of "Stock" in row as well > De-select "0" and then remove "Stock" from row again. I think this is what you are looking for. Regards Shekhar Sharma On Tue, Apr 24, 2012 at 10:04 AM, Ashish Bhalara wrote: > Dear expert, > > I need the filter in