$$Excel-Macros$$ macro to be edit

2016-11-21 Thread Izhar
HELLO I'm interested to make column B as TEXT TO COLUMN thru the attach macro, I'm running the macro but nothing happend, would you please edit this macro so that the above target is achieved. Please take the whole column in the macro dont choose the range Thanks in advance -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Need help on Excel

2016-11-21 Thread Mohd Sadiq
Want to excel formula on this Regards, Mohd Sadiq On Nov 21, 2016 6:54 PM, "Paul Schreiner" wrote: > OK, I'd need a bit more information. > I can make LOTS of assumptions, but I'd rather not do this multiple times. > > So, for each row of data, you want to determine the FIRST column > containi

Re: $$Excel-Macros$$ Need help on Excel

2016-11-21 Thread Paul Schreiner
OK, I'd need a bit more information.I can make LOTS of assumptions, but I'd rather not do this multiple times. So, for each row of data, you want to determine the FIRST column containing WO and the LAST column containing WO. Are you wanting to use VBA or Excel functions?  A simple function would

Re: $$Excel-Macros$$ Accessing a function of another Workbook.

2016-11-21 Thread Paul Schreiner
Yes: First, make sure the functions are defined as "public".As in:In Book1.xlsb:Public Function Test_Calc(iVal)Test_Calc = iVal + 10End Function In Book2, use:=Book1.xlsb!Test_Calc(A2)  Paul- “Do all the good you can, By all the means you can, In all the

Re: $$Excel-Macros$$ Need help on Excel

2016-11-21 Thread Mohd Sadiq
Team , Pls update on this On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq wrote: > Team , I have data where I want to first date of "WO" and last date of > Week off in a week. > > attached is the excel sheet for your reference. > > Pls treat it on priority > > > > Regards > Mohd Sadiq > 979223

$$Excel-Macros$$ Accessing a function of another Workbook.

2016-11-21 Thread Eugene Bernard
I have two open workbooks A and B, in my system, and I like to use the function available in Workbook A from Workbook B. Is it possible. Regards Eugene -- 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 @