$$Excel-Macros$$ Re: Data Validation and 2 Dimensional / Table lookup

2017-05-18 Thread 'Sleek' via MS EXCEL AND VBA MACROS
Just upload the actual excel file to see if the Frog can be helped. On Thursday, February 23, 2017 at 7:37:36 AM UTC+3, The Frog wrote: > > Hi Everyone, > > I have a table of data: > Product Type1Type2Type3Type4Type5Type6 > Apple TRUETRUETRUETRUETRUE

$$Excel-Macros$$ User form problem showing up Calendar

2017-05-02 Thread 'Sleek' via MS EXCEL AND VBA MACROS
I am getting error on this "cannot find object or library" :- Any speedy way to resolve it !!! How do i place the calendar ?? All names have been modified ,take note. -- 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) ! Join official Facebook pag

$$Excel-Macros$$ Re: Weekend rates to place in range

2017-05-01 Thread 'Sleek' via MS EXCEL AND VBA MACROS
gosh what are all these romanian speakers talking in my thread , hope not passing incrimating spy messages !!! On Saturday, April 29, 2017 at 4:59:17 PM UTC+3, Sleek wrote: > > Is there a simpler way to input weekend rates ? > see my worksheet !! > I used conditional formatting to highlight weeke

$$Excel-Macros$$ Weekend rates to place in range

2017-04-29 Thread 'Sleek' via MS EXCEL AND VBA MACROS
Is there a simpler way to input weekend rates ? see my worksheet !! I used conditional formatting to highlight weekends but to input range of dates seems like i have to do in quite a bit of typing !! I suspect probably using advanced filtering may help here !! -- Are you =EXP(E:RT) or =NOT(E

$$Excel-Macros$$ Re: Crack workbook password

2017-04-05 Thread 'Sleek' via MS EXCEL AND VBA MACROS
How do we know you are for real ?? Note learning bypass security rules is forbidden here. On Friday, March 31, 2017 at 11:18:52 AM UTC+3, sourav devrani wrote: > > Hi guys i have a password protected workbook but i lost my workbook > password can anybody tell me how to unlock mu password protec

$$Excel-Macros$$ Re: Make this total match to this other total by picking no.'s from list

2016-04-16 Thread 'Sleek' via MS EXCEL AND VBA MACROS
thanks, I saw your worksheet, but it will me some time to figure out exactly what you did as per your instructions above. On Wednesday, April 13, 2016 at 11:03:25 AM UTC+3, sleek wrote: > > > > Is it possible to have a solution to this or even multiple solutions ?? > > S.Lakhani > > -- Are you

$$Excel-Macros$$ Re: Categorise A,B,C,

2014-09-11 Thread 'Sleek' via MS EXCEL AND VBA MACROS
Thank you, I appreciate your help. On Sunday, September 7, 2014 11:45:57 AM UTC+3, Sleek wrote: > > i need to place A,B,C,D, E or F in column D to to be picked from table at > right. > A macro or formula could help. > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It

$$Excel-Macros$$ Re: Categorise A,B,C,

2014-09-08 Thread 'Sleek' via MS EXCEL AND VBA MACROS
No no, Ashit, it is giving me values from the table, I want it to give A,B, C , D.. On Sunday, September 7, 2014 11:45:57 AM UTC+3, Sleek wrote: > > i need to place A,B,C,D, E or F in column D to to be picked from table at > right. > A macro or formula could help. > > -- Are you =EXP(E:R

$$Excel-Macros$$ Re: Vlookup Issue

2014-09-07 Thread 'Sleek' via MS EXCEL AND VBA MACROS
You ought to spellcheck dictionery , the correct spelling is dictionary. On Monday, September 1, 2014 4:06:59 PM UTC+3, sk.yadav7186 wrote: > > Hello Friends, > > i have a query, please guide me. > > i have created a little software for word-meaning, now i want to display > error message when

$$Excel-Macros$$ Re: Help needed

2014-08-16 Thread 'Sleek' via MS EXCEL AND VBA MACROS
right click to select all sheets, then use Find Feature. On Saturday, August 16, 2014 8:29:28 AM UTC+3, Kaushik wrote: > > Hi Team > > In the attached excel file I want to do the following to obtain the > desired result > > 1. I want to find each cell in whole workbook and to see its repeating

$$Excel-Macros$$ Re: Minimum difference needed

2014-06-06 Thread 'Sleek' via MS EXCEL AND VBA MACROS
Just to say a big thank you, I am using your program which i will use continuously to sort out my exercise on a monthly basis, I salute you, Vaibhav. S.Lakhani On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote: > > > I need a minimum or zero difference, against the target totals i have se

$$Excel-Macros$$ Re: Minimum difference needed

2014-06-05 Thread 'Sleek' via MS EXCEL AND VBA MACROS
Thanks, VABZ, Actually making you do extra work, i don't know how to re-pay. On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote: > > > I need a minimum or zero difference, against the target totals i have set. > i have 3 columns, juggle around with figures.there is no barrier to how > many

$$Excel-Macros$$ Re: Minimum difference needed

2014-06-05 Thread 'Sleek' via MS EXCEL AND VBA MACROS
You can use the data once & once only. You have done it, but i have to juggle the targets around. The best way is to run macro twice only then in column C of Table to place what is data is left behind. When data loads onto column A of table, then remove that data from Column A of excel(not table

$$Excel-Macros$$ Re: Minimum difference needed

2014-06-05 Thread 'Sleek' via MS EXCEL AND VBA MACROS
NB: you used 96850 twice yet in my data appears only one, 193600 appears nowhere in your table but i have it in my data. Those are constants to move around. You are so close, yet so far. On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote: > > > I need a minimum or zero difference, against

$$Excel-Macros$$ Re: Minimum difference needed

2014-06-05 Thread 'Sleek' via MS EXCEL AND VBA MACROS
Sequence of events: first i pasted all my actual data on column A ,then i set it aside whatever has been utilised, then run the macro on remaining (remove blanks) , place aside the other data, whatever is left i then, place it final part of table(or array?) the macro is run twice but can as well

$$Excel-Macros$$ Re: Minimum difference needed

2014-06-04 Thread 'Sleek' via MS EXCEL AND VBA MACROS
Not workable the macro is omitting some figures & placing duplicate of others. The data should be used once but juggled around. On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote: > > > I need a minimum or zero difference, against the target totals i have set. > i have 3 columns, juggle ar

$$Excel-Macros$$ Re: Minimum difference needed

2014-06-02 Thread 'Sleek' via MS EXCEL AND VBA MACROS
On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote: > > > I need a minimum or zero difference, against the target totals i have set. > i have 3 columns, juggle around with figures.there is no barrier to how > many you can put in column but use only the figures i give you. I think > maybe

$$Excel-Macros$$ Minimum difference needed

2014-05-31 Thread 'Sleek' via MS EXCEL AND VBA MACROS
I need a minimum or zero difference, against the target totals i have set. i have 3 columns, juggle around with figures.there is no barrier to how many you can put in column but use only the figures i give you. I think maybe using a solver or goal-seek is in order. sleek12 I -- Are you =EX