Excel Forum
-
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...
-
Using cell A1 to reflect status of A2-A15 [Closed]
Hello, I have conditionally formatted A2-A15 to visually represent a stoplight for a series of equipment dependencies (RED, YELLOW, GREEN). I...
-
excel [Closed]
Sir I ve the following fields in my database Date Receipt No Ref No Name of the student Fees Tc total 01/04/2015 ...
-
Import multiple xmls into a single excel file [Closed]
Hello, I have > 100 xmls to be imported into excel. Is there a way to import all the XMLs into a single excel? Please help need this urgently. ...
-
Date format change [Closed]
Hello, The date format is as follows : Dec 15, 2015 10:47:52 AM, I need to change to the format "DD/MM/YYYY". Could you please help me with this. ...
-
automatically email notification [Closed]
Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows / Chrome 47...
-
HOW TO GET FILTERED DATA INTO A SEPARATE SHEET [Closed]
I HAVE MY DATA SHEET WITH FIELDS GROUPED UNDER NAME, REF.NO, SALES . I WANT TO SORT IT ACCORDING TO THE REFERENCE NUMBER AND PLACE THE PARTICULA FIELD...
-
database report [Closed]
Dear Sir I have the following fields Month Receipt No Ref No. Name of the student Fees Transport Total. We enter the data according to the recei...
-
Cell formatting [Closed]
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 how many p...
-
VBA script to copy data to another worksheet if the conditions [Closed]
Hi , Can someone help to give some VB script copy data from one sheet to new sheet if the conditions matches. I have a guest list with name, email ad...
-
Hello, where am I going wrong with this formula? [Solved/Closed]
=P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10) The final result in cell AV10 must be the value in cell P10 plus ROUND(SUM... [H...
-
Creating a macro to pull data from a sheet and transpose [Closed]
Hello, I am working on creating a journal entry form where I can enter a 'A" for accrual and have a macro look up the "A" then create a new spreads...
-
conditional formatting [Closed]
I want a cell to change colour if the value in another cell is negative
-
If change in Column A - Copy paste data in new worksheet [Closed]
Hello, Request your help. I have department wise data in a worksheet. Department name is given in Column A. I need to create new excel file for ea...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video