Excel Forum
-
moving data from column to row [Closed]
Hi All, Please help me with the macro code for pasting the column data(which is shown below) to row. Data is have like this A Cell B Cel...
-
search for a string and if found, select that row? [Solved/Closed]
I know this is a very simple question but I can't find the answer I need. I am using Excel 2007 but I can get to a computer with Excel 2010 if necessa...
-
Re: Financial Modelling [Closed]
Will appreciate any advise on the best approach to doing financial models for established companies and start-ups trying to raise venture capital fund...
-
MS xl formulah [Closed]
how to show conditional result in another cell in ms xl? for example, if A2 is >5% then the result would be 20 in B2
-
How to add times in hour and minutes format [Solved/Closed]
Hello In the first column I have start time, in the second finish time and the third column the time elapsed ie A minus B = C But if I add colum...
-
I want to find the student Grade [Closed]
I want to find the student Grade My formual is : =IF(OR(C12
-
Copying text from sheet 1 to sheet 2 in same workbook [Closed]
Hello, Greetings everyone, I am a new user here. I wondered if anyone could please help me with copying text data from sheet 1 of a workbook to...
-
coming and out going time [Closed]
I ampreparing in excel with in coming and out going time,But for the average time i am taking as for 5 hours a day,If any employees works for more tha...
-
Getting multiple values out of one cell [Closed]
I trying to copy into another cell data from 1 cell that has multiple values that are seperated by blanks. Example a1 has 123 456 789. I used the ...
-
"COUNTIF" function for day of the week format [Closed]
I have a column of dates, where the formatting I've set for "Day of the week, month, day, year". How do I run a COUNTIF function for Mondays, Tuesd...
-
Extracting Name from column [Closed]
I would just like to extract the name from a column: 224. Can someone help me do that?
-
Conditional format based on cell containing function [Closed]
Hello, In column J3:J32 i have functions that determinates grades (=IF(I3>=90;"10";IF(I3>=80;"9";IF(I3>=70;"8";IF(I3>=60;"7";IF(I3>=50;"6";"5"))))))...
-
changing date format in excel [Closed]
I have imported dates in an excel spreadsheet from WinQs.sql and opened the file in excel. the date format is 07/11/2009 but I want to change the dat...
-
Macro [Closed]
Greetings, I use peachtree accounting software and we have no option to export reports in excel. can i record macro to pull data from application? ...
-
Formula:IF E18 = 1, 2, 3, 4 or 5 Then End Result = G18, G19 etc. [Solved/Closed]
Trying to create a formula where I have a merged cell (E18) that if 1, 2, 3, 4 or 5 is entered I want the end result to equal the contents of G18, G19...
-
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- How to Install a VPN
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram