direction

Hi All, Could anyone please point me in the right direction as to how to change a workbook I have into a mobile app. The workbook has 14 worksheets within it and loads of vba. I have it on OneDrive at the moment as their are numerous users all at the same time. I wish to make this more user...

Hi i'm having an issue working out how to go about recording changes to a value that's dynamic (Changes from month to month) so i can make a graph. Bit hard to explain so i'll post a screenshot. If someone could point me in the right direction happy to learn If any additional info required...

Hi I am trying to work out the above error on the attached workbook and have spent hours but to no avail. ContentsSheet.Protect DrawingObjects:=True, Contents:=False, Scenarios:=True Could someone please point me in the right direction as I am no expert in VBA and I have been given this task...

What I'm trying to accomplish is to consolidate the rows and sums along with getting rid of the duplicates on the same worksheet by using a Macro..Any Help in the right direction would be very much appreciated.. Johnzea...

Hi All I hope someone can help I have a column with lots of data in it (I have attached a small portion in the workbook) I need to rank every six entries going down the column. I have googled and found the + countif option to break the ties but I cant seem to get it to work? I hope someone...

Hi all the title does not describe well what I am struggling with. I have to return a value from a different sheet i.e =sheet1 A1 into sheet 2 A1. The 2nd row of sheet 2 (A2) needs to duplicate what was in sheet 2 A1. The 3rd row of sheet 2 (A3) needs to return the value in sheet 1 A2. The...

Hi there, I have a range (EF60:IV60) and I need to return the last value which is not blank or 0 I'm having a brain freeze moment... I've tried: =IFERROR(0,LOOKUP(2,1/(EF60:IV60<>""),EF60:IV60)) but it's not having it.... If you can point me in the right direction, I'd be most grateful Thanks

Hi All, I wonder if someone could point me in the right direction. I have an excel table, named Customers. In the table, there are two columns, Customer and PO, I would like reference that table within a VBA Index Function. I have looked everywhere for an answer but I am not geting very...

Good Evening! I am struggling with a formula, hoping someone can point me in the right direction. In a cell I have a text string that says "#15 of 214 H.." I need to extract the two numbers into their own cells. In this example 15 and 214 respectively. However, the numbers could be as...

When it comes to rounding I use excel like everyone else. I’ve recently come across an engineering specification that rounds up or down to an even decimal place if the second decimal ends in a 5. i.e 2.45 to 2.4, 2.75 to 2.8 and normal rounding occurs otherwise 2.44 to 2.4, 2.74 to 2.7 and 2.53...

Using Windows 10 and Access 2010 I would like to have the 'Surname' field, in table / datasheet, to be in Bold but I can't find how to do this. I have the field set as 'text' Can anyone point me in the right direction, please? Any help and/or advice would be very much welcomed. Many thanks

Hello all, and thank you for everyone's time in providing this valuable resource. I spend a lot of time manually sorting data that is pulled from a database and hope to be able to streamline the process, but so far I have struck out in using different combinations of VLOOKUP AND Match/Index. I'm...

Hello, I have the following formula which I can't get to work. Have tried and tried and tried again but to no avail. All of the cells come back as Y, indicating it is FALSE which is not the case. Is anybody able to help point me in the right direction? Ta much...

In my code I have six different subroutines. I want to say run #2 , then run #4 , then run #4 , then run#6 etc. 2,4,4,6,1,2,2,3,4,4,5,5,6,6,1,1,2,2 is the sequence What code should I use? Sub Direction_6() Dim Direction As String Dim DirectionName As String Direction = 2 ' How to feed...

Hello i was wondering if i could get some help with a count if/vlookup forumula. Need to look at each direction, first looking at "north" direction in the month of "JAN" Then need to look at the "NUMBERS" sheet and see how many times does that number matches the one that is in the DATA Column...

Hi, Need a bit of help if possible, I have multiple .xls documents in a folder (approx 200) all identical format i want to be able to sum the value from cell A1 in all these documents, could anyone point me in the easiest direction? Many thanks DM

These are the macros I have to turn off the cell direction when using the Return Key on Sheet1 only. When I open the workbook, regardless if Sheet1 is activated or not, the cell direction is turned off. If I go to sheet1 first and then go to a different sheet, this is when it is deactivated and...

Hello All, I need a good forum for MS Project.. Can someone lead me in the right direction? Thanks

Good Day!! I am a little lost, and hoping someone can at least point me in the right direction. Every month, I need to review 20 hotels on TripAdvisor.com and see what their rankings are. One example here for Hilton Cleveland is #3 of 38 (as of right now, may change at some point). Here is...

I am looking for a way to execute a macro when an object with a specific name is updated, moved or changed. Is this possible, and if it is, could someone please point me in the correct direction or give me a sample code? Many thanks! Frab~