Re: $$Excel-Macros$$ Macro to copy from one worksheet to another if a cell value matches

That can be done just attach a sample file showing desired output. On Tue, Apr 15, 2014 at 12:03 AM, vaibhav garg wrote: > Hi Ayush, > > > I want to copy certain columns from a source sheet to a target sheet > based on a unique identifier than is present in both the sheets. > Please help me ,

Re: $$Excel-Macros$$ Copy Identical Headings from various sheet to a Result sheet

Attached should work...If your format is fixed ..let me if know if not and I will give you other way round. On Mon, Apr 14, 2014 at 1:51 PM, Rashid Khan wrote: > Hello All, > > I am using Excel 2010 > > I have attached a sample of my problem. > > I have many sheets with identical set of heading

$$Excel-Macros$$ Macro to copy from one worksheet to another if a cell value matches

Hi Ayush, I want to copy certain columns from a source sheet to a target sheet based on a unique identifier than is present in both the sheets. Please help me , its highly urgent. regards vaibhav -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:O

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

Thank you paul, for exposing us to the scripting.dictionary object. Can you please share, some more details and uses of the dictionary Object. Regards Eugene On Tue, Apr 8, 2014 at 7:33 PM, Paul Schreiner wrote: > I did it two different ways. > You IMPLIED that you wanted a macro (hence, the b

Re: $$Excel-Macros$$ Random numbers in decimal

absolutely.   The vba code for random numbers is rnd()   So, you can use something like:   rNum = rnd()   this will give you a single-precision random number between 0 and 1 (like: .5795186) You can then round this to whatever you like. rNum = int((Rnd * 5) + 1  will give you a random integer be

Re: $$Excel-Macros$$ Random numbers in decimal

Hi Falina, try this: =RANDBETWEEN(1,10)/10 or =RANDBETWEEN(1,99)& "," & RANDBETWEEN(1,99) regards, Basole. 2014-04-14 4:50 GMT-03:00 Falina Gan : > To Whom It May Concern, > > Could you write in VBA on decimal random numbers? > > Hope to hear from you. > > Thanks. > > -- > Are you =EXP(E:RT

$$Excel-Macros$$ Copy Identical Headings from various sheet to a Result sheet

Hello All, I am using Excel 2010 I have attached a sample of my problem. I have many sheets with identical set of headings on all the sheets. I need a macro which should create a Result sheet and copy Columns 1, 16, 17 and 23 for the first 10 sheets and put it on the Result Sheet. I need to co

$$Excel-Macros$$ Random numbers in decimal

To Whom It May Concern, Could you write in VBA on decimal random numbers? Hope to hear from you. Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM