Excel Forum
-
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 Column G,...
-
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 5% ...
-
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 to ...
-
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 ref...
-
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 have se...
-
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 thin...
-
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 your b...
-
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 formattin...
-
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 line...
-
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 custome...
-
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 multiple...
-
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 No. ...
-
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 time th...
-
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 =SUM(A1, ...
-
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 from...
-
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, dep...
-
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 & N/A)...
-
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 are d...
-
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 calculate i...
-
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 to a...
-
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 there...
-
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 week so...
-
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 proble...
-
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 combination ...
-
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 02/10/2007 i...
-
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 want ...
-
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 (A44:C68): 1 ...
-
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 E C...
-
Deleting a row Closed
I have an Excel file with rows from 2 to 988. There are two columns B titled Customer and C titled Main Email. I need a macro that will search column ...
-
Transferring Selected rows to Another location on anothersheet Closed
I Am trying to Move a selected range of cells to another sheet. As an example "sheet1" Columns C,D,E,F,G,has a data list entered and when i enter th...
-
Odd situation in Excel Closed
Hello, I'm designing a spreadsheet for my work in terms of I've got a set of numbers from 0-99, the evens are one week events and the odds are ano...
-
Substracting time from date & time to determine the date & time Closed
I have a 'simple' spreadsheet with five columns (warehouse #; part #; departure date & time; transit time and arrival date & time). I have packages...
-
Help with macros in excel Closed
Hello, I was wondering if anyone could help me in creating a macro file for excel....I am needing to save, print, and close an excel file at a cer...
-
Need Macro for Generate report table based on some critera Closed
Hi, I have a Table with 10 columns and 21 Rows. Last column has %allocation that is 'I' Cell of each Row divided by 8.75 and multiplied by 100. Exa...
-
Pls suggest for Excel Closed
Dear all, Pls suggest for my following issue related to Microsoft Excel. I created a Report in Excel having many sheets. In all sheets, Subsc...
-
creating pdf from selected cell range Solved/Closed
Dear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...
-
how to compare two coloumns in excel Solved/Closed
Hello,
-
HELP!! Excel 3 year reminder Closed
I have a formula: =TODAY()-$B2>3, this will remind me 3 days before a due date, but I need it to tell me to review after 3 YEARS of the dates I have i...
-
Please help- conditional formatting Closed
Hello, I want help to solve below described question for excel 2007. CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5...
-
Formatting Excel Closed
Hello, i got a problem regarding excel formatting. Excel displays every figure higher then 1.0 as a date and anything lower than that as the ac...
-
i lost data Closed
Hello, i had a file with some data and one of my kids entered this file and changed evrthing and saved the data. and i need the old data. how can ...
-
Macro to insert a row after 6 rows and 45 rows Closed
Hi all, I'm new here and hope you guys can give me some advice and help to end my problem! I have a large data set containing "control values" a...
-
Macro Insert Headers after sorting Closed
Hi All, I have a spreadsheet that would contain a hundreds of thousands of invoices. But to simplify, I am more concerned about the following: H...
-
Update data records Closed
I have a specific range of cells in a column. For eg In sheet1 from D3 to D12 I keep on entering various alpha numberic code from 3 digit to 8 di...
-
copy row paste at the top of each page Closed
I need to copy a row, then paste it on the top row of multiple pages.
-
Validation Warning for repeating a number in a column Closed
Hello, I am using a spreadsheet that compares properties, within different grid squares. The column for grid references has numbers prefixed with t...
-
Excel : If value is in column A, then delete cell in column B Closed
Hello, This is what I want to do : Column A : value1 value2 value3 value4 value5 Column B : value1 value22 value33 value44 valu...
