Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data

2013-11-16 Thread xlstime
attachment missing . Enjoy Team XLS On Thu, Nov 14, 2013 at 9:46 AM, Rajan sharma wrote: > Dear experts, > > > I am unable to write the formula for the attached excel file. > Please help me to create formula please..i have tried many a times, but > unable to w

Re: $$Excel-Macros$$

2013-11-16 Thread xlstime
"creditor details" sheet missing . Enjoy Team XLS On Sat, Nov 16, 2013 at 6:39 PM, Sharad Shroff wrote: > The attach file has a worksheet named Sub-Ledger which contains List > of Sundry Creditors with their address and other detail > > i want the list of sundry cred

Re: $$Excel-Macros$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines

2013-11-16 Thread Denise James
Thank you for your response Eugene. I have a "fix" that stops adding comments after 250 and mention in the comment section to list the 250 and mention there are too many to list. I appreciate your help. I will look at your suggestion and let you know. On Sat, Nov 16, 2013 at 8:02 AM, Eugene Be

Re: $$Excel-Macros$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines

2013-11-16 Thread Eugene Bernard
Please verify the data on 266th row, with the data above 266 rows. Regards Eugene On Thu, Nov 7, 2013 at 1:59 AM, Denisetoo wrote: > I get a run time "1004" when the comment lines are at 266 lines. WIth > less than 200 comment lines the code runs fine. The DropDownTmp variable > list include