$$Excel-Macros$$ VBA Copy and Paste to Corresponding Name

Hello Gurus, kindly need assistance with vba solution in the sheet attached, i want to copy the figures from column M with heading Current NAV for Valuation Date 31-may-16 to column E with heading Last Valuation for Valuation date 30-jun-16 and the figures must correspond to the particular name

Re: $$Excel-Macros$$ Using date criteria to get the Sum

Use Pivot Tables illustration attached On Fri, Oct 21, 2016 at 10:37 PM, Deepu Dubey wrote: > Can You share data ?? > > On Thu, Oct 13, 2016 at 10:52 PM, Maju wrote: > >> >> hello All, >> >> Please I need some help with writing a macro or using excel

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

See attached, HTH. Cheers On Mon, Oct 24, 2016 at 5:35 AM, amar takale wrote: > Dear Friends > any one help me on this issue > > On Fri, Oct 21, 2016 at 12:09 PM, amar takale > wrote: > >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Fwd: $$Excel-Macros$$ Copy and Paste Data to another workbook (closed workbook)

> > > > Hello Guys, > > kindly assist with VBA code to copy data from workbook A (PTRS) and paste > the data in workbook B-Daily Trades (With workbook B possible closed). > > from the attached sheet, i want to copy data from PTRS workbook in PTRS > worksheet and paste it in Daily Trades workbook

$$Excel-Macros$$ Copy Dynamically From Column and Pate

Hello Bosses, i have this code am using to copy Dates from column of sheet1 and transpose paste it in sheet2. the issue is to dynamically find the column header to copy the data to eg copy from E1 to J1, assuming i enter data in column K1 i need an assistance with code to dynaically coopy from

Re: $$Excel-Macros$$ Copy Dynamically From Column and Pate

can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Hilary Lomotey resp...@gmail.com *To:* excel-macros EXCEL-MACROS@googlegroups.com *Sent:* Thursday, April 30

Re: $$Excel-Macros$$ Re: Send Email to Persons in a column Range

Hilary Lomotey, Please find the attached macro file. Kindly let me know if you any queries. Regards, MV On Tuesday, April 21, 2015 at 9:26:43 PM UTC+5:30, hilary lomotey wrote: Hello Experts, i have attached an excel sheet which copies a portion of an excel worksheet and attaches

$$Excel-Macros$$ Send Email to Persons in a column Range

Hello Experts, i have attached an excel sheet which copies a portion of an excel worksheet and attaches it to an outlook mail which is perfect however, i want an additional code o modify this existing code to send email to a people in a range, eg in the attached sheet send email to address in

Re: $$Excel-Macros$$ Add No of Years Specified

* - *From:* Hilary Lomotey resp...@gmail.com *To:* excel-macros EXCEL-MACROS@googlegroups.com *Sent:* Tuesday, February 10, 2015 11:30 AM *Subject:* $$Excel-Macros$$ Add No of Years Specified Hello Experts, i am developing a form and i need assistance with a code, i can do

$$Excel-Macros$$ Add No of Years Specified

Hello Experts, i am developing a form and i need assistance with a code, i can do it with a formula but i dont like the final results because of the final output i want. Basically in sheet2, when i click on setup and i choose a start year for instance 2006 and specify the number of years for

$$Excel-Macros$$ Reset Macro After Excel Start up

Hello Experts, i have a program that i have designed in excel. the issue is that when i open the program i cant do anything unless i go to VBA and press on the reset button before i can proceed. when means a procedure is running but looking thru the codes i dont see any proceedure that runs,

Re: $$Excel-Macros$$ Run Time Error after PC becomes idle

,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Hilary Lomotey resp...@gmail.com *To:* excel-macros EXCEL-MACROS@googlegroups.com *Sent:* Saturday, January 24, 2015 10:16 AM *Subject:* $$Excel-Macros$$ Run Time Error after PC

$$Excel-Macros$$ Run Time Error after PC becomes idle

Hello Experts, please kindly advice, i have written a programme, but anytime i leave the pc to be idle for like say 5 minutes if i open a userform, i get a runtime error 1004 and error 75. please what is happening. kindly advice. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganeshg...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks

$$Excel-Macros$$ Move Selected Names to Listbox

Hello experts, kindly assist with code in the form attached. what i need to do is that when i open the userform, i want to select names on the left listbox and click on the arrow button () to populate it in the listbox on the right so i will be able to post it in the sheet (Home) column G under

