Excel Forum
-
Highlight any dates that exceed a target date Closed
Hello, Wonder if someone can help me, I have a sheet that i want to calculate and highlight if one date is beyond another then highlight it red IF...
-
i am trying to add a calender to excel but getting Compile error Closed
Hello, This is the code i am using but getting Compile error can't find project or library. Private Sub Calendar1_Click() ActiveCell.Valu...
-
Updating master sheet, then automatically update other sheet Closed
Hello, Can you please help I have 6 worksheet in my Workbook, so I'm trying to come up with a way in which I can update master sheet, then it auto...
-
Compare Common names Closed
Hello, I have a excel sheet in which I want to highlight any time there is a common name between the two columns. the problem is naming is differe...
-
how to convert number in word in excel Closed
how to convert number in word in Excel
-
excel formula Closed
Hello, I'm looking for a simple formula to convert numbers in to words in Excel 2007. with example. Configuration: Windows 7 / Internet Explo...
-
Sheet One Items Transferred to Sheet Two. Closed
I have few items in sheet one and want to transfer to sheet two. Please help me.. Sheet 1 consist of:- S.no Tanker Date Voucher ...
-
scroll lock Closed
Hello, Don't have a scroll lock key and no F14 key. I unlocked scroll on Excel Sheet and arrows are still scrolling and do not navigate side to s...
-
Ops Mgr Closed
im trying have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to automatically up...
-
Copying Data from One Excel Workbook To Another Closed
Hello, Newbie here, on my organization my reportees are sending me a report on a daily basis, the pain is to collate each of these sheets onto 1...
-
requesting Formula in excel on if condition / date function Closed
Hello, I need the Formula in Excel sheet If A2 is having a date. I need the date on C2 After 2 days. If the second day is Saturday it should b...
-
compare data in two different excel files Closed
Hi, How to write a macro to compare data in one excel file with data in other excel file i.e., cell wise for ex: I have one file with two columns...
-
Drop down list treated as a selection variable Closed
Hello, I am trying to see if this is possible and if so how: Problem: Make the same "selection variable" ,i.e. word or number chosen from the dro...
-
Excel Date Function dd/mm/yyyy Closed
I have a column in excel as dd/mm/yyyy with my date function set as English (US) however excel is sometimes picking up some dates as mm/dd/yyyy and ot...
-
Excel 2011 not recognizing keyboard shortcuts? Closed
Hello, I have been given an assignment which gives me quite specific instruction on Excel however while things like command+C works the more complic...
-
For AND condition Closed
Hello, ANd condition on two different columns - what is the solution please Configuration: Windows 7 / Chrome 41.0.2272.76
-
Copy data to new sheet.. more tricky than I imagined Closed
Hi all, Could someone please help me out with this? I've tried looking at other similar questions and solutions but as an Excel beginner I couldn'...
-
Compare on a condition and Highlight the Difference Closed
Hello, I have a requirement to compare two different tabs on same sheet and display the difference either by highlighting the rows or add a comment....
-
I want to label specific cells with numbers in a sequence Closed
Hello, I am new to VB and trying to write a script that has the below functionality, could anyone help me get started or point me in the right dir...
-
Excel formula Closed
Hello, I want the answer of this formula =IF(AND(L13
-
adding a loop to macro to insert pictures Solved/Closed
Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
-
I want to label specific cells with numbers in a sequence Closed
Hello, I am trying to write a script that has the below functionality: - From top of sheet, check cells with a value in a specific row - Replac...
-
Color Coding variable Pivot Row Label Interior Closed
Hello All I have a coding problem I have tried numerous ways to solve with no success. I have a macro generating a pivot table for weekly data tha...
-
Problem with adding and updating comments from value in VBA Closed
Hello and Greetings, Thank you for taking the time to read my post; I do appreciate it. I have been struggling with a trying to write a specific VB...
-
Entering a range of data in an IF formula Closed
Hello, I am trying to write a formula where: if any of the values in colum B are equal to the values in column M, then an email address in N1 will po...
-
using if condition in excel sheet. Closed
Hello, I need the Formula in Excel sheet If A2 is having a date. I need the date on C2 After 2 days. If the second day is Saturday it should b...
-
excel assistance Closed
Hello, Can i PLEASE get some help with this problem? 5KM or more and less than 15km, the cost will be 5... Thanks to everyone in advance
-
transfer 5000 records to a new spreadsheets with 50 records in e Closed
I have a excel file which contains 5000 recores, i want to transfer 5000 records to a new spreadsheets with 50 records in each new spreadsheets i.e to...
-
Help in Duplicating Row Info based on adjoining Cell Response Closed
Hello, I am seeking assistance in determining the best way to complete a worksheet wherein I need to create a new row which duplicates some inform...
-
A Macro to repopulate a row into a new row based on the response Closed
Hello, I would like a macro that would repopulate a new row based on the results of a cell within that row. Example: Project A Complete...
-
How to export data from different tabs in Excel Closed
Hi, I need help with a spreadsheet that has 4 tabs. My tabs are: Manager, Analyst_1, Analyst_2 and Analyst_3. I need a formula that can t...
-
VBA code to update excel comments when the cell value changes Closed
I have a workbook with several worksheet tabs. One of the worksheet tab contains a column of percentages (that are composed of a VLookup formula from ...
-
Change calculated to a hard date Solved/Closed
I used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...
-
VBA : Copy "Pivot like layout" to "data dump layout" data Closed
Hello, I am looking for a solution to my challenge. I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column...
-
Create a search box and then copy to new worksheet. Please help Closed
Hello, this is what I have so far by searching online and it is not working :( It keeps sending me a message " Variable not defined " Please help me ...
-
Macro creation Closed
I need to combine data in two different Excel worksheets. 1. list with user names and their ids and groups and to input this data to the list with j...
-
Excel-Changing calculated dates to "hard" dates Closed
Hello, I used a simple +1 formula to create dates in column A. Now that I have the dates, I want to make them "hard" dates so they don't change eve...
-
Changing cell color with either conditional formatting or macro Closed
Excel 2003 or 2007, 3 preferred. I have a column 'E' that contains either 2 or 4 digit text codes (MR, SP, BA SC, EU WO, etc), up to 50 unique codes....
-
Auto Fill Form? Closed
Hello, I have a spreadsheet on which I have formulas for all my recipes. I have a column that I enter the amount of each recipe I want to mix. I h...
-
If function with date Closed
Hello, The concept is "If the days exceeds 30, the entire cell should be applied with some color or highlighted". Please respond Configurati...
-
VBA code to copy "Pivot like layout" to "data dump layout" d Closed
Hello, I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column Name 3 - Column Name 4 Johnny - 5 - 0 - 0 - 4 ...
-
Macro is not working Closed
Hello, The first time the macro worked, I was so happy! (I used it once) Now is not working anymore, no idea why. Can someone help me? I rea...
-
Filter according to 'typed' value Closed
Hello, I need an autofilter to change according to a 'typed' value on another worksheet. I have found this code, which works when the typed val...
-
conditional replication of cell data Closed
I am using Excel 2013 I am using a spreadsheet for a TO DO list. The column headings are: "Item" (with rows numbered from 1, 2....) "Task Descri...
-
move data from one wrksheet to another using submit button Closed
hello im working on a project and ive create a workbook in which I place data into a worksheet known as "processing" which serves as a main page in w...
-
changing of number into word Closed
Hello, Can you please help me how to change number into word in Excel 2007 Configuration: Windows 8 / Chrome 40.0.2214.115
-
Transpose convert columns to rows macro for excel Closed
Issue I have huge data in a single column & each data group is seprated by single empty cell For Example : Company Name 1 Address ...
-
Transferring numbers to new worksheet automatically Solved/Closed
Hello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...
-
Notification Closed
Hello, I was wondering if it is possible to create a popup when a user has a shared excel spreadsheet open preventing others from using it. The popup ...
-
convert number into words Closed
how i can convert numircal in words
