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
Subscribe To Our Newsletter!
DON'T MISS
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Install a VPN
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account