Excel Forum
-
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...
-
Conditional Formatting - based on a formula and named cells [Closed]
Hello, I have been struggling to get a simple formula to work in Excel 2013. My objective is to compare budget numbers to actual and if we are wit...
-
Trying to write a code to insert a blank row above a cell value [Solved/Closed]
I am trying to write a code that will auto insert a blank row above a certain cell value ie: existing: Column G 5 10 20 22 999 2 22 55...
-
Macro for deleting a row with specific criteria in a cell [Closed]
Hello, I've got a spreadsheet with many rows and columns, and I'd like to delete specific rows based on criteria I pick. For example, if my criteri...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received