Hello, I understand how to reference a cell to have the same text as another cell in a different worksheet, but how do you also get excel to change...
Hello, I am looking for a conditional formatting or/and formula to apply the following: -in a selected area (column, row, worksheet) values sho...
Hello, I'm using Bluebeam Revu and exporting markups into a CSV file for different projects. I'm looking for a macro that can extract data from th...
Hello, I have the amount which includes freight charge+fuel surcharge that is $14.36. It is said that fuel surcharge is 22%. what formula should w...
Hello, I got a whole lot of data saved as dd/mm/yyyy - need them to be converted to read yyyy/mm/dd - any ideas?
Apologies if the title is too vague. I will if necessary rewrite it to comply with forum rules. I have posted this same question here: https://www....
Hello, I'm using this code to set specific text to visible cells in Column AA. How can I change the below or use a similair method to set the cor...
Hello, please confrim how to convert numeric in words in excel. Simple formula required
Hello, I am putting together a spreadsheet to track work orders and I would like to know if it is possible to have the spreadsheet send an automat...
No Name Eng Maths Bio Econs Distinction Credit Pass Fail 1. John Dan 56 67 78 66 ...
Hello, I have spreadsheet containing multiple sheets and values in it. I would like to make a macro tool to create a dropdown button of the sheet a...
I'm creating a job tracking workbook, with a master sheet on page 1. Additional worksheets are used to list activity on the job. From sheet 1, I am cr...
Hello, Good Morning. I have a list of transaction in one sheet. With a column showing the sheet name where the data of that row should be trans...
Hello, I am trying to Compare Column A to Columns B,C,D and put location of match in column E. Is this possible? Configuration: Windows 7 ...
Hello, I would like to change cells in column C base on numbers in Column A and B. So for example, A1=3, B1= 1, C1= Red A2=2, B2= 2, C2= yellow ...
Hello, I have a master budget with a summary on one worksheet, and department budgets on subsequent sheets. When there is a number on the summary sh...
Hey there! I'm new to using macros on Excel, and I've been having some trouble. I have a sheet called "Rating Plate Template" which has been sized ...
Hello All, New user here. I have tried to research an answer to my question to no avail. I have found similar situations and solutions, but not o...
Compare 2 workbook and paste the non-duplicate data in the third workbook in an empty cell.
Hello, I have a database and I created a form using this database . I used "index" syntax and it works but my problem is I need to print this form...
Looking for a excell expert Is this possible? I want to transfer multiple cells Of a worksheet to another sheet in the same work book with a single ...
Hello, I have been following the thread from people with similar problems but mine is not fixed. This all happened yesterday when AVG falsely ident...
I want to transfer multiple cells Of a worksheet to another sheet in the same work book with single click. This is a work schedule of jobs and I'm w...
Hello, i have a column in format like 14-02-14 and i want to change it like14-02-2014
Hello, Thank for the earlier reply. Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. ...
Hello, I have a basic understanding of macros, but I have never written a macro, or developed something of this complexity. The user of this ma...
Hello, Hi, I have been seeking out for a solution for a problem. I have tried a couple of formulas like VLOOKUP, INDEX.. MATCH and nothing seemed...
Hello, I work for a financial institution and looking for a formula with IF condition.If i collect that month installment, It should reduce the no ...
Hi, We have one sheet were the master data is entered. There are different users who input data on this master sheet. How can this data be copied o...
Hi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...
I have a customer who sends me a Excel bid form that is protected and they want us to enter our price, manufacturer name, catalog number and delivery ...
Hello, Is it possible to have a formula that automatically adds the day to a cell if a date is entered into another cell. For example, Column A...
Hello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...
Hello, I have use MSoffice-2010,in a excel sheet there is some data with 72 rows.Main issue is when I sent the excel sheet to my friend he got the ...
Hi All, Im doing audit for diving equipment. All data will be compiled in 1 excel file with several sheets. 1 - Record of Inspections - NC 2...
Hello, I am having difficulties when navigating in my spreadsheet. All works fine except the arrow up key. When pressed it moves to the cell above...
Hello, Here is my code that change column color base on another cell color, i want a that change row cell color with Yes value base on another cell c...
Hello all, I'm new to the 'Corporate Level' of Excel, so I could really use some help. Here's my situation. I was given 3 spreadsheets. The first ...
Hello, i have 2 excel sheets, each with 2 columns name and email. the scenario is i want to compare both sheets and display those which has the same...
Hello, I have done conditional formatting in column D (if duplicate value found then cell color will be red), now I want the respective row cell t...
Hello, I'm aware of the post here https://ccm.net/faq/7546-excel-repeat-rows-a-specified-number-of-times But I would like to just type a num...
Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row ...
Hello, I would like to enter multiple data on sheet 1 and copy and update the data on sheet 2 by running the macros. This should work for foll...
Not even sure where to begin on this one and not sure it's possible either but thought it's worth a try. I have a document to record date's when jobs ...
Hi, I Have basically a template which I use for export, as shown in example below My template columns A,B,C layout are like: A ...
Hello, i have been trying to figure out how to make my code stop bugging out on me. any and all help will be greatly appreciated. Option Compare ...
Hello, Here is a Microsoft excel question. I have a column with words in it. The words will change depending on what the row next to it say. The col...
Hello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...
Hello, When trying to create a chart with information trending over a long period of time I keep receiving this error message: "The maximum nu...
I have a document in excel where I want to change the colour of a number of cells based on information in one. So I'm guessing a formula will be neede...
DON'T MISS