RE: $$Excel-Macros$$ help required

Hi Girish, in "USED VLOOKUP HERE" column i used Vlookup function taken table _array as "SYSTEM DATA" This is not a formula. I need the actual formula you used so I can see what you are trying to achieve. I don't mind persisting with this, but you will need to keep answering my questions. I don

Re: $$Excel-Macros$$ Paste to Next empty Row

I used your suggestion, but still have the same issue. I've included all the code - perhaps you some suggestions ? Thanks Private Sub Worksheet_Change(ByVal Target As Range) Dim historyWks As Worksheet Dim inputWks As Worksheet Dim lRec As Long Dim lRecRow As Long Dim lLastR

Re: $$Excel-Macros$$ Urgent Help needed

Thanx Aindril, I appreciate. Only that it's doing the reverse, it's finding sum for those who attempted less than 8 subjects. What I wanted is it finding sum if only one atempted either 8 or more subjects the sum found should be for the least 8 subjects of all the attempted e.g 1) If some one attem

Re: $$Excel-Macros$$ Urgent Help needed

the columns in total are over 15 so if more than 8 columns have data in them I want to get a sum of th least 8, but if only 7 columns have data then the sum shoulld not be put in. coz what might happen is if some one attempted only 3 subjects it might compute his sum which i don't want. On 2 Novem

Re: $$Excel-Macros$$ Paste to Next empty Row

As I said, you can use the xlLastCell method. it considers cells that WERE used as "reserved". It's kind-f like if you were to hit "undo", the deleted rows would return, so it considers the deleted rows as "reserved" until "undo" is no longer possible, like when you exit and re-open the file. Anot

Re: $$Excel-Macros$$ Urgent Help needed

Hi, It looks like your calculations are not working as you are Displaying the numbers as text. For Example: The following Formula: = IF(sheet1!Q2>74,"1",IF(sheet1!Q2>69,"2",IF(sheet1!Q2>64,"3",IF(sheet1!Q2>59,"4",IF(sheet1!Q2>49,"5",IF(sheet1!Q2>44,"6",IF(sheet1!Q2>39,"7",IF(sheet1!Q2>29,"8",IF(sh

Re: $$Excel-Macros$$ Excel 2007 to 2003

Can´t you install the compatibility pack? 2010/11/2 sachin83_1...@yahoo.com > hey friends, i need to knw is there any shortcut or key to convert > Excel 2007 to 2003 n vise versa, pls help me out > > -- > > -- >

Re: $$Excel-Macros$$ Paste to Next empty Row

I beleive the problem is that if the data in column A gets deleted by accident, it sees that row as empty and overwrites the whole row. Is there a way to work around this ? Thank-you On Nov 1, 11:21 am, Paul Schreiner wrote: > Jeff, > > There are lots of ways of finding the "next" empty row. > I

Re: $$Excel-Macros$$ Urgent Help needed

Hi Ayoub, Can you please explain this: Of these columns some lack data if less than 8 of the above columns lack data word "missed" should appear Regards, Andy On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande wrote: > Good afternoon > I need some help on a project that is buzzing ma head > attach

$$Excel-Macros$$ Re: Excel 2007 to 2003

Hi Sachin, Visit this link - http://excel2003menu.excelitems.com Alternatively, if you remember the shortcuts of excel 2003, then you can you use them too. Excel 2003 shortcuts works very well in Excel 2007 like Alt+D+S(to sort the values) & Alt+F+A(To save as) etc etc. ___

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

HI GUYS...JUST WANT TO KNOW WHETHER THIS IS POSSIBLE TO DO OR NOT. On Tue, Oct 26, 2010 at 5:09 PM, sudheer lolla wrote: > > > -- Forwarded message -- > From: sudheer lolla > Date: Mon, Oct 25, 2010 at 10:42 AM > Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FI

$$Excel-Macros$$ Excel 2007 to 2003

hey friends, i need to knw is there any shortcut or key to convert Excel 2007 to 2003 n vise versa, pls help me out -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :