$$Excel-Macros$$ Serial number tracker

Does anyone here know where i can get a serial number. tracker in Excel/Access or even exe file ? A01 to A000100= 100 certificates to issue to branch and branch issues to agent. -- 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 off

$$Excel-Macros$$ Re: LOOK INTO THIS AUTOMATION

Was it resolved ?? it looks a great feature !!! On Thursday, 11 May 2017 14:26:57 UTC+3, GENIUS wrote: > > please look the question inside the workbook > Thanks in advance. > -- 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 Faceboo

$$Excel-Macros$$ Link Excel to Word

I want to link my data in excel rows to word , I used paste special to link excel to word, but i need to word voucher to continue in sequence for the day:- I have done no PV 27 , but i need to continue with PV 28, 29 and so on for the day -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ RE: Excel to Link to Word

My objective:- I want to type in excel rows my data & I want each row to produce a sequenced payment voucher in word, How is it possible ? I did attempt to link them and update, but after that how do i get word to keep on continuing the sequence ? See excel (first) for row data & then linked

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

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

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

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

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

Schindler wrote: > > > ---- > On Sun, 4/30/17, sleek > wrote: > > Subject: Re: $$Excel-Macros$$ Weekend rates to place in range > To: "MS EXCEL AND VBA MACROS" > > Date: Sunday, April 30, 2017, 9:27 AM > > Ok,You mean cell B3 rather, i am doing that >

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

se a problem here , their is your way of solving it without me giving any hints/tips. On Sunday, April 30, 2017 at 8:35:37 AM UTC+3, Ashish_Bhalara wrote: > > Hi Sleek, > > Use below condition in cell A3 to get output as per your requirement. > > =IF(OR(WEEKDAY(A3,2)=6,WEE

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

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

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$$ Hotel costings, Multiple dates, worksheets with hotel rates, & supplements

I confess i got some formulae from here, and noted them down to design my workbook, as a guide to help me design this workbook. Then i tried to prepare Thai Hotel bookings and got stuck especially time when the stay is for 2 or more days, & Easter supplements also. The supplementary VIP ,Bestvi

$$Excel-Macros$$ Re: multiple sheet reference..

I wanted to pose a similar question like this here, but thanks, this will suffice, glad i did a search. On Friday, November 9, 2012 at 2:48:41 AM UTC+3, satiqjaffar satiqjaffar wrote: > > Hello brothers and sisters, > > > first of all i want to convey my thanks to all for your great service on

$$Excel-Macros$$ Re: List of unique items

Upload an xls or xlsx worksheet with examples. On Friday, 27 May 2016 12:40:05 UTC+3, Louis Omoya wrote: > > Hi all? Thid is my first post in the group. I appreciate the support > online communities such as this offer. > > To my problem (which i have spent 2 days with no success). > > I have a c

$$Excel-Macros$$ Re: EXCEL ADD-IN for reconciling two Data Tables

I am using this, do you mind modify the speeling of avialable to correct available !!! On Thursday, 13 September 2012 21:28:34 UTC+3, aju wrote: > > Dear Friends, > Please the attached Excel add-in Reconciliation > Tool made by me.This Add-in can be used to reconcile two

$$Excel-Macros$$ Re: 10 Microsoft Excel Formulas For All Kinds Of Work

I dont usually use networkdays much, & your site props up ads and offers, too. On Monday, 18 April 2016 11:40:43 UTC+3, Melissa James wrote: > > Hello Guys, > > Hello Guys, > > I would like to share an article about 10 Microsoft Excel Formulas For > All Kinds Of Work >

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

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.La

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

Is it possible to have a solution to this or even multiple solutions ?? S.Lakhani -- 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 page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Re: EXCEL ADD-IN for reconciling two Data Tables

Thank you sir for that, i appreciate and am using it at my workplace. On Thursday, September 13, 2012 at 9:28:34 PM UTC+3, aju wrote: > > Dear Friends, > Please the attached Excel add-in Reconciliation > Tool made by me.This Add-in can be used to reconcile two numerical f

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

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? A

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

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. > >

$$Excel-Macros$$ Re: Vlookup Issue

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

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

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 tota

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

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

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

get minimum possible difference. 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

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

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

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

well be run thrice, i also used the constants SET lowest first, set highest first then run the macro. unfortunately, the trial & error method via observation & juggling around worked better than macro, see workbook. On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote: > > > I

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

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

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

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

$$Excel-Macros$$ Minimum difference needed

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

Re: $$Excel-Macros$$ help on .pdf to excel

go to youconvertit.com On Dec 20, 9:01 am, Dilip Pandey wrote: > Hi Pooja, > > It is something related with text capturing from an image (PDF) file which > is beyond the capabilities of Excel, so try searching free/paid softwares > over Internet. > > Best Regards, > -- > DILIP KUMAR PANDEY >

$$Excel-Macros$$ RE: How did this happen ?

I just uploaded an excel file in your group, how did that happen in excel ? & how do i undo it. Sorry i could not manage to upload it ,attach it here, maybe the moderators can help ? --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Test of siginificance

But thats a topic that falls under statistics, You really need to look at a book of statistics, then apply formula in excel. On Oct 12, 3:44 pm, "v sheeba" <[EMAIL PROTECTED]> wrote: > Dear All, > Its any one taught me test of significance & how to apply this in FMCG data > with example files

$$Excel-Macros$$ Re: change from small letter to capital

Just use PROPER() or go to similar formulae. On Sep 20, 2:52 pm, "vinay keni" <[EMAIL PROTECTED]> wrote: > dear all, > > i want to know how to change from small letters to capital letters > as i have some 500 persons name which i have typed in small letters now > wants to change those

$$Excel-Macros$$ Re: Pls Help

Use this, but change from currency format. ' ' Main Function * ' Function SpellNumber(ByVal MyNumber) Dim shillings, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand

$$Excel-Macros$$ Re: Pls Help

Yes it possible, but there is macro for it. the numbers can go into billions to. But there is NO formula for it. Let me find the macro and give it to you. On Sep 13, 12:54 pm, "ankit varshney" <[EMAIL PROTECTED]> wrote: > Is it possible to convert any number in text. > > For Example if i ente