Excel Forum
-
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...
-
highlight dates with conditional formating Closed
CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5= 09-JAN-2013, A6= 10-JAN-2013 Here a1 and a2 has difference of 1 day so...
-
Exporting selected cells to another workbook selected cells Closed
Hello, I am a College Student and in my down time I've been messing around with vba coding. I am thinking about making a macro that will automatica...
-
Adding columns containing text Closed
I have a basic sheet and cell a4 is a total of jobs done. I want to add +1 to cell a4 every time I enter any text in b6:b1000 to tally work completed...
-
Excel reminder Closed
Hello...I need to create a reminder for dates in B2 that is 3 years after the date in B2. To have B3 highlight with REVIEW would be great. I have a fo...
-
Command button to post data from one sheet to another one Closed
Hello, I would be very grateful if some one van help me! I have excel table with 10 columns (from A-J) in sheet1. I fill data in the table and in...
-
VBA code to update master excel sheet from source excel sheet Closed
Please help me with a vba code to update redhighlighted cells in master file for all documents from source file please find links for the files ...
-
Excel, Automatically transfering data and filtering Closed
How do I transfer a document into another document automatically by filtering specific numbers or words out?
-
Formula to calculate monthly contract value between date Closed
Hi, Would appreciate helps here. I need to calculate monthly contract value based on contract start date and finish date. Contract value: 100,0...
-
I cant open my exel .slxs files Solved/Closed
Hello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...
-
Enter Start time and End Time Closed
Hi! I'm trying to make a tracker using excel wherein we can calculate the minutes used in each task that we make. I am planning to have the start time...
-
VBA code for document controll & progress monitoring Closed
Hi... Good day! I am a project control engineer dealing with almost 1500 documents/drawings from my engineering sub contractor. Each documen...
-
Enter Time by clicking on a cell Solved/Closed
Hello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...
-
conditional formatting with an exception Closed
Hello, Im trying to conditionally format the results in I19:I44 for all duplicates although I want the first one to be an exception. How do I sp...
