$$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 formula to >> get the sum of the data. I am

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 do you wanna be? It’s >> =TIME(2,DO:IT,N:OW)

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

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

;> >> hope this is what you're looking for. >> >> *Paul* >> - >> >> >> >> >> >> >> >> *“Do all the good you can,By all the means you can,In all the ways you >> can,In all the places

$$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 EI

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

medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001> > > Hi 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 w

$$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 colu

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

; can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Hilary Lomotey > *To:* excel-macros > *Sent:* Tuesday, February 10, 2015 11:30 AM > *Subject:* $$Excel-Macros$$ A

$$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 histo

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

thanks Paul, i have sent you the file On Tue, Feb 3, 2015 at 3:27 AM, Hilary Lomotey wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup rule > <https://www.boxbe.com/popup?url=https%3A%

$$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, pleas

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

> > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* >

$$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 y

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 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 & Regards, > Ga

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

thanks Boss On Wed, Oct 1, 2014 at 11:59 AM, Vaibhav Joshi 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 wrote: > >> wow, exactly what i neede

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

o > 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 wrote: > >> Solid boss execllent, its what i wanted, can you assist with the last >> piece of code to post

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

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, 2014 at 11:09 AM, Anil Gawli wrote: > Dear Hilary, > > Pl find attached as required by you > > Warm Regards, > Gawli Anil :) > > On Wed, Oct 1,

$$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 unde

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

excellent boss, well done On Tue, Sep 2, 2014 at 6:30 AM, Anil Gawli 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 wrote: > >> Hello Experts >&g

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

h ' load picture Image1.PictureSizeMode = fmPictureSizeModeStretch Image1.Picture = LoadPicture(strFile) ' remove picture from disk Kill strFile End Sub On Mon, Sep 1, 2014 at 4:19 PM, Hilary Lomotey wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This

$$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 =NO

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

On Wed, Aug 27, 2014 at 6:57 PM, Hilary Lomotey 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, i

$$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 there

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

t; > > Hey Hilary, > > check this.. > > Cheers!! > > > On Fri, Aug 8, 2014 at 8:29 PM, Hilary Lomotey wrote: > >> Hello Experts , >> >> In my attached sheet, i want to post the value in the checkbox on the >> userform if true/false to

$$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 se

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

t; change cell ref of cell T1 to output sheet..or just type "=output!A2" > > Thanks > > > On Mon, Jul 7, 2014 at 4:39 PM, Hilary Lomotey wrote: > >> thanks boss but when i criteria date the it doesnt change >> >> >> On Fri, Jul 4, 2014 at 9:37 A

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

&utm_content=001> > > Hi > > Check new macro named vabz.. > > > Cheers!! > > > On Thu, Jul 3, 2014 at 1:55 PM, Hilary Lomotey wrote: > >> thanks but this is not what am expecting, what i want is >> 1. i want to extract items in database sheet into th

$$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 t

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

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

ot;)) End If End Select End Sub On Mon, Feb 24, 2014 at 10:54 AM, Ravinder wrote: > 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:*

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

001>| > More > info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=16451535855&tc_rand=1136612410&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001> > > Pfa, if help > > > > *From:* excel-macros@googlegrou

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

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

;utm_content=001> > > Hi Hilary, > > Try updated one... > > PFA > > > > On Sat, Feb 15, 2014 at 1:17 PM, Hilary Lomotey wrote: > >> excellent chief, this is what i needed. thanks all for your assistance >> >> On 2/15/14, Naveen Kumar M N wrote:

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 wrote: > This message is eligible for Automatic Cleanup! (naveenkumarmn...@gmail.com) > > Add cleanup rule: > https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DdxJQakA

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 b

$$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 b

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] This message is eligible > for Automatic Cleanup! (anil.bha...@tatacommunications.com) Add cleanup > rule

$$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 @ https://www.fa

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

amp;utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001> > > 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

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 wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule<https://www.boxbe.com/popup?url=https%3A%

$$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 pr

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

_campaign=ANNO_CLEANUP_ADD&utm_content=001> > > Pfa, try this one.. 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

$$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 y

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

;utm_campaign=ANNO_CLEANUP_ADD&utm_content=001> > > PFA > > > > On Thu, Oct 31, 2013 at 11:50 PM, Hilary Lomotey wrote: > >> thanks Sam, can you send it in excel format, i typed indirectvba=then i >> refered to the datavalidation, but am getting

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

Evaluate("=" & strSource) > > End Function > > Regards, > Sam Mathai Chacko > > > On Thu, Oct 31, 2013 at 11:38 PM, Hilary Lomotey wrote: > >> Hello Experts, >> >> i need an assistance with an alternative way of getting the indirect &g

$$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 Exc

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

no probs i got it On Fri, Sep 20, 2013 at 2:54 PM, Hilary Lomotey wrote: > one word, > > S U P E R B > > nicely done. thanks > > can u explain this line Find("USER NAME ").Column pls thanks > > > On Fri, Sep 20, 2013 at 2:49 PM, priti verma wrote: > &

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

.Row, 1).Resize(, lngcolumn).Clear > > >'cell.Resize(, lngcolumn).ClearContents > Range("a1").CurrentRegion.Sort key1:=Range("a2"), Order1:=xlAscending, > Header:=xlYes > End If > Next cell > > End Sub > > > > On Fri, Sep 20, 2013

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

ne > > 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 > &

