question

Hello and thank you in advance for any help. I'm looking to have VLOOKUP return a hyperlink, but one which is a reference within the workbook, rather than a URL. Can't find a format for writing the hyperlink to begin with that Vlookup can then return as working. Explanation of the below...

Hello, got problem, can somebody help me? How can I save file as .csv by macro in current folder? I would like to avoid defining file path to save because it will be different in every case. Another question - how can I grab string from cell(A1) and put it in the name of saved workbook as...

Dear Friends and fellows, Yesterday I asked one question which is not clear. it's because of my lack English knowledge. Kindly you all pardon me for that. Here is the clear question. If we take from 1 to 9 as complete 360° rotation. from 1-4 how much degree rotation. kindly write clear...

Hi Everyone, I'd like to ask a question about a very simple excel problem but I don't know how to solve it, haha. I have a sequence formula like this: <tbody> 1000 5% =ROUNDDOWN(A1*(1+$B$1),0) =ROUNDDOWN(A2*(1+$B$1),0) =ROUNDDOWN(A3*(1+$B$1),0) =ROUNDDOWN(A4*(1+$B$1),0)...

Hello, I use this formula to get the actual charge (AF19), Min Charge (AG19), Or max charge (AH19) by days of the month. Question is how do I keep the cell for say the June 2nd total blank without the min charge populating if the data is not filled in yet in the other cells to get the total...

Hi All I am using this code and the target range represents 1 layout of 72 cells. I need to include 23 more layouts. My question: should I cram it all in 1 target range or should I duplicate this code for each layout? If Not Intersect(Target...

Hello everyone I know that once you enter a formula into a cell you can drag it down to fill in to all the cells under it. My question is in certain cells i have a different formula in it and was wondering if there was something i could put into the formula to prevent it from changing when i...

I am wondering if it is possible for a formula to return only the last part of a text string (without the $) from another cell? ie. in this example, the formula would return 81416. "over $47,630 up to $81,416" Hoping for a solution. Thanks!

Hi Sorry if this off topics. I am reading the job description below. I would appreciate if you can answer my questions just to get an idea what is the requirement and where I am at. 1) Validate MS Access databases to align with current excel model My question: Is this Access, Excel or VBA...

How do I create a question and answer bank with excel in a way that I can randomly produce tests with corresponding answer sheets? Also, I need to create multiple choice tests. Little about me: real dumb. Basic instruction and guidance is appreciated. Thanks in advance!

Could I trouble you for a formula to count the number of words in a cell. These are actually names so in an example of Stephen Thomas Smith the answer is 3. Such a simple question but I have thousands of rows that I need to review. As ever my sincere thanks

I was sent a workbook that had macros selecting columns of varying length. The debugger showed me it did not like the selection (A1:A) Once I changed it to (A1:A1000) far more cells than I'll ever populate, the macro works fine. The question is why does my Office 2016 not like it but many...

A kind soul helped me out with this the other day. Now I have a subsequent question: How do I set a variable to this value? Here's what I'm trying to do: Set MyFile = Workbooks(" & Range("B1") & " " & Range("C1") & ".xlsx") so it would end up being: Set MyFile = Workbooks(Donors April.xlsx)...

It's such a simple question, but I don't know how to write the formula... Here's the question: If one knows that in 2018 that $3.59 was paid in dividends, and that in 2024 the expected dividend is $7.10, what is the percentage increase per year that will get you from $3.59 to $7.10? Thanks...

Thank you for your time in reading this< I've done my share of searching, but I think I don't know how to ask this question. I have a workbook with multiple connection queries, but I don't want to bring all the tens of thousands of lines of data into the table. Is there a way to look at the...

Instead of a number returned as expected the field has a '?'. Typical reasons why? Thanks in advance, Pikeboy

Context: I am trying to make a question bank to generate different assignment for each student so as to minimize copying... Task: I want to maintain a list of images in a sheet, let us call the sheet as LoI (for List of Images), and then I want randomly display a few of them on the Assignment...

Tl dr; I am trying to make a question bank where one of the question is match the following and I want to randomly select them to form an assignment. I am trying to make question bank in excel so that I can hand out a separate assignment sheet to each student. There are different types of...

Hello All I hope you can help on this please I have a drop down list in cell "P2" which allows me to select a value that then triggers a filter with the code shown below. Question 1 - How can I make this range Dynamic as the rows change daily. Question 2 - It is possible to put a value in...

I was just wondering if all questions get answered on this forum. I asked a question yesterday under the Excel questions, but it hasn't been answered but my other threads I asked same day were. Please don't take this the wrong way, I'm very grateful for everything you all have provided, all...