Excel Forum
-
Changing the day in date by default Closed
Hi, I want to know that how can we change the day in date default by dragging down? Best Regards, Drakshayini
-
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.
