Excel Forum
-
Conditional formatting with values [Closed]
Need some spreadsheet help. I need the value ($'s) in Cell A to become RED if Cell B is greater than Cell C. Make sense? So... If my actuals are...
-
store the values in next sheet [Closed]
Dear All, I have doubt in xl sheet, I have two xl sheet , i show the first sheet parameter as below, CABLE NO -1 LOAD -18.5 VOLTAGE -415 CURRENT...
-
how do i add text to a drop down list [Solved/Closed]
Good day how do i add text to a drop down list i created in excel Configuration: Windows XP / Chrome 24.0.1312.57
-
generate payslip [Closed]
Hi, can any one help me to generate payslip? I have a master sheet with all the details including (basic, da, OT and other things). I do have t...
-
Partial Match issue [Closed]
Hello, I was searching for a formula for the partial match of the cells (for companies;for let's say 20 characters) and highligt them for 2 column...
-
Excel help [Solved/Closed]
I am tracking shipments of our product. When I enter the amount that shipped, I would like for that days date to appear in a separate cell and never c...
-
Vb, how to copy values & repeat to next 50 cells [Closed]
Hello, Need help writing code @ step C & D I am: A) copying values in E1-E4 & transposing values B) to Col. A next available empty row (obviousl...
-
Conditional formatting help [Solved/Closed]
Hi, I have a spreadsheet with a column for employee hours. Anything over 9 hours is considered overtime and we are tracking how many employees are ...
-
Macro Hyperlinks [Closed]
hello i already have this code in my macro that works fine s ub New_Personal_Profile() Dim MyCell As Range, MyRange As Range Set ...
-
Clearing a single Cell without deleting the contained formula [Closed]
Hello, this is my very first try at using a formula for help (so please be patient with me if I make a mistake:) I have a growing knowledge of Excel ...
-
presenting data from one worksheet to another by dropdown menu [Closed]
HI All, I have a worksheet with two colums of data. On another sheet I plan to present the data in an easier to read format. What I want to do i...
-
map column names to their short names [Closed]
hi all, i am trying to copy and paste columns like application id,application name,number in a worksheet in workbook1 to another worksheet in workboo...
-
Conditional formatting with "contain". [Solved/Closed]
Hello...I am using Excel 2007. I can't get beyond the following: =ISNUMBER(SEARCH("campaign",A2))=TRUE This is what I'm trying to do...If cell A2...
-
Look to find a formul that will make an item rec [Closed]
Hello I am looking to track items received... I would like to build a box were we enter the NSN and the amount of the items... Date auto populate. ...
-
MS Excel Number format error [Solved/Closed]
Hello, I use Ms Execl in that I have a error it like this..... 1. when I type a number 400 in the cell an give Enter. It is not showing the exa...
-
Date format problem (5.8.14) [Solved/Closed]
Hi. I'm using excel 2013 on Win7 Ultimate SP1. My problem is that I often type the dates with the help of decimals/periods. But I've learned thru goog...
-
Create new sheet and copy data from input page to the new page [Closed]
Hello Every One, I am a basic excel user. I am trying to create an excel data base that will keep a record of employee duty hours, dates and types...
-
add "x" based on "Y" lines and copy [Closed]
Help! I have a spread sheet that is over 8,000 lines and I need to insert and copy lines based on a value in "y". Also then add a blank line under the...
-
I am a computer opertor but i still need Excel! [Closed]
Hello, need your help please!!! Configuration: / Opera 9.80
-
ages and difference between them in years:months [Closed]
Hi, I would like to enter data in the form 12:06 meaning 12 years and 6 months and then work out the difference between two such cells with the an...
-
Insert Data from one sheet to another [Closed]
Hi Guys am new to Macro and looking for some help. i was trying to create a sheet to be entry data and the data to be saved in another tab without ...
-
Excel Date Format [Solved/Closed]
Hello, when users enter a date in excel using this format 12.1.2008, I need the cell to automatically change the format to 12-Jan-08 thanks, mo...
-
losing the plot with vba [Closed]
hello and huge thanks in advance, the following is a macro i have adapted to try and get a centralised team sheet auto sort and copy the relevant ...
-
conditional Formatting date issues [Closed]
Hello, Please help Conditional formatting will not work on columns displaying dd/mm/yyyy hh:mm:ss, (formatting highlights colour if todays date.) ...
-
Conditional Formatting [Closed]
Hi, I use excel to plot my production planning and would like to format so the ship date cell turns red once the ready date is greater then the shi...
-
Trying to aggregate data by different date across worksheets [Closed]
Hi, I am attempting to consolidate data across different worksheets in a workbook, that having different dates. For example, worksheet "Cert1" has...
-
how to delete 19 row after the cell which has certain value [Closed]
i have done a code to delete the row which has "Trip" in any cell in this row as below Sub DeleteRows() Dim c As Range Dim SrchRng ...
-
if condition to calculate incentives slabs [Closed]
IF(E162>=50,IF(F162>=50000,IF(F162=75,IF(F162>=75000,IF(F162
-
copy data from sheet1 to sheet2 [Closed]
Hello, I want to copy data from sheet 1 to sheet 2. I have data in 4 columns and 100 row in sheet1. I want to copy each row of sheet 1 in sheet 2 ...
-
Formula To ADD values from different columns [Closed]
Hi I am new to excel and need help in adding values in my sheet. the contents are as follows: NAME -------- TAG ---- ...
-
Help with Time, and Alert Formula [Closed]
Hey all.. New to the forum, so please be gentle.. hehe I working in a busy office/communications orientated job, and I am wanting some help with ...
-
How to transfer data from all the sheets and pasting it in [Closed]
Hi All, I need one help, I am having excel workbook, I need to copy the data which is there in each sheet and i need to paste that in a master work...
-
link information in entered in worksheet 1 to another worksheet [Closed]
Hi All, I am really hoping someone to help me with this. I have an Excel workbook The first workbook is the form we fill out for new employees Th...
-
how to import/copy contents from one cell with many rows [Closed]
please help me on how to import/copy contents from one cell with many rows to another sheet.
-
Last ID # Entered [Closed]
I have a very long list of ID #'s that all start with the either BIL_ADMIN_ and then the number or with BIL_RECEIPT_ and then the number. Is there a ...
-
Column totals using macro [Closed]
need help , how do I add sum totals at the bottom of columns of varying lengths using macros. eg I have data in columns a to f, I want columns c to f ...
-
A Macros to Pull Data from an automated Excel Sheet [Closed]
Hello, I have a running spreadsheet where the data is automatically updated. On a separate sheet I am trying to pull information off the main sprea...
-
Help with text & number rule! [Solved/Closed]
I wonder if anyone would know how to create the following rule in Excel: IF I enter a specific "text" in cell A, then Excel would insert a correspo...
-
Auto populating entire list based on DDL [Closed]
Hi everyone! I've stumped myself once again in Excel and am desperate for help. I'm attempting to auto populate an entire list based on a drop dow...
-
Applying my macro to a range of cells... [Solved/Closed]
I found this macro and it works perfectly....inserts an "x" on a single mouse click into cells, but I only want it active on a certain range of cells....
-
Conditional Fomatting [Closed]
I am trying to add conditional formatting to a spreadsheet. It is an employee list showing drivers lic and med cards expiration dates. I want to forma...
-
Macro for creating text file and copy paste date [Closed]
Hello experts, I need an another macro, a keypad shortcut triggered macro (Ctrl+j), which will copy ranges "A10:A45", create a new text file on the...
-
Help with comparing column data [Closed]
Here is my situation, I have a DB with a column of customer #'s that I want to tie to a status column. Each customer # can have anywhere from 1 - 12 ...
-
paste 10 or more worksheets data in a single worksheet [Closed]
I want paste 10 or more worksheets data in a single worksheet by using formula, is it possible?? Thanks in advance Mahfuz
-
Creating workbook and copying data [Closed]
Hello, I have a work book in which the sheet - "Master list". Column D contains the master list of clients. 2nd sheet "Template" contains the maste...
-
Doubts on Sum Mulitple Sheets [Closed]
Hi All, I have different kind of workbooks having records from A6to BB6 in this we can enter the details on daily basis sales . One more Master...
-
How to use formula for transfering data from Sheet 1 to Sheet 2? [Closed]
Date & Time JOB NO PENDING 12/23/13 2:14 PM SICD-B00xxx * My question is, there are three cells named- Date & ...
-
Macro for copying cells with format from last sheet to new sheet [Closed]
Hello, My project requires to maintain a database for all customers. I have already obtained an event macro from experts from this forum, which, I...
-
Excel formula [Closed]
I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If 0...
-
Macro for creating a new excel sheet based on certain conditions [Closed]
Dear Experts, Greetings. My sincere thanks for the support you providing thorugh this forum. Now stuck with some requirements in the microsoft exce...
Subscribe To Our Newsletter!
DON'T MISS
- How to Disabled Write Protection on a USB
- How to Install a VPN
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram