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...
Hello, I have data like this.. YTQ5478568 WBH548567 XML8457693 I need like this Y T Q 5 4 7 8 5 6 8 W B H 5 4 8 5 6 7 X M L 8 4 5 7 6 9...
Hello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...
I am working between to separate excel files. Basically, I'm hoping there is a way to copy and paste OR ever better a way to auto insert fields to ano...
I am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....
Hello, i have two sheets i.e., sheet1,sheet2 in Sheet1 row fields like A B C D E in that D field value like RC based RC value insert whole RC ...
Hey, So I have a problem and I can't seem to find a similar question asked before. I have an excel workbook with 10 sheets. Each sheet is rega...
Hi, I love your posting. I was just wondering if I could exclude some tabs from being copied. I am pulling information from pivot tables so I hav...
Hello, I would appreciate any help on a worksheet of thousands of lines of data I get and must format every week. Whenever the text "-C0" is enco...
Hello, I'm trying to come up with a formula that would automatically add a number in a cell every two weeks. Any help is appreciated. Configu...
I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the en...
Hello, I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value ...
Hello, I take care of a list in excel 2013, in which a group of people continuously feeds data (a sort of archive). One column expects dates in a ce...
Hello, I recently bought a new laptop pre-loaded with W8.1. I downloaded MS Office 2007 Home and Student (it was a 3 licence package and this was the ...
Hi folks, I have two spreadsheet files. Both contain figures. One is updated daily and cleared daily. One is updated daily and maintained for...
I want my form to know which employee is assigned to the county listed on the form. Basically, if cell F5 says Multnomah, I want the formula to look a...
Hello, I have a spreadsheet which we use for tracking all outgoing shipments. I have the expected delivery date in one column, and the actual deli...
Hello, My situation is similar to a question that was asked but not exactly the same. This is how my spreadsheet looks now: A 1 1 0 0 1 1 A 0...
Hi, I'm trying to make the conditional formatting based on as follows: cell in sheet 2 is getting red if anywhere in sheets 1,2 and 3 could be f...
Hello, I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Shee...
Hello, I am trying to create a chart where column B depicts numbers for 2014 and Column c for 2015. 2014 is a line graph and 2015 is a bar graph, ...
Hello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...
I have a spreadsheet where columns A and B will either contain numbers or be blank. I need to add a formula into column C (for example cell C2 which ...
I need to create an excel sheet that will automatically search information on a "raw data" sheet and give results on a different sheet "sheet 1". I w...
I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Sheet 2 w...
How to move total net etc down based on the data filled above based on date If guest stay 2nd night second night data must me filled below first...
Hello, How do I conditionally format in excel (i.e. change the cell color if the text in cell changes?) Thanks, JC Configuration: Windows 7 /...
hello everyone; i am doing an evaluation report (checklist) and the output will be used as values for evaluate the service itself, soi created a sele...
Hello, I have problem with macro. if I delet on of the samples data, the 4 parameters value (a,b,c ,d)will change while is 4 parameters based on the...
I have about 200 text files with different names that gets stored in a folder. What I want is when a specific word is found (ex error, fault). I want ...
Hello, Can anyone help me with a script to: Copy: cell A, Worksheet One to cell B, Worksheet Two; cell G, Worksheet One to cell D, Worksheet Tw...
OK so i have been trying to figure this out for a while and I am stumped. I have 2 columns 1 collum will have either M,Q,Y,S in them. these will no...
Hello, I have a little complex excel work to be done in my office. I will explain you below. It would be very great help if it clicks in your mind...
Hi, When i use the arrow keys using excel, the columns & Rows are being highlighted. How to unlock this? Can you help me to solve this?
Hello, I am trying to format a cell using the iF function for dates in 2 cells. Eg If the date is equal to or less than Jan1st in B2 and Greater ...
Hello, I have a situation where I need to compare data resulted from two SQL's ( Source & Target ). Need a macro to validate the differences and hig...
Hello, I believe this is somewhat easy/straightforward but I don't know how to handle. I have a work book with multiple tabs. One of the tabs (spr...
DON'T MISS