The discussions
Trying to have the current date go into one cell (a1)
SolvedHello, I'm trying to 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 aut...
A strange range question ...
SolvedHi guys Im back with a new twist on one of my old problems. I had help earlier and one of you kind people hellped me out with a solution (thanks ag...
To identify repeated values
Hello, Please help with this issue. I have a list of players in column 1 and column 2. I would like to know, for instance how many times "Allan"(pl...
Is there a percentage formula!
Hello, Is there a percentage formula!!? e.g. If you enter a100 in a cell and that amount to appear 30% in one cell and 70% in another !! Thank y...
Highlight any dates that exceed a target date
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...
How to convert number in word in excel
how to convert number in word in Excel
Excel formula
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.
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 ...
Requesting formula in excel on if condition / date function
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
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...
Excel date function dd/mm/yyyy
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?
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
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
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
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....
Excel formula
Hello, I want the answer of this formula =IF(AND(L13
Adding a loop to macro to insert pictures
SolvedHello, 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...
Color coding variable pivot row label interior
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...
Excel assistance
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
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...
How to export data from different tabs in excel
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...
Change calculated to a hard date
SolvedI 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
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...
Macro creation
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
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
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....
If function with date
Hello, The concept is "If the days exceeds 30, the entire cell should be applied with some color or highlighted". Please respond Configurati...
Macro is not working
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
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...
Move data from one wrksheet to another using submit button
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
Hello, Can you please help me how to change number into word in Excel 2007 Configuration: Windows 8 / Chrome 40.0.2214.115
Transferring numbers to new worksheet automatically
SolvedHello, 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
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
how i can convert numircal in words
Macro to create tabs and populate from other worksheets
SolvedI already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current Set...
How to change the date of weekends in excel?
Hello, how to change the date of weekends in excel? pls help me.. thanks! Configuration: Windows XP / Internet Explorer 7.0
Macro to complete date form
Hello, I've got a spreadsheet with the Month in the top left "A5:B7" merged cells, the numerical days of the week (only Mon-Fri) on the right "L9:...
Calculate the number of days in any given year
Hello, I am trying to determine how many days in each year so I can calculate costs based upon the number of days. I have the following columns ...
How to insert rows in excel, when criteria is met ???
Sir, how to insert rows in excel, when criteria is met ??? Regards
How to transfer lines of txt from one sheet to another sheet?
SolvedHello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...
Vba to auto insert comment (by vlookup list) on cell data entry
I have built an accounting program three columns of which are named Vat Number, Debit, and Credit I need that each time I make an entry into any cel...
Transfer full row based on one column on multiple sheet to one
I am new to this, and never did codes for Excel. But I need help. I have a workbook with 4 tabs: Summary, Project A, Project B, Project C. On Project ...
Please help me these extremely difficult exercises
ClosedHello, Hello everyone, I have an exercise about if function in excel. Honestly, I did pretty well the previous assignments but this one is much com...
Covert numbers to words
Hello, how do we convert numbers into words in excel Configuration: Windows 7 / Chrome 40.0.2214.115
Convert numbers into word
How do we convert numbers into words format in excel
Repair excel files.
SolvedHello Experts, My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained ...
How to remove image with vb?
SolvedHello, I have everything working but removing the image before saving. The code is not working and not even sure where to place it. (using excel...
Code to copy data from one sheet and pasting into specific cells
Hi all, I have two worksheets. Namely 'Worksheet Values' and 'Worksheet Final'. 'Worksheet Values' contains all the data that I want to insert in...
Conditional formatting based on another cell; apply to rows
SolvedHello, I have two columns. Column A is for expiration dates, and Column B has a drop down menu indicating the status of an request (eg, pending, a...
Moving data from one sheet to another
Hello, I need to move a date if 21 days great than today Configuration: Windows 7 / Internet Explorer 10.0
