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$$ 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$$ Need help on Excel

2016-11-18 Thread Mohd Sadiq
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 -- 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)

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

2010-12-08 Thread Dilip Pandey
You are welcome Sharat. Best Regards, DILIPandey On 12/8/10, Sharath Sambrani wrote: > Fantastic!!! > > Thanks a ton Dilip! > > Sharath > > -- Forwarded message -- > From: Dilip Pandey > Date: Wed, Dec 8, 2010 at 8:43 PM > Subject: Re: $$Exc

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

2010-12-08 Thread Dilip Pandey
Hi Sharath, Please check the attached file which has the resolution as per your requirements. :) Best Regards, DILIPandey On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani < sharath.c.sambr...@gmail.com> wrote: > Hi, > > I have two columns A and B. > > column A contains list of tasks and column

$$Excel-Macros$$ Need help on Excel Dynamic List

2010-12-08 Thread Sharath Sambrani
Hi, I have two columns A and B. column A contains list of tasks and column B contains sub-tasks against each primary task. i would like to have two drop down cells in column C and D. whenever i select an option in the dropdown in cell C1, the list in D1 should show only the sub-tasks that belon

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

2010-12-01 Thread Frank Linden
-Macros$$ Need help on excel sheet To: excel-macros@googlegroups.com Date: Wednesday, December 1, 2010, 12:15 AM No,  I have different data (place wise) in 5 tabs, my expectation is that wile pasting the raw data in the first sheet , it should divide the data as per the region or place wise in

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

2010-11-30 Thread Manjunath C
ut it on one sheet, > then saving a new workbook with only one sheet? > > > > --- On *Tue, 11/30/10, Manjunath C * wrote: > > > From: Manjunath C > Subject: $$Excel-Macros$$ Need help on excel sheet > To: excel-macros@googlegroups.com > Date: Tuesday, November 30, 201

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

2010-11-30 Thread Frank Linden
, Manjunath C wrote: From: Manjunath C Subject: $$Excel-Macros$$ Need help on excel sheet To: excel-macros@googlegroups.com Date: Tuesday, November 30, 2010, 4:12 AM Hi All,   Can anyone help me, I have data in 5 tabs, now i need to make it in seperate excel sheet and paste it local desktop

$$Excel-Macros$$ Need help on excel sheet

2010-11-30 Thread Manjunath C
Hi All, Can anyone help me, I have data in 5 tabs, now i need to make it in seperate excel sheet and paste it local desktop. Any macros available - appreciate your help in advance. Thanks Manjunath -- -- Some impor

$$Excel-Macros$$ need help on Excel VBA: refEdit control

2010-03-15 Thread w...@air.org
Hello there, I need to have users to select the range in the spreadsheet and use what's selected to do further action. Is refEdit the right one to use? The ideal would be: when user selects the range, in the refEdit box it shows the values in the selected range. For example, "A" in A1, "B" in A2,