simple

Hi In this macro line, Application.Goto Reference:="rangename" I need the "rangename" to be given by the contents of another cell eg A1, because it will change I'm sure it's simple - but not to me. Thanks for your help. M

Hello everyone, I have a very simple transpose problem that I can't quite figure out. The data I have is currently in this format: <tbody> Name Response Respondent 1 X Y Z Respondent 2 A B C D </tbody> I want to transpose it so it is in the following format...

i can use =now() but that also gives me the date in front....is there a simple way to only have the time?

Hi, I am a bit stick trying to replicate the work of my former colleague at work. Some time ago he create a Power BI visualisation of annual costs with a lot of simple filtering options (departments, sub-departments,...). Recreating that in Power BI is no problem, but he somehow made the output...

Apparently, the technology for sending emails from Excel vba is in a state of flux, particularly, when you consider that the syntax seems to be different for each version of Excel or each version of your operating system. Does anyone know of a simple approach for Excel 360, 64 bit and windows...

Hi. I've googled a lot, tried alot, but cant get it to work, so i'll ask here. Im looking for a simple way to make a countdown timer in a label. I want it so when the userform loads, a coundown timer from 5 min shows in a label, counting down, in min and sec. Does anyone know how to do this?

I'm new to Macros and working with a training tutorial, and there's a really simple problem, I just cannot figure out. I feel so stupid asking but i need help. Here's my code. So... I copied and pasted the line currently ' - which works fine But when I type the line, I get an "Unable to get...

I've created a spreadsheet for my kids football tournaments and I'm managing who has paid and how much they owe. There are four tournaments in cells C2, D2, E2 and F2 with a total payment in cell G2. Names start from row 3. Each tournament costs £5 to enter and I want to put a simple Y in cells...

Hi I am trying to put together a simple cash book to run from month to month. Does anyone know what formulas I will need to put into columns J & K to calculate row 3 to 9. I have gotten so far but I am having trouble with rows 8 & 9. Thank you. <colgroup><col width="24" style="width: 18pt...

I have a simple DAX measure in my Excel 2016 data model: [Who Am I Domain]:=USERNAME() When I enter this as a measure in the data model window and use autofill the end parentheses appear. However, after the measure calculates the parentheses disappear (which they don't do for...

Given that I have the mileage between motorway services, I want to be able to enter the names of any two of the services to calculate the distance between them. It must be simple but it's got me baffled.

Hi all I have zero working knowledge of access. I am considering purchasing an access database for CRM (customer relationship management) purposes. The only drawback is that this would sit on my desktop and for obvious reasons I am hesitant. Is there a service or somewhat simple way for me to...

I have a drop down list in columns B7, B8 and B9. Its a simple Yes or No selection I would like if B7 - Yes then cell G7 = 100% If B7 = No, then cell G7 = 0% :confused: Thanks!

Please Help, I have been searching the internet for an answer but cannot get what I am looking for. Here is what I need to know how to do: ActiveCell.Offset (0, E40).Select ActiveCell.Offset (0, "The value of cell E40").select It seems so simple but I have not figured out a solution. TIA.

Hi. I am not a VB programmer, but I expect the answer would be easy for those who are. I have a simple VB routine running on a spreadsheet that clears the contents of a cell when the value has been changes. I would like to add a checkbox to my spreadsheet to turn on or off this feature...

Hi, I have a worksheet with lots of hyperlinks to files. I have moved all the files into a subfolder of their previous location called Archive. I want to edit all the hyperlinks to include "Archive" in them. They are relative hyperlinks. In my head this should be easy, but I can't work out a...

Hi All, Very Happy New Year. As my experience to learn VBA with MrExcel is outstanding. And hence MrExcel Experts are Programmers and hence you can guide me on Vb.net tutorial. Could any one have idea the simple and best link or document to learn vb.net, please.. Many Thanks..

Hello, I have a simple issue but can't seem to figure it out. All I want is to add time and subtract time to show how many hours and minutes the difference is. Example: A1: 08:00 (8AM) A2:16:30 (430PM) A3: =A1+A2=24:30 (Format: [h]:mm) No format combination I've come across will list 08:30...

HI I am trying to produce a simple spreadsheet whereby I can monitor if staff working alone are overdue to phone in to say they have finished and are safe. All I need is a column for time due to finish and another column that shows time (hrs Mins) elapsed. If that could change colour after...

My colleague encountered a strange issue with a simple sum: <colgroup><col></colgroup><tbody> 22.05 -7.05 661.00 -232.00 -20.75 6.20 -427.85 -1.60 Sum: -3.41949E-14 </tbody> <colgroup><col></colgroup><tbody> </tbody> If you reorder any of these it fixes it to zero sum...