Re: $$Excel-Macros$$ Move Selected Names to Listbox

PM, Hilary Lomotey resp...@gmail.com wrote: Hello experts, kindly assist with code in the form attached. what i need to do is that when i open the userform, i want to select names on the left listbox and click on the arrow button () to populate it in the listbox on the right so i

Re: $$Excel-Macros$$ Move Selected Names to Listbox

to excel... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 3:45 PM, Hilary Lomotey resp...@gmail.com wrote: Solid boss execllent, its what i wanted, can you assist with the last piece of code to post it to column G? On Wed, Oct 1

Re: $$Excel-Macros$$ Move Selected Names to Listbox

thanks Boss On Wed, Oct 1, 2014 at 11:59 AM, Vaibhav Joshi v...@vabs.in wrote: chk this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 4:21 PM, Hilary Lomotey resp...@gmail.com wrote: wow, exactly what i needed, yes i wish

Re: $$Excel-Macros$$ load graph in userform

excellent boss, well done On Tue, Sep 2, 2014 at 6:30 AM, Anil Gawli gawlianil8...@gmail.com wrote: ​Dear Hilary, Pl find below attached file for you ref. Warm Regards, Gawli Anil. On Mon, Sep 1, 2014 at 9:16 PM, Hilary Lomotey resp...@gmail.com wrote: Hello Experts Just found

$$Excel-Macros$$ load graph in userform

Hello Experts, i want to load graphs in the userform, i got some codes but its not working, can some please assist with the file attached, the objective is to load the graph in the graph sheet in the userform on the dashboard by selecting the required option. thanks -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ load graph in userform

= fmPictureSizeModeStretch Image1.Picture = LoadPicture(strFile) ' remove picture from disk Kill strFile End Sub On Mon, Sep 1, 2014 at 4:19 PM, Hilary Lomotey resp...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (resp...@gmail.com

$$Excel-Macros$$ sharing of excel workbook

Hello Experts, i have an excel templates where i want users to be able to access it almost at the smae time if the so wish so i activated the share workbook option on the review menu, however, its giving an error because the template contains macro and it says macros cannot be shared, pls is

Re: $$Excel-Macros$$ sharing of excel workbook

PM, Hilary Lomotey resp...@gmail.com wrote: Hello Experts, i have an excel templates where i want users to be able to access it almost at the smae time if the so wish so i activated the share workbook option on the review menu, however, its giving an error because the template contains macro

$$Excel-Macros$$ Find the Selected Name and Post Details to

Hello Experts , In my attached sheet, i want to post the value in the checkbox on the userform if true/false to the selected name from the drop down list however the technique and using always post to the line after the last data, i need assistance to amend my code to post the data to the name

Re: $$Excel-Macros$$ Find the Selected Name and Post Details to

=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 | More info http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=18177405575tc_rand=666544381utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 Hey Hilary, check this.. Cheers!! On Fri, Aug 8, 2014 at 8:29 PM, Hilary

Re: $$Excel-Macros$$ Extract Unique Data

, 2014 at 4:39 PM, Hilary Lomotey resp...@gmail.com wrote: thanks boss but when i criteria date the it doesnt change On Fri, Jul 4, 2014 at 9:37 AM, Vaibhav Joshi v...@vabs.in wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (v...@vabs.in) Add

Re: $$Excel-Macros$$ Extract Unique Data

, 2014 at 1:55 PM, Hilary Lomotey resp...@gmail.com wrote: thanks but this is not what am expecting, what i want is 1. i want to extract items in database sheet into the output sheet based on the criteria sheet cell a3 in output sheet-- i have written the advanced filter code

$$Excel-Macros$$ Extract Unique Data

Hello Experts, Hope i i find you well. i am trying to extract unique Data from the information in the output data in the file attached after i have extracted data based on criteria from the database sheet. i have noticed that because i extract data from the database sheet and from there i perform

$$Excel-Macros$$ Problem with Advanced Filter

i have written a macro to extract couple of data from another sheet with advanced filter 'extracting equity statement Sheet24.Range(EqtyPDB).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheet19.Range( _ CW1:CX2), CopyToRange:=Sheet19.Range(CN1:CU1), Unique:=False immediately after this

Re: $$Excel-Macros$$ VBA Code to access pictures from drive C

://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=16451535855tc_rand=1136612410utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 Pfa, if help *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey *Sent:* Sunday

