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

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

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
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 the remaining sheet and that needs to be seperated in different individual sheet in my desktop or in a different file

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

2010-11-30 Thread Frank Linden
Hello,   Do you mean that you want to collect the data on all 5 sheets and add it to a 6th sheet and then save the workbook with all 6 sheets? Or do you need to take the data from the 5 sheets and put it on one sheet, then saving a new workbook with only one sheet?       --- On Tue, 11/30/10, Man