Excel Forum
-
Reminder in Excel spreadsheet [Closed]
Hi Team, I am trying to put a reminder in excel spreadsheet, I tried one macro, but its not popping up. Can any one you please help me to get...
-
Copy data from worksheets to master sheet [Closed]
Hi, I have one input workbook with multiple worksheets(all are with same table format) and I have to look in to each worksheet and if there...
-
How to compare two different columns [Closed]
Hi, I have a sheet with Id numbers in column A and names in column B, for around 50 workers. In other sheet I have Id number in column A, names...
-
How to the text/word of a cell in excel 2010 [Closed]
Hi, I am working on creating an excel spreadsheet in which I want a series of names to be outputted if the condition of another cell is...
-
Macro to Search/Replace Text from another Column [Solved/Closed]
Hello, I didn't realize I was being rude on my previous post, that wasn't my intention. I tend to have a "too the point" personality sometimes,...
-
Rename a tap [Closed]
Hello, frist I'm so sorry for my mistake , pls forgive me I don't mean that . always thanks every one, I don't no how I do that! If you...
-
Automatics mail with attachment to send using Outlook [Closed]
Hello all, I am very new to excel file so need help from this group. I have data (PDF and Excel), now i want to send automatics mail using...
-
Conditional format text cells based on a column with numbers [Closed]
Hello, So I have text cells describing what the numbers in the column next to it mean, however, I want the conditional formatting (data bars)...
-
EXCEL HELP [Closed]
Hello, Novice needs help I am trying to extract the contents of cells from several worksheets and summarize on one Header Summary...
-
Macro to filter out text contents [Closed]
i have Column E filled with numbers, formulas and text. I would like to write a macro to filter out the cells with text contents. The text...
-
urgent ansin excel [Solved/Closed]
a table caring 4 rows, first row is Name, second is address, 3rd row is date, and forth row is house name. how i arrange this in excel in date...
-
Automatically Rename Cells [Closed]
Hi, i am using Excel 2010 ...quite poorly as my skills are basic. I am trying to work out how to Incrementally number worksheets automatically ...
-
Transfer data from one Excel worksheet to another automatically [Closed]
Transfer data from one Excel worksheet to another automatically. we have 8 employees that enter job quote information onto their individual...
-
Tables [Closed]
Hello, I am trying to extract the contents of cells from several worksheets and summarize on one Header Summary Sheet So i'm trying to...
-
macro to delete rows between named ranges in excel [Closed]
How do I delete all rows between named ranges? I have a scenario below Name Range 1 : SUBHEADER_001 (A1:E1). Displays Headers Name Range 2...
-
I need help in my project [Closed]
first see this picture http://img713.imageshack.us/img713/6725/d9i8.png now what i want is, after typing the '2' in B2, i press Enter, D2 will...
-
Popup reminder based on date and additional celll values [Solved/Closed]
Hi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long...
-
PDF Converter to excel : [Closed]
Hi, I saw https://ccm.net/download/download-7685-pdf-to-excel-converter product. This product is very good. Is this a free version...
-
Macro to Search and Replace Text from another Column [Closed]
I receive an Excel file each month that has the following columns Group Name, DOS, Clinician Rpt Name, (rest of columns have patient...
-
macro to populate formula using Autofill [Closed]
i have 2 worksheets, A & B. In worksheet A, i have the data in cell F2, F3, F4. In worksheet B, i would like to refer worksheetA!F2 in...
-
Plotting multiple data [Closed]
Hello, How do I plot a table with multiple data like this: For May: Project 1 Project 2 Project 3 Item 1 ...
-
comparing the two excel sheet, what formula is required [Closed]
I have two excel sheets one column haveing the same numbers both the sheets, Now in same number I have alloted different compaines, now I need...
-
Help with a Formula 'Isblank refer to another cell" [Closed]
I need a formula that will give me number of days between two columns Which contain dates, if one or the other has no date populated it would then...
-
Averaging & Assigning Blank Cells a Specific Numeric Value [Closed]
Good day everyone. I'm sorry if this seems remedial, but I'm having trouble with a spreadsheet. Here's the gist of my problem: Within a row, I...
-
proportions?ratios? not sure [Closed]
I have an excel spreadsheet with four different money columns. I am trying to develop a formula that might create a comparison similar to what I...
-
Copy data from Master Sheet to Client Sheets [Closed]
Hello All Good Day I Need Some help from you that is i want to copy the data from Master Sheet to Client Sheets with Criteria Columns for...
-
How I convern number to spelling in excel [Closed]
Dear friend, This is my problem. Please solve it.
-
Pull values from conditionally formatted cells - Excel 2013 [Closed]
hello, I have a large data set wherein I am trying to figure out where certain values fall and am applying a cell color using conditional...
-
How to add a seperator / between fields, create function [Closed]
Hi, I am running a macro copying AA2:AA300 to B and copyiing AB2:AA300 to C this is done for 20 more columns going in B and C how can I add a...
-
Comparing Columns [Closed]
Hello, I have two list of customers on separate excel worksheets. The first list has name, address, etc. in separate columns and about 3000...
-
Hide rows with zero value in Multiple sheets [Solved/Closed]
Please help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in...
-
Populate rows on sheet1 based on values in sheet2 [Closed]
Hi, I need to populate rows in sheet1 -- S.No, Name , Address, Contact No. with the values present in sheet2 -- S.No, Name , Address, Contact...
-
pop up alert [Closed]
Hello, I have created a worksheet with macro to enter current time by clicking on a cell. For example, double click on A1 to enter current...
-
Display Formula in Cell with values [Closed]
i need to display the used formula in another cell as it is with substituting the values. example: if A1=100, A3=200, B1=206 formula is...
-
macro for copying sheet 1 into sheet 2 and then deleting data in [Closed]
i need macro for copying sheet 1 into sheet 2 and then deleting data in sheet 1 and sheet 3 plz help
-
Marco to add multiple images by filename [Closed]
Hello, I have a spreadsheet with 10 vlookup's in, reading from a Pivot Table on a separate tab. What I need is a macro to pull 10 image files...
-
Conditional formating [Solved/Closed]
I have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color,...
-
I need to run multiple automatic macros in one sheet [Closed]
I am developing a worksheet where there are multiple occasions down a list where users will have to select an option from a drop-down box (Y, N &...
-
Using head in VBA [Closed]
Hello, I would like to automating some operation with macro, and here is a problem with the head. At the beginning I've attached files that...
-
Calculate Time in and Time out with Money [Closed]
Can you let me know please? I have internet shop and i want to create time calculation(Time in, Time out) and total in hours of usage and...
-
Need to move "Received" jobs to new worksheet. [Closed]
Hello, I have a workbook named "Logistics Report" where I keep track of playground equipment. Once the equipment is received I need to move it...
-
Map/Copy values from one sheet to another where column 1 matches [Closed]
I have two sheets in a spreadsheet. Each sheet has a first column with common values (however they are not sorted the same and they are not all...
-
Convert a date field in excel to day of week [Solved/Closed]
Hello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the...
-
VBA create Listbox and populate with Hyperlinks [Closed]
Hello all, I am working on a project to create a data pull from the internet to obtain a news feed for a given stock. I currently ran into a...
-
i need help with excel formula [Closed]
Hello, I have a database of people requesting their points to be transferred from one account to another, frequency of transfers is a...
-
date format [Closed]
in MS-Excel, When i am sorting the dates in a column of format dd/mm/yyyy, say example 10/06/2007 and 02/10/2007, the sorted column shows...
-
Conditional formatting of cells with dropdownlist [Closed]
In column C of my spreadsheet i have created a drop down of a set of 96 locations in US. When i select a certain location from the drop down , i...
-
Comparing columns and returning value [Closed]
i've following: 1. Drop down values from 1 to 5 in column A. 2. Drop down values from A to E in column B. Ive following matrix...
-
some help needed about IF function with dates [Solved/Closed]
Hello, i m making a sheet with this function =IF(H1
-
Macro to transfer data from one sheet to another [Closed]
Hello, I would like to know whether this is possible using macros in excel Sheet 1 Column A Column B Column C Column D Column...