Re: $$Excel-Macros$$ VBA Code to access pictures from drive C

, Ravinder ravindervbacli...@gmail.comwrote: Its working perfectly, I am not getting whats the problem. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey *Sent:* Monday, February 24, 2014 3:59 PM *To:* excel-macros *Cc:* Soum

Re: $$Excel-Macros$$ VBA Code to access pictures from drive C

i have resolved it myself. thanks for your SUPER assistance. thanks On Mon, Feb 24, 2014 at 11:29 AM, Hilary Lomotey resp...@gmail.com wrote: Thanks Boss i edited the picture and its working nicely now, so grateful to you. i have made three images ie image1 ,image2 and image3 so that if you

$$Excel-Macros$$ VBA Code to access pictures from drive C

Hello Experts, embedding pictures in excel sheet can take a lot of size so i need an assistance with a code to access pictures based on a drop down selection. ie assuming i have a combo box with three names a, b and c, if i select a i want to link it to a particular picture on the c drive.

Re: $$Excel-Macros$$ loop to extract balances

, 2014 at 1:17 PM, Hilary Lomotey resp...@gmail.com wrote: excellent chief, this is what i needed. thanks all for your assistance On 2/15/14, Naveen Kumar M N naveenkumarmn...@gmail.com wrote: This message is eligible for Automatic Cleanup! ( naveenkumarmn...@gmail.com) Add cleanup rule

$$Excel-Macros$$ loop to extract balances

Hello Experts, i need a little assistance to extract balances from the sheet attached. i have extracted a unique list of names from the transactions. i want a in column J net balances from transactions. for instance the first person will have a balance of 3007.23, the next two will have a zero

Re: $$Excel-Macros$$ loop to extract balances

thanks Boss for the assistance, Sorry i may not have explained my expected results well. i want the results to be in column J . And it should work like a balance on each unique individuals account as if they were not dependent on the other as illustrated in column l to Q then the results of the

Re: $$Excel-Macros$$ loop to extract balances

excellent chief, this is what i needed. thanks all for your assistance On 2/15/14, Naveen Kumar M N naveenkumarmn...@gmail.com wrote: This message is eligible for Automatic Cleanup! (naveenkumarmn...@gmail.com) Add cleanup rule:

Re: $$Excel-Macros$$ Negative Numbers in Excel

Pls send a file On Wed, Feb 5, 2014 at 10:01 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (anil.bha...@tatacommunications.com) Add cleanup

$$Excel-Macros$$ Post from Userform Converts Numbers to Text

Hello Experts, can someone pls advice how i can avoid any postings i make from a userform converting to text instead of a number. thanks -- 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 @

Re: $$Excel-Macros$$ loop to copy items one by one

Pfa, I think you r looking for this…. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey *Sent:* Thursday, November 07, 2013 12:39 AM *To:* excel-macros *Subject:* $$Excel-Macros$$ loop to copy items one by one Hello Experts

Re: $$Excel-Macros$$ Advanced Filter Not Working Properly

.. if help you *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey *Sent:* Tuesday, November 05, 2013 10:48 PM *To:* excel-macros *Subject:* $$Excel-Macros$$ Advanced Filter Not Working Properly Hello Experts, i need your expert

$$Excel-Macros$$ loop to copy items one by one

Hello Experts, i need assistance with a loop or any macro to help run a report. ie in the sheet attached i have a list of names, if i choose a name from the list and run the adv filter it gives me the result i want and then i will run the report and get it exported to the database. i want this

Re: $$Excel-Macros$$ loop to copy items one by one

i have been able to do it thanks On Wed, Nov 6, 2013 at 7:08 PM, Hilary Lomotey resp...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F

$$Excel-Macros$$ Advanced Filter Not Working Properly

Hello Experts, i need your expert advice, have recorded a macro using advanced filter, when you debug and run it it works flawlessly, however when i can it in a user form, it doesnt work properly, any ideas how to salvage this? .thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

$$Excel-Macros$$ Alternative to indirect Function in VBA

Hello Experts, i need an assistance with an alternative way of getting the indirect function of excel in VBA. I have attached a sample for your perusal. Basically i want to be able to do what i have done in the attached with VBA. Pls assist. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

) INDIRECTVBA = Evaluate(= strSource) End Function Regards, Sam Mathai Chacko On Thu, Oct 31, 2013 at 11:38 PM, Hilary Lomotey resp...@gmail.comwrote: Hello Experts, i need an assistance with an alternative way of getting the indirect function of excel in VBA. I have attached a sample for your

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

