Re: $$Excel-Macros$$ Sort

2010-12-04 Thread ashish koul
can you attach sample sheet.. On Sun, Dec 5, 2010 at 8:11 AM, Dick wrote: > I have a strange sort question. In column B there is information > every > 7 rows. Then you skip 1 row (Blank) Then there is the same > information > but with different dates in the next 7 rows and so on. Is it possible

$$Excel-Macros$$ Sort

2010-12-04 Thread Dick
I have a strange sort question. In column B there is information every 7 rows. Then you skip 1 row (Blank) Then there is the same information but with different dates in the next 7 rows and so on. Is it possible once there is information in All seven rows to delete that information and move everyth

$$Excel-Macros$$ MS Excel VBA Interview Questions & Answers

2010-12-04 Thread OpenExcel.com
Hi Friends, Click here --> http://www.excelitems.com/2010/12/excel-vba-interview-questions.html These Excel VBA Interview questions are being posted keeping in mind that reader is aware of working with VBA, have some programming and MS Excel background and is aware of terminologies. This questio

Re: $$Excel-Macros$$ EXCEL SHEET IN SEPARATE TOOL BAR

2010-12-04 Thread ChilExcel
yes yes, download this application . http://www.todoexcel.com/office-tabs/ also you can do with "Navigator Toolbar for Workbook Sheets" http://www.contextures.com/xlToolbar01.html I hope help you Chilexcel My link http://sites.google.com/site/chilexcel/Home http://www.youtube.com/user/

Re: $$Excel-Macros$$ Queries

2010-12-04 Thread in.vaib...@googlemail.com
Hi, Try Sumproduct formula Rgds Vaibhavj On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote: > Hi Everyone. > > I have large data in excel. for example in sheet 1. and we have name in > sheet 2 . I use vlookup function and fetch the production using vlookup . > now when i saw the total there i

Re: $$Excel-Macros$$ Queries

2010-12-04 Thread neil johnson
Hi Dilip, You grab my question, I need the second value of harmeet in the below cell. On Sat, Dec 4, 2010 at 3:19 PM, Dilip Pandey wrote: > Hi Neil, > > Yes, this can be done but I am not sure if you want the second value > of harmeet in the below cell OR you want that to be add-up in the > fi

Re: $$Excel-Macros$$ Queries

2010-12-04 Thread Dilip Pandey
Hi Neil, Yes, this can be done but I am not sure if you want the second value of harmeet in the below cell OR you want that to be add-up in the first cell value. Harmeet 100+1000 OR Harmeet 100 1000 Best Regards, DILIPandey On 11/28/10, neil johnson wrote: > Hi Everyone. > > I ha