Re: $$Excel-Macros$$ Re: Input data from userform into 2 sheets. 2nd sheet would be by matching header

2014-09-09 Thread Vaibhav Joshi
Hi I am not clear on what you want! can you explain wirth dummy data in sheet2 too. + *I did not do this for you. God is here working through me for you.* On Tue, Sep 9, 2014 at 4:39 AM, Mr_Bill wrote: > Sample workbook if help to get the answer for this > https://www.dropbox.com/s/9ea1

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

2014-09-09 Thread Shaik Waheed
Thanks Mahesh & Vaibhav, Its working fine :) Thanks, Waheed On Tue, Sep 9, 2014 at 11:27 AM, Mahesh Patil wrote: > Hi, > PFA > > > On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed wrote: > >> Hi friends, >> >> I need your help to create a macro, its motive is to find out the >> variable cost of ph

$$Excel-Macros$$ VBA Code For Data Compiler

2014-09-09 Thread Satendra kumar
Hi All Expert, please solve my query, i want Data Compiler from one workbook to another workbook. *Noorain sir please look below code highlight range. how to fix this range.* Sub Compiler() Dim rng, rng1 As Range Dim i, j, k As Integer Set rng = Sheet1.Range("h1:h" & Sheet1.Range("h65536").End

Re: $$Excel-Macros$$ Re: Input data from userform into 2 sheets. 2nd sheet would be by matching header

2014-09-09 Thread Mr_Bill
Here is some data in sheet2 https://www.dropbox.com/s/9ea1r3wfe24oav7/example%20workbook.xlsm?dl=0 I just want it so this will put the points received in sheet1 and sheet2. Leave how it puts it in sheet1 as that part works perfect. But for sheet2 I would like the data to be in the column that m

Re: $$Excel-Macros$$ VBA Code For Data Compiler

2014-09-09 Thread NOORAIN ANSARI
Dear Satendra, Please try it...hope it will help to you... http://www.excelvbaclinic.com/2013/12/combine-all-workbook-of-folder.html Thanks, Noorain Ansari On Tue, Sep 9, 2014 at 5:07 PM, Satendra kumar wrote: > Hi All Expert, > > please solve my query, i want Data Compiler from one workbook

$$Excel-Macros$$ Looking for help creating a link to a link in Excel (2007)

2014-09-09 Thread Jeff Mitchell
I am hoping somebody can help me resolve a problem I am having in Excel 2007. I have a spreadsheet that has a worksheet for each month of the year( ill call them Jan, Feb, Mar, etc..) and, in the same spreadsheet, I have worksheets that track accounts (acc1, acc2, acc3, etc). I refer to each

Re: $$Excel-Macros$$ VBA Code For Data Compiler

2014-09-09 Thread Satendra kumar
Dear sir, my query is i have a master workbook with all clients row data. now i want clinets row data in a seprate workbook client name then save in folder. please solve this query. thank you so much for your quick reply! On Tue, Sep 9, 2014 at 10:05 PM, NOORAIN ANSARI wrote: > Dear Saten

Re: $$Excel-Macros$$ VBA Code For Data Compiler

2014-09-09 Thread Ashish Kumar
Hi Satender, Share your data with example. Regards Ashish -- 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 RULES 1) Use concise, accurate thread titles.

$$Excel-Macros$$ Convert IF formula to VBA

2014-09-09 Thread 'DanJ' via MS EXCEL AND VBA MACROS
Dear Everyone, I want to categorize age of receivables based on the number of days due using the formula below. The formula is in cell B2. =IF(A2>=180,"181 days up",IF(A2>90,"91-180 days",IF(A2>60,"61-90 days",IF(A2>30,"31 to 60 days",IF(A2>0,"1 to 30 days",IF(A2<=0,"Current")) How do I