$$Excel-Macros$$ Excel Macro How to retrive selected values based on another worksheet

HI .. I am having patient id of about 4000 patients and associated physician in one sheet and in another sheet contain patient problem detail. now i want to find out only those patient data from another sheet who has been chosen from previous sheet with assigned physician for eg, cardiologist.

Re: $$Excel-Macros$$ For Excel Beginner, please try this test...

dear ravi, At least attach any test file. here is no test file. On Wed, Dec 21, 2011 at 9:36 PM, Chuka Lkh chuka...@gmail.com wrote: please attach file On Tue, Dec 20, 2011 at 10:58 PM, Vikash Chandra vks.chan...@gmail.comwrote: Dear Ravi, I didnt find any attachment.Please send

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Hi, is there any update in my case. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

Re: $$Excel-Macros$$ accessing files through form

thank you so much somnath, I will try and get back to you with the result. On Fri, Dec 23, 2011 at 4:28 PM, Somnath Pardeshi somcparde...@yahoo.co.inwrote: Hi, Try this i have used Adobe Reader 9.0 If their is any other version u ar using then you have to change codes accordingly

$$Excel-Macros$$dividing my data set in 70-30 Ratio

Hi Team, I am facing problem in breaking my data set into two random sample,which i need for model validation.means i wanted to break my entire row in two sample of say 70-30 ratio,in which the observations should be taken randomly from the original observations.Is there any function or macro we

Re: $$Excel-Macros$$ Excel Macro How to retrive selected values based on another worksheet

Send file with complete explanation and examples Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: SwadheenJain Sent: Saturday, December 24, 2011 2:24 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Excel Macro How to retrive selected values based

$$Excel-Macros$$ about getpivotdata

Hello sir, Please i want to know about getpivotdata . can you give me some examples.? Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

Re: $$Excel-Macros$$ about getpivotdata

2011/12/25 vijayajith VA vijayajith...@gmail.com Hello sir, Please i want to know about getpivotdata . can you give me some examples.? Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$dividing my data set in 70-30 Ratio

Hi Vikas, One way to do this would be using a function =RANDBETWEEN( min_value, max_value). For example if you insert a column in which you put this function =RANDBETWEEN(1, 100) it will generate random numbers between 1 and 100 then you can apply a filter on that column and select values below

$$Excel-Macros$$ Chuka Lkh wants to chat

--- Chuka Lkh wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-e958f1a6c3-584ba34c72-4JwMjKPVs9fg4zJ0JjCjWrUDTNE You'll

Re: $$Excel-Macros$$ Chuka Lkh wants to chat

2011/12/25 Chuka Lkh chuka...@gmail.com --- Chuka Lkh wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit:

Re: $$Excel-Macros$$dividing my data set in 70-30 Ratio

Thanks @ Anand, but the problem here will be it will give some random number,which will be not from my original observation.I want the new data set only from my original observation. For example, suppose my original data set has (34,45,56,67,78,89,100,54,65,76) these values. Now i want to split