Excel Forum
-
25% of a cell if text in another? [Closed]
Hello, I was wondering if someone could help me with the formula for 25% of a cell if another cell has text in it to give me the sum total of a ra...
-
Excel data transfer between separate spread sheets [Closed]
Hi guys, I have a table in the spreadsheet that I want to transfer data from to another spreadsheet. The thing is that even though not every field ...
-
Need to search an excel spreadsheet column [Closed]
but hoping I'm wrong? Need to search an excel spreadsheet column (say column D) for all rows with the text "3 Pounds" If the text is found in a cel...
-
conditional formatting [Closed]
Hello, I need a help from you . Am trying to give three color condition in a pivot table and slicers report. We have sheet with Pivot table ...
-
Bringing similar names of different spelling together [Closed]
Hello, I have 2 similar files. each has several columns of information. each row for one person. 80-90 % of the rows in 2 files are the same person...
-
formula if you have credit in one column, debit in next column [Solved/Closed]
Hello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...
-
Macros Invoicing drop down list [Closed]
Hello, Hope everyone it doing well. I am looking for some help with Excel 2010. I have a template that I use to invoice my customers. My customer ...
-
Excel right and left arrows not working properly [Closed]
Hello, I spilled Coke on my laptop this afternoon and while frantically trying to remove it I pressed something that has inserted some kind of pr...
-
how excel displays ascending order of data in other spreadsheet [Closed]
hello, I try to prepare data of students details with random serial no.s in one excel spreadsheet. How I link it to display ascending order i.e.sma...
-
Data subsets and duplicates [Closed]
Hello, I have been trying to find the answer in a few forums but haven't found quite what I'm looking for. I have a column (A) of around 2000 n...
-
need a cell to change colour if another cell has an 'x [Closed]
hello, i need a cell to change colour if another cell has an 'x' in it. so if cell r14 has an x in it cell r13 turns green can anyone help? tha...
-
Excel conditional formatting w/date range and containing text [Closed]
Hello, I need to make a conditional format based on the date in a cell being between 30-60 days past today's date and only if another cell contain...
-
Date format not changing! [Closed]
I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried chan...
-
Excel date formula won't change [Closed]
Hello, I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried...
-
conditional Formatting cell in a column vs a cell in other col. [Closed]
Hello, I am comparing two cells in two different columns. I will do this for the 124 rows. if column G cell let's say G7 is larger than B7 then G...
-
Help with Sumif function please.. [Closed]
Could someone please help me?? I need to sum the values of a range of cells that contain certain text (product codes) into another cell. For example...
-
if condition [Closed]
if a2=mathura then result plm a2=agra and b2
-
How to re/name a cell if another cell contains X [Solved/Closed]
Hello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...
-
Screen is locked - its not scroll lock [Closed]
Hello, My screen wont move up or down, neither from cell to cell. Its not the scroll lock function. Anybody know what function I activated by mi...
-
Data arrangement [Closed]
Hello, I have 2 sheets in an Excel workbook. I am trying to code certain cells in a pre-made template on Sheet 1 to automatically sync with my dat...
-
Define a default path for macro enabled template file (saving) [Closed]
Greetings, I have created a macro enabled template file named test.xltm. Double click on the file opens a file named test1. on choosing save as res...
-
fill in automatically [Closed]
Hello, I have two colum in excel sheet colum A1 contain big list of job titles each one of it have a code for example: Job Title name ...
-
Macro Help [Closed]
Hello All, In short, this is the issue I am facing: I have created a macro to copy and paste data from one spreadsheet to another. Specifically,...
-
copy data from 2 sheets in 1 workbook to new workbook [Closed]
Hello, I am new to macros in Excel and could use any help. I want to copy the basic name and customer info from 1 sheet(1) and create a new workb...
-
Can I get the Autofilter to work automatically without [Closed]
I have the following which is filter my data based on a cell: Private Sub Worksheet_selectionchange(ByVal Target As Range) If (Intersect(Target...
-
How to transpose and move data [Closed]
Hello, Have a data set which is 2 columns and 596 rows, in which I need to transpose parts of the data set, remove empty columns, and then line up...
-
conditional data display depending on a dropdown list [Closed]
Hello, I would like to creat a form which would display certain data dependent on what was chosen in a dropdown list. For example, if my dropdown...
-
Create new workbook copying data from 2 sheets in same workbook [Closed]
I want to copy the basic name and customer info from 1 sheet and create a new workbook with that customer's name as part of the file (and copy several...
-
IF Formula Query [Closed]
Hi there, I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in the...
-
Data consolidation [Closed]
Dears Need your expertise advice. I have an excel data in below format , need a formula Column 1 has text like ABA, ABA , ABB, ABC, ABC, ABC . ...
-
How to create a macro to update a file based on a masterfile [Closed]
Hi I would like to create a macro (program) which will update a file by clicking on a button, based on a masterfile. Basically I have a list of ...
-
Transferring data [Closed]
Hi, I use excel 2007 version. I have some data in an excel sheet - students' names, ids, test items attempted, multiple attempts made by each st...
-
Transfering data for a spreadsheet to another [Closed]
Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.
-
Conditional format only if different from cell in another sheet [Closed]
Hello. I am using Excel 2011 on a Mac. I have two sheets in my worksheet. Both sheets are a two week schedule. Sheet 1 is titled PP - it is the ...
-
auto-copy cells one to another + formation too [Closed]
Hi! I want to make intelligent excel, like.. i have many sheets and i want it to work the way, that sheet2 takes data from sheet1. so 1) ...
-
set a conditional formatting to highlight the latest number [Closed]
I have a column to record invoice numbers in this formatting KI-00123 where the number portion is in running order. How do i set a conditional formatt...
-
Strike through when entering date [Solved/Closed]
Hello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...
-
Place new Code to Working Code [Solved/Closed]
Hello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...
-
Printing Selected Columns from Multiple Sheets [Closed]
Good day, I recently made a workbook with multiple sheets. I am a newbie regarding Excel. I would like to know if there is a way for me to have ...
-
Copying a row to a different worksheets depending on word [Closed]
Active Worksheet is called Quote Sheet Row A has a drop down list: Booked Missed ...
-
If Statement or something else to Copy from sheet 1 to sheet 2 [Closed]
Hello, I am looking for a bit of help. I am not sure if this has been asked I tried looking at other post. Any Help to point me in the correct dir...
-
Please helpin creating a macro that will create a new spreadshee [Closed]
Hello, I would like to kindly ask for help in creating a macro that will generate a new spreadsheet based on the letter entered in a specific colu...
-
A macro in excel [Closed]
Issue : I have a worksheet with two columns. First column contains some individual names, and second column contains Residence PIN number of the in...
-
Export data from worksheet to another Excel file [Closed]
Hi I would like a macro that cam help me export data to another file. I have an Excel form which I would like to move the entries into another ...
-
Create folder and save file macro [Closed]
Hi I am hopping someone can help me with a macro code. I would like to save a worksheet (only the active sheet) into a shared drive (if not acti...
-
Excel help [Solved/Closed]
In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last date to the far ri...
-
OVERFLOW ERROR [Closed]
Hello, I USED THIS MACRO BUT AN OVERFLOW ERROR MESSAGE APPEARS. KINDLY, HOW CAN I SOLVE THIS PROBLEM ? Configuration: Windows 7 / Chrome 47.0....
-
excel [Closed]
I have a spread sheet on Sheet one that has a list of properties that are assigned to various people with some additional info on each line about the ...
-
Format cell values to be included in another cell [Closed]
Hello, I am currently creating a holiday planner for all my employees on Excel 2010. I also want to create a separate cell for each day that shows...
-
Conditional Formatting Problum [Closed]
Hello, i have excel 2010 i have two rows. a & b i want if row a cell value not equal b cell value then change color cell b. (Note this format...
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram