Excel Forum
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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"...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 -...
-
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...
-
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...
-
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-...
-
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,...
-
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 ...
-
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...
-
time calculation formula [Closed]
Hello, what is the formula to calculate time between two different dates and times Thanks
-
date function [Solved/Closed]
i want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as...
-
list dependant drop down menu [Closed]
Hello everyone, I have a worksheet with two columns (A and B) of data. I'm trying to populate a second worksheet (column A) using a drop down...
-
Applying conditional formatting to multiple cells [Closed]
Hi all, I've actualy already done what I needed to do, but as this is a very sensitive document I would like to know WHY it worked, just to be...
-
Formula to highlight cell based on data value over 2 cells [Closed]
Hi Guys and Girls, I'm am trying to improve a current spreadsheet I'm using where I am collating movement times in and out of a location. I...
-
Conditional formatting to colour cell based on text in another [Closed]
Hi, I have a workbook tracking submission of work ideas. In column C I have the date received. In column J I have status (approved, rejected,...
-
Excel [Closed]
Hello, Function SpellNumber(amt As Variant) As Variant Dim FIGURE As Variant Dim LENFIG As Integer Dim i As Integer Dim WORDs(19) As...
-
Conditioning Formatting [Closed]
HI All, we have mandatory annual training requirements and I have a spreadsheet which records the date training has been completed. we have...
-
Formula [Closed]
i
-
Remove duplicates and merge rows [Closed]
A B C D E 2000 Mary 123 street1,street2 2000 James 123 street2 2000 Mary 123 street1 ...
-
Date formula [Closed]
HI I want to set the formula for excel for when I insert date in cell ex. 1dec2013 then I will select any empty cell date change in to 31dec2013
-
If command across multiple cells [Closed]
Hi Guys, I can successfully use if command with text on a single cell, however I want the true or false outcome to be based on multiple...
-
Writing a macro that copies data from multiple worksheets to one [Closed]
I have a workbook that has over 580 different worksheets, and I need to copy a certain section from each worksheet onto a "master" worksheet. The...
-
Find and Extract text from a cell content [Closed]
I need to search a cell for content and extract and display a portion of the cells content. How do I do this? Here are more specifics. lets...
-
Nested If logic is not working [Closed]
Please tell me what's wrong in below...