$$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 parti

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

185&tc_rand=1842925946&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001> > > PFA and advise is it ok.? > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomot

$$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 on

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 wrote: > Try to use Selection istead of ActiveCell > > Selection.Value = "Please assist with code" > > > Pada 12/09/2013 18:36, Hilary Lomotey menulis: > > He

$$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 =NOT(EXP(E:RT)

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

t; 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

$$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? An

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

l start new thread!! >> >> You will get response though. >> >> Thanks >> >> >> On Sat, Aug 3, 2013 at 8:05 PM, vikas tyagi >> wrote: >> >>> Hallo...experts. >>> How I can hide formulas to others in a sheet. >>> On Aug 3, 201

$$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 concise,

$$Excel-Macros$$ respuzy

http://dooncarryingcompany.com/ibeablao/zdukok.enfj -- 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, accurate thread titles. Poor thr

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

lterCopy, criteriarange:=Sheets("Equities > DB").Range("i1:K2"), _** > **copytorange:=Range("B13:G" & Sheets("Equities > DB").Range("rawdata").Rows.Count)** > **** > **Columns.AutoFit** > **Range("B10&

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

nd=1848429564&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001> > > here is the solution with vba... > > --- On *Wed, 6/19/13, Hilary Lomotey * wrote: > > > From: Hilary Lomotey > Subject: $$Excel-Macros$$ Extract Unique Val

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

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

LEANUP_ADD&utm_content=001> > > Scratch Solution attached, explore it > > Rgds, > [dp] > > On 18/06/2013 20:30, Hilary Lomotey wrote: > > re-posting my solution > > > On Tue, Jun 18, 2013 at 1:23 PM, Hilary Lomotey wrote: > >> thanks Guys, i have bee

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

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

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 wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule<https://www.boxbe.c

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

$$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 ho

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 answer

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

DD&utm_content=001> > > Place the code in Module1 > Sheet Module which contain data > Sheet Output is Paste Data > Code: > > Sub Extractdata() > Sheets("Module").Select > Range("A2:P66").Select > Selection.Copy > Sheets(&qu

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

False Selection.Delete Shift:=xlUp End With End Sub On Thu, Mar 28, 2013 at 12:11 PM, Hilary Lomotey wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule<https://w

$$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 *

te 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 lomotey wrote: >> >> Hello Gurus, >> >> kindly help on the subject above. i need the users to enter dates

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, which

$$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 Fac

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 wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (willsyssm...@gmail.com) Add cleanup > rule

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

amp;utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001> > > try the attachment see if it helps > > > > On Mon, Feb 18, 2013 at 10:17 PM, Hilary Lomotey wrote: > >> Hello Gurus, >> >> Hope i find you well. i am faced with a slight challen

Re: $$Excel-Macros$$ Problem in conditional formatting *

Hello Pls see attached HTH On Wed, Feb 13, 2013 at 12:44 PM, Kenil Gala wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (keni...@yahoo.com) Add cleanup > rule

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 wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (divake...@gmail.com) Add cleanup > rule

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 wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule<https://w

$$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 @ https://www.facebook.com/discussexcel

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

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

$$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 sheetn

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

& "!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: >> >>

$$Excel-Macros$$ Create Links to All sheet Starting from a particular sheet

Sub CreateLinksToAllSheets() Dim sh As Worksheet Dim cell As Range, i As Long, j As Long i = 1 j = 1 For Each sh In ActiveWorkbook.Worksheets If ActiveSheet.Name <> sh.Name Then Cells(j, i).Select ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _

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

.DisplayAlerts = False > Worksheets(sh).Delete > Application.DisplayAlerts = True > End Sub > > > On Tue, Jan 29, 2013 at 6:15 PM, Hilary Lomotey wrote: > >> sub detele() >> >> Application.DisplayAlerts = False >> Worksheets("Sheet1").delete &g

$$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$$ 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 wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule<https://www.boxbe.com/popup?url=https%3A%

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

Hello Experts, In the file attached, i have a master list with names and codes(master sheet), and then another list (list sheet). The codes in the master sheet does not match with that of the other list, so i used the normal index and match to retrieve the different values, the issue is that i wan

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

CMSxX5X6gjKR9LK5sG%252BHsQXoUlY%253D&tc=13408745051_930974625>| > More > info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13408745051_930974625> > > try this > > http://spreadsheetpage.com/index.php/tip/a_quick_and_dirty_slideshow_macro/ > > >

$$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 @ https://

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

YMohRB7csGMV8Ifxes%253D&tc=13407173677_1151659197>| > More > info<http://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

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 wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (amartak...@gmail.com) Add cleanup > rule

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

7f2g%252FBZB%252Bg%252FspNnhAw7Y%253D&tc=13359168265_801267276>| > More > info<http://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

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

oZh1eSMGEL%252BVoOTKUA%253D%253D%26key%3DNoagolYOOLl8YTC1QO4dXX3G4jbggj5FkucZ6W0Wjww%253D&tc=13358954160_1709734263>| > More > info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13358954160_1709734263> > > How to get back in hyper liked sheet after clicking on hyper link..need > cod

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

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

ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", > SubAddress:= _ > "'" & sh.Name & "'" & "!A1", TextToDisplay:=sh.Name > if activeCell.row mod 30 =0 then > ActiveCell.Offset(1, 1).Select > else >

$$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 every

  1   2   3   >