I have the following macro which does the following:
Get the file names from a folder on Windows
Combines the name with the folder name
Hyperlinks the conjoined names
How it looks in the table:
My code is as follows:
'Gets file names
Dim xFSO As Object
Dim xFolder As...
I'm creating a demographic questionnaire. Client # 1 will have already input their address into a cell (D7). I want Client # 2 (the Partner of Client #1) to be able to simply type "Yes" into a cell (C21) if their address is the same as their partner's address. I want this address (from D7) to...
I wonder if someone can help me with this problem with amacro.
I have a table of data that appears below(input data) whichhas usernames down a few rows and one or more accounts across 70 columns.
On a regular basis, I would need to able to copy all theaccount numbers that are present...
I have a formula in a table that uses an IF function. The output of the formula dynamically plots a line chart.
The problem I'm experiencing is that if the output of the IF function is False, then the "" value output is interpreted by the dynamic line chart as a zero instead of a blank cell...
I have a concatenate formula to output into a cell something like "100% / 75% / (25%)" (code is below).
I'd like to either bold or italicize that 25%...something to show that the (25%) is a variance and not a raw value.
It needs to be something other that "red" font since sometimes the...
Hi Excel Experts,
Myself Srini, new to this forum. I need your help to provide a macro code for the below
Input & Output file image links are as below
Input File Image-->https://ibb.co/xLQ6dLD
Output File Image--> https://ibb.co/f0VMv9c
In Input, Rows & Columns can be n numbers.
I need little help for solving a small problem. below worksheet is out of our Bill of Material formula, if we want to produce a Product '55500' we will need input 500,510,520,530,7600.
7600 is our WIP which also has input 10,20,30,40. i need a formula in next column which add...
I have a doc with 90000 rows. I need to visualise a status.
I.e row 10 has on, then row 20 has off, so 11 to 20 have the ON flag and is visible.
trying to do this manually and it is taking for ever to identify the start point, double click so it fills down
The statuses are in Y, and i want AA...
I know its simplest..still I need since I made mistake
Input Cell: B2 which can be EITHER of “d2” or “d3” or “d4” or “d5”. That’s All
Output Cell: D2:
IF B2=”d2” THEN D2=”k3”
IF B2=”d3” THEN D2=”k4”
IF B2=”d4” THEN D2=”k5”
IF B2=”d5” THEN D2=”k6”
How to accomplish?
I am using Excel 2007
I would like to print attached sheet with frozen panes (two rows + five columns) on one A4 as follows.
I have set print titles according to instructions on this page.
Afterthat I select range F3:AC10 and then print...
I have a list of phone #'s in the format
I would like to remove the dash so the output looks like
I've tried find and replace but it does not work. Any thoughts?
i have been requested to make a simple absence viewer iin our office that is feeding from a report from our HR system and appending that report over the top of the previous one.
Essentially, the report comes down like this :
Name, Unique ID, Office Location, Dept and then absent date.
Please could someone help me to do this (I have searched the internet and found nothing or more than likely, am not using the correct terminology :eeek:) ...
I want to use the numbers in Column F the D2 number of times to Equal C2 (or at least as close to it as possible if the actual...
I am looking for an excel formula which would pickup from whole data , here with attached data for your reference. Data available in columns like from Jan to Dec and output i dont want to show everything in one go so only selected months need to be shown in output summary. which...
HI Every one,
i need a output in the following format could any one please help me out
I am using 2 embedded IF statements in the attempt to produce either a string (cell&cell...) or a string with -SPARE are the end.
I know the inner IF statement works as expected. The result is setup to work on the FALSE, not TRUE for desired output.
My outer IF works when I do not include the...
I have an Excel 2010 workbook (let's call it 'Master') with many worksheets, whatever name.
Each worksheet has data structured as shown below. One of the columns has an identifier, such as a supplier code. Both sheets on the Master are sorted on Column1_header.
Note: The actual structure is...
I have a column of numbers and some NA. I am creating dummy variables, for example, IF(A2>0.7,1,0) and repeat this function into the entire column. However, I have NA in this column. Therefore, how can I ignore NA and set the output of NA as 'NO'.
Thank you so much.
I want to scramble a given string then store the various combinations to a variable or an array based on what you think is cool for my demand. I came across this pieces but they are not exactly what I wanted.
Now this is what I wanna achieve; my code will take a string in the form “AABB” eg...