Excel Forum
-
Some change in vba code [Closed]
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...
-
Merge Cells that have to same data in Excel! [Closed]
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 ...
-
Comparing two excel sheets [Closed]
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...
-
Conditional Formatting in multiple column [Closed]
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...
-
Excel - Repeat rows a specified number of times [Solved/Closed]
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...
-
how to repeat rows by x number of times [Solved/Closed]
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 ...
-
Macros to copy multiple data from 1 sheet and saving it on anotr [Closed]
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...
-
Highlight Jobs that are due. [Closed]
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 ...
-
add data from a template exel file into a master excel database [Closed]
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 ...
-
excel 2003 question. on conditional formatting using VBA [Closed]
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 ...
-
Excel "IF" formula Help! [Closed]
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...
-
ROUNDING FUNCTION [Solved/Closed]
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...
-
How to stop Excel error message for too many data points? [Closed]
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...
-
Conditional Formatting [Closed]
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...
-
. [Closed]
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...
-
VBA to refresh all pivot tables [Solved/Closed]
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 ...
-
Massive Copy/Paste..can it be done? [Closed]
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...
-
Macro to add/remove rows based on highest # in group of cells [Solved/Closed]
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....
-
Insert row data on Sheet2 based on sheet1 cell value(text) [Closed]
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 ...
-
Search Multiple Sheets of a Workbook & Copy the Results [Closed]
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...
-
Excel - a Macro for copying data from different sheets [Closed]
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...
-
If text encountered, add rows [Closed]
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...
-
How to add a number every two weeks in Excel? [Closed]
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...
-
How to match 2 lists to get the unique entries [Closed]
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...
-
Calculate Formula based on values for two dates [Closed]
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 ...
-
Excel date format [Closed]
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...
-
Corrupted Excel and Word docs [Closed]
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 ...
-
Data from one file into running totals in another? [Closed]
Hi folks, I have two spreadsheet files. Both contain figures. One is updated daily and cleared daily. One is updated daily and maintained for...
-
How to pull text from column B if cell matches data in column A [Closed]
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...
-
Conditional Formatting Help [Closed]
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...
-
Combining rows [Closed]
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...
-
Conditional formatting based on range ofcells in different sheet [Closed]
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...
-
Replacing a value using lookup table [Closed]
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...
-
conditional graphbar colors [Closed]
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, ...
-
Copy specific cells to separate worksheets upon 2 conditions [Solved/Closed]
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...
-
Check if cells are blank or zero help please [Closed]
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 ...
-
Help creating an automated sheet [Closed]
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...
-
Change a value of a cell using look-up table [Closed]
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...
-
Based on date copy data and move total net down [Closed]
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...
-
change the cell color if the text in cell changes [Closed]
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 /...
-
give a text cell a percentage value [Closed]
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...
-
problem with macro [Solved/Closed]
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...
-
Search for a text in all the text files of a folder [Closed]
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 ...
-
Copy certain cells when an option is selected [Solved/Closed]
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...
-
I need help with conditional formating and VB [Closed]
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...
-
Multiple lines copy marco technic [Closed]
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...
-
Arrow key now working. [Solved/Closed]
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?
-
If function using dates in 2 cells [Closed]
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 ...
-
Data Comparison Between two excel. [Closed]
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...
-
single cell in my "work area" tab to be copied to a cell in the [Closed]
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram