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...
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 ...
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...
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 ...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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 a2=mathura then result plm a2=agra and b2
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...
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...
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...
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...
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 ...
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,...
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...
I have the following which is filter my data based on a cell: Private Sub Worksheet_selectionchange(ByVal Target As Range) If (Intersect(Target...
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...
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...
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...
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...
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 . ...
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 ...
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...
Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.
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 ...
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) ...
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...
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...
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...
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 ...
Active Worksheet is called Quote Sheet Row A has a drop down list: Booked Missed ...
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...
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...
Issue : I have a worksheet with two columns. First column contains some individual names, and second column contains Residence PIN number of the in...
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 ...
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...
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...
Hello, I USED THIS MACRO BUT AN OVERFLOW ERROR MESSAGE APPEARS. KINDLY, HOW CAN I SOLVE THIS PROBLEM ? Configuration: Windows 7 / Chrome 47.0....
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 ...
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...
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...
DON'T MISS