, 2013 at 11:50 PM, Hilary Lomotey resp...@gmail.comwrote: thanks Sam, can you send it in excel format, i typed indirectvba=then i refered to the datavalidation, but am getting an error. kind;y send me the file. thanks On Thu, Oct 31, 2013 at 6:15 PM, Sam Mathai Chacko samde...@gmail.comwrote

$$Excel-Macros$$ Clear row contents based on criteria

Hello Champs, i have written the macro below to clear the row contents if a certain criteria is met but am getting a type match error, pls assist with proper code. what i want is in col L if there is dont roll over i want the information on that row to be cleared ie only from A to Q of that

Re: $$Excel-Macros$$ Clear row contents based on criteria

, Replace these line If Range(l2:l r).Value = Rolled-Over Then Range(A cell :Q cell).ClearContents with If cell.Value = Rolled-Over Then cell.EntireRow.ClearContents On Fri, Sep 20, 2013 at 7:20 AM, Hilary Lomotey resp...@gmail.com wrote: Hello Champs, i have written

Re: $$Excel-Macros$$ Clear row contents based on criteria

(a1).CurrentRegion.Sort key1:=Range(a2), Order1:=xlAscending, Header:=xlYes End If Next cell End Sub On Fri, Sep 20, 2013 at 7:41 AM, Hilary Lomotey resp...@gmail.com wrote: thanks priti for the response, the first line of code is ok but i dont want to delete entire because i may

$$Excel-Macros$$ Populate Values over a range

Hello Experts in the attached i have a marco that puts in values over an active cell. However if i select a range of either non-contiguous range or contiguous range i cant get it to populate over the selected range. pls can anyone assist with code. thanks -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Populate Values over a range

Yes, thanks thats exactly what i needed. thanks so much On Thu, Sep 12, 2013 at 12:42 PM, De Premor d...@premor.net wrote: Try to use Selection istead of ActiveCell Selection.Value = Please assist with code Pada 12/09/2013 18:36, Hilary Lomotey menulis: Hello Experts

$$Excel-Macros$$ Update Database From Another Sheet

Hello Again, i want to Update records in the database from another sheet. i have two sheets main( which is the database) and Update which where i want to do an update and send the updated records to the database. In the Update sheet, column L ,when a user populates a selected range by clicking

Re: $$Excel-Macros$$ Re-arrange Imported List from Txt file

(i, 1).Value = Email: Then Range(i j).Value = Cells(i, 2).Value ElseIf Cells(i, 1).Value = Business: Or Cells(i, 1).Value = Number: Then Range(h j).Value = Cells(i, 2).Value End If Next i End Sub On Thu, Aug 15, 2013 at 7:30 PM, Hilary Lomotey

$$Excel-Macros$$ Screen Updating

Hello Experts, i have a sheet am working in, when i press enter in the sheet, the screen sort of updates and flickers, how do i stop this. it is not VBA that i have to place application.screenupdating =false. how do i stop the anomaly. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

. How I can hide formulas to others in a sheet. On Aug 3, 2013 2:24 PM, resp...@gmail.com wrote: Hi bosses Any assistance with this? Cheers Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Hilary Lomotey resp...@gmail.com *Sender: * excel-macros

$$Excel-Macros$$ index and match in VBA

Hello VBA You solution was perfect. thanks for the help, am really grateful. thanks -- 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

Re: $$Excel-Macros$$ Extract Data Based on Criteria

)** **** **Columns.AutoFit** **Range(B10).Select** **End Sub** * Sample Attached Rgds, [dp] Pada 15/07/2013 20:11, Hilary Lomotey menulis: Hello Experts, i have tried to use the code in the attached file to extract data onto another sheet but getting an error. can someone

Re: $$Excel-Macros$$ Extract Unique Values with VBA

=ANNO_CLEANUP_ADDutm_content=001 here is the solution with vba... --- On *Wed, 6/19/13, Hilary Lomotey resp...@gmail.com* wrote: From: Hilary Lomotey resp...@gmail.com Subject: $$Excel-Macros$$ Extract Unique Values with VBA To: excel-macros EXCEL-MACROS@googlegroups.com Date

$$Excel-Macros$$ Extract Unique Values with VBA

Hello Experts I have attached a file where i need to extract unique values based on a criteria with VBA. I have demonstrated it with excel formula. i need assistance with a vba solution. kindly assist with code. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Want to perfect my VBA

Hello Experts, i am trying to perfect my VBA but i got stuck and need help. i have demonstrated what i want to do with excel formula, but i wish to do that using VBA. What i want to achieve is if the equity i select in the main sheet falls under say banking finance category i get the format for

Re: $$Excel-Macros$$ Want to perfect my VBA

thanks Guys, i have been able to write the code for this. On Tue, Jun 18, 2013 at 12:23 PM, Hilary Lomotey resp...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup

Re: $$Excel-Macros$$ Want to perfect my VBA

re-posting my solution On Tue, Jun 18, 2013 at 1:23 PM, Hilary Lomotey resp...@gmail.com wrote: thanks Guys, i have been able to write the code for this. On Tue, Jun 18, 2013 at 12:23 PM, Hilary Lomotey resp...@gmail.comwrote: [image: Boxbe] https://www.boxbe.com/overview This message

Re: $$Excel-Macros$$ Want to perfect my VBA

] On 18/06/2013 20:30, Hilary Lomotey wrote: re-posting my solution On Tue, Jun 18, 2013 at 1:23 PM, Hilary Lomotey resp...@gmail.com wrote: thanks Guys, i have been able to write the code for this. On Tue, Jun 18, 2013 at 12:23 PM, Hilary Lomotey resp...@gmail.comwrote: [image

$$Excel-Macros$$ How to convert excel file to an executable file

[image: Inline image 1] Hello Experts, Been a while, i recently came across this site http://www.hoadley.net/options/options.htm?src=OSET and i downloaded an executable file just like the picture above, but the executable file after downloading turns to an excel file. can anyone please share

Re: $$Excel-Macros$$ Future Growth Calculation

=value for current year * (1+assumed rate of growth) assumed rate of growth could be CAGR assume your period spans from 2005 to 2011 the n it will be the value for 2011 divided by the value of 2005 all raised to the power 1/number of periods b/n 2011 and 2005 then you subtract the resultant

Re: $$Excel-Macros$$ Vba Code to extract Data from one sheet toanother * *

contain data Sheet Output is Paste Data Code: Sub Extractdata() Sheets(Module).Select Range(A2:P66).Select Selection.Copy Sheets(Output).Select Range(A2).Select ActiveSheet.Paste Range(A1).Select End Sub 2013/3/28 Hilary Lomotey resp...@gmail.com

Re: $$Excel-Macros$$ Vba Code to extract Data from one sheet to another *

On Thu, Mar 28, 2013 at 12:11 PM, Hilary Lomotey resp...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken

$$Excel-Macros$$ Alternative formula

Hello Experts, i am working with a lot of data and am using this formula +IFERROR(INDEX(Sheet1!$B$1:$B$10061,SMALL(IF(Sheet1!$B$1:$B$10061=Sheet1!$H$1,ROW(Sheet1!$B$1:$B$10061)-ROW(Sheet1!$B$1)+1,),ROW(A1))),) to retrieve items in list b1:b1 that corresponds to item in h1 . i have however

Re: $$Excel-Macros$$ Re: Data Validation to force users to enter aparticular date format *

Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = $B$3 Then MsgBox Please Enter date In dd-mmm-yy Format End If End Sub Just Paste the following Code and modify the same according to your Requirment. Regards Prince On Tuesday, March 12, 2013 9:27:37 PM UTC+5:30, hilary

$$Excel-Macros$$ Data Validation to force users to enter a particular date format

Hello Gurus, kindly help on the subject above. i need the users to enter dates in the format dd-mmm-yy, i tired text(a1,dd-mmm-yy) in DV ,all custom but its not working. thanks -- 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

Re: $$Excel-Macros$$ RANK formula *

Hi Chief i am not sure i fully understand your requirements, if you could explain better and show your expected answers FULLY in a new column at least that might give some perspective or trend for us to follow. for instance if you say Formula should eliminate who are ranking from 1 to 10,

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password *

Don't post questions regarding breaking or bypassing any security measure. On Tue, Feb 19, 2013 at 6:00 AM, Will Smith willsyssm...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (willsyssm...@gmail.com) Add cleanup

Re: $$Excel-Macros$$ Dynamic Data Validation Issue *

try the attachment see if it helps On Mon, Feb 18, 2013 at 10:17 PM, Hilary Lomotey resp...@gmail.comwrote: Hello Gurus, Hope i find you well. i am faced with a slight challenge and i kindly ask for ideas on this. The issue is in sheet one is my cashbook. under the main ledger i have

Re: $$Excel-Macros$$ VBA for Hide Unhide specific bunch of sheets *

change the sheet name as per ur requirement Sub Hide() ' 'Hide all worksheets except the list below For i = 1 To ActiveWorkbook.Sheets.Count If Sheets(i).Name = Dashboard1 Or Sheets(i).Name = Dashboard2 Or Sheets(i).Name = Dashboard3 Or Sheets(i).Name = Dashboard4 Or Sheets(i).Name =

Re: $$Excel-Macros$$ user could select either or and the formulawould change *

Pls find attached solution to your query HTH On Tue, Feb 5, 2013 at 9:20 AM, Divaker Pandey divake...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (divake...@gmail.com) Add cleanup

Fwd: Re: Fwd: Re: $$Excel-Macros$$ Macro to create Template and apply protection

-- From: Hilary Lomotey resp...@gmail.com Date: Feb 1, 2013 8:27 AM Subject: Re: Fwd: Re: $$Excel-Macros$$ Macro to create Template and apply protection To: hilar...@newworldgh.com hilar...@newworldgh.com Thanks boss its working like how I perceived it but only challenge is I cant enter anything cos

$$Excel-Macros$$ Formula to find items between two dates

Hello Experts i have some general data in sheet one, i want to enter a start date and an end date in sheet two so that items within these dates should pop up, my formulas are not working , kindly assist. thanks -- Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Formula to find items between two dates *

Thanks Experts, i have aadjusted my formula, its working now. thanks On Fri, Feb 1, 2013 at 11:36 AM, Hilary Lomotey resp...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rulehttps

$$Excel-Macros$$ Macro to create Template and apply protection

Hello Experts, in the attached workbook, i have two sheets ie template and setup. On the setup sheet, when you enter a text in column B, and click create template, the macro for that button will always pick the last text in column B and create a template using the last text entered as the

$$Excel-Macros$$ Macro to delete a specific sheet by specifying

sub detele() Application.DisplayAlerts = False Worksheets(Sheet1).delete Application.DisplayAlerts = True end sub Hello Experts, the code above deletes sheets1 but this is a static macro , i want to be able to delete a sheet by type the sheetname and then have it deleted, kindly assist with

Re: $$Excel-Macros$$ Macro to delete a specific sheet by specifying *

= True End Sub On Tue, Jan 29, 2013 at 6:15 PM, Hilary Lomotey resp...@gmail.com wrote: sub detele() Application.DisplayAlerts = False Worksheets(Sheet1).delete Application.DisplayAlerts = True end sub Hello Experts, the code above deletes sheets1 but this is a static macro , i want

Re: $$Excel-Macros$$ Re: Create Links to All sheet Starting from aparticular sheet *

ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:=, SubAddress:= _ ' .Sheets(intCtr).Name ' !A1, TextToDisplay:=Sheets(intCtr).Name i = i + 1 Next End With End Sub Regards Prince On Tuesday, January 29, 2013 6:44:16 PM UTC+5:30, hilary lomotey wrote

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List *

NO WORRIES, I SOLVED IT, THANKS On Thu, Jan 24, 2013 at 12:00 PM, Hilary Lomotey resp...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F

Re: $$Excel-Macros$$ Re: VBA Solution Requried * *

%252FsU1j3haXMo1e1FKtPJUwvkylYMohRB7csGMV8Ifxes%253Dtc=13407173677_1151659197| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13407173677_1151659197 Dear Hilary Lomotey, This solution is beyond my expectation. Great work thanks a billionHilary.Sir but we use index formula this 12 company only

$$Excel-Macros$$ VBA Code -Slide Show

Hello Experts, i need assistance with a vba code to show pictures in slide show mode in excel. any help will be appreciated. ie if i insert a number of pictures in excel, i want a code that will show the pictures in slide show mode. thanks -- Join official Facebook page of this forum @

Re: $$Excel-Macros$$ VBA Code -Slide Show *

%252FsCmHlPwdoVbFCMSxX5X6gjKR9LK5sG%252BHsQXoUlY%253Dtc=13408745051_930974625| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13408745051_930974625 try this http://spreadsheetpage.com/index.php/tip/a_quick_and_dirty_slideshow_macro/ On Wed, Jan 23, 2013 at 7:54 PM, Hilary Lomotey resp

Re: $$Excel-Macros$$ VBA Solution Requried *

formulas can also work for this, provide a sample data On Mon, Jan 21, 2013 at 1:30 PM, amar takale amartak...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (amartak...@gmail.com) Add cleanup

$$Excel-Macros$$ HyperLinks to Sheets

Hello Experts, The code below creates hyperlinks in a worksheets, what i require is a little modification to this. assuming i have about 100 sheets in a work book, this code will line up all the hyperlinks of the worksheet name in a single row (ie 100 rows), what i need is that at the end of

Re: $$Excel-Macros$$ HyperLinks to Sheets *

' !A1, TextToDisplay:=sh.Name if activeCell.row mod 30 =0 then ActiveCell.Offset(1, 1).Select else ActiveCell.Offset(1, 0).Select endif End If Next sh End Sub On Wed, Jan 16, 2013 at 5:33 AM, Hilary Lomotey resp...@gmail.com wrote: Sub

Re: $$Excel-Macros$$ HyperLinks to Sheets * *

*BINGO- IT WORKING TO PERFECTION,* * * *very grateful Ashish and Rajan * * * * * * * On Wed, Jan 16, 2013 at 3:18 PM, ashish koul koul.ash...@gmail.com wrote: Sub CreateLinksToAllSheets() Dim sh As Worksheet Dim cell As Range, i As Long, j As Long i = 1 j = 1 For Each sh In

Re: $$Excel-Macros$$ HyperLinks to Sheets * * *

%3DNoagolYOOLl8YTC1QO4dXX3G4jbggj5FkucZ6W0Wjww%253Dtc=13358954160_1709734263| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13358954160_1709734263 How to get back in hyper liked sheet after clicking on hyper link..need code..plz. On Wed, Jan 16, 2013 at 9:00 PM, Hilary Lomotey resp...@gmail.com

Re: $$Excel-Macros$$ HyperLinks to Sheets * * * *

%252Bg%252FspNnhAw7Y%253Dtc=13359168265_801267276| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13359168265_801267276 Dear frnd, code not working, giving error.. Rgds Pankaj On Wed, Jan 16, 2013 at 9:08 PM, Hilary Lomotey resp...@gmail.com wrote: Sub ReturnToD3

Re: $$Excel-Macros$$ Re: I am suspecting a Circular Reference *

look fine to me. On Friday, January 11, 2013 9:37:33 PM UTC+5:30, hilary lomotey wrote: Hello Experts, i have rebuilt my fixed income schedule but facing a slight challenge, i suspect its a circular reference problem but kindly see attached and help me out. Problem description i want

$$Excel-Macros$$ Finding the relative position of an item in a list

Hi Experts, In the attached, i have a list of items, some are repetitive in the list, if i want to find the relative position of each item what formula can be helpful, the normal match will for instance if an item appears twice in different positions will only give me the position of the first

Re: $$Excel-Macros$$ Finding the relative position of an item in a list *

Thanks Viper This is not what i require, i will try and explain again sorry if i didnt explain properly, your formula only produces the max ordinal position, assuming Moda is in the first , fifth and tenth row, and in the data validation drop down i select say Moda in the first row, i expect the

Re: $$Excel-Macros$$ Re: Finding the relative position of an item in a list

On Thursday, January 10, 2013 4:41:12 PM UTC+5:30, hilary lomotey wrote: Hi Experts, In the attached, i have a list of items, some are repetitive in the list, if i want to find the relative position of each item what formula can be helpful, the normal match will for instance if an item appears twice

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

((MAX((A1:A8=D1)*ROW(A1:A8* On 10-01-2013 4:41 PM, Hilary Lomotey wrote: Hi Experts, In the attached, i have a list of items, some are repetitive in the list, if i want to find the relative position of each item what formula can be helpful, the normal match will for instance if an item

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Thu, Jan 10, 2013 at 5:28 PM, Hilary Lomotey resp...@gmail.com wrote: Very Grateful

Re: $$Excel-Macros$$ Finding the relative position of an item in a list *

, 2013 at 5:39 PM, Hilary Lomotey resp...@gmail.com wrote: Thanks Noorain, for what am trying to do, i need a formula instead. But that is the exact principle of what i was explaining. thanks On Thu, Jan 10, 2013 at 12:03 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Hilary

  1   2   3   >