The discussions
Popup window when the excel file is saved/updated
Hello, I have an Excel file which is used by multiple users (saved on the network drive). They can only open the file as read-only. I'm looking fo...
Macro which should add a new worksheet
Hi guys, I have a question So I have a VBA Code which pretty much does everything it should. I can choose the CSV-Files, it deletes the columns th...
If formula help
SolvedHello, I am needing a formula like this =IF(OR(B4="apple",B4="Banana",B4="carrot"),"yes","no") but if the cell B4 is blank. I need a blank " ". ...
Creating a payback calculator with rate change
SolvedHey, having a bit of trouble, appreciate any help. I am trying to create a payback calculator where you input: Initial Investment Rebates Annual...
Copy data from one sheet to another based on condition using vba
Hello, Please i need help on extracting some data in excel. The data looks like this A B C D 1 3.45 2.34 3.6...
Macros help in excel
Hi, I was wondering if anyone could help me please? I would like to be able to use a macro to assist in me an excel spreadsheet. The task i...
Notice to purge data
Hello - Any information or help will be appreciated. Is there a formula that can alert data entry personnel when a particular entry, needs to b...
Conditional formatting based on data in another cell
SolvedHello, I would appreciate any help you can offer on the following scenario. I tried conditional formatting, however, the columns in Row E either all...
Please i need and answer about this
Hello, I want to translate this number 1647984643 into word or sentence i hope you can lightend me Configuration: Windows 7 / Chrome 51.0.2704....
Excel has file big size
SolvedHello, Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of th...
Copy a cell in the same row as a matched cell on a sheet2
Hey, Let me try and explain this better. I need to match A2 with Sheet2!A:A, but the value I need is a cell on Sheet2 in the same row as the mat...
Move rows of spreadsheet to second spreadsheet
Good Morning- I am keeping a spreadsheet of my projects. I want to keep the information for tracking and statistics later. Is there a way to move...
Macro to copy cells and save multiple entries
Hello, I am looking to create a macro (never done this before). Here is what I want it to do. 1) I have a master store name excel file (for exampl...
Conditional formating: formula cell text change color
SolvedHello, How do I get Text in a Cell to Change from Black to White, based on data? The cell already contains a formula to extract data from elsew...
Colour in spreadsheets that are formulated
Hello, I would like to know how to do the following on excel Same sheet with the amount of calls taken in number form goes into a cell then the ...
How to highlight the extra data in column
Hello, I want to get the extra data in a column when compared to other column. For Ex: If ColumnA has following data 1 2 2 3 5 & column B...
Transfer between excel worksheets
Hello, I would like to be able to transfer an entire row of attendance of students when it hits zero for attendance to another sheet or at the bot...
Automatically transferring rows of data between sheets
Hello, I am creating an excel spreadsheet that will be used to keep track of my organization's board member and supporter attendance at events. I ...
Date format *dd/mm/yyyy and dd/mm/yyyy
LS, Hello, Please help me with the following question; What is the difference between the format dd/mm/yyyy and *dd/mm/yyyy when uploading dates an...
Conditional formatting when a cell says "no"
SolvedHello, I need your expertise in conditional formatting. I have a worksheet that where i have hidden a column ("J") with just Yes and No on it. W...
If a cell has a certain value after certain date, color the row
SolvedHello, I'm working with deadlines, and projects need to progress from one stage to another by specific dates. I have 3 deadlines: A: Create BR...
Matching 2 values from one spreadsheet
SolvedHello, I have 2 spreadsheets.. first has 3 columns id, date, time value second volume with id header across of date would like to populat...
Change text in cell if other cells have any values
SolvedHello, I am working on a spreadsheet where I have 5 important columns. Column B is the "Completed" category. Columns C, D, E & F will all contain ...
How to count how many times a number appears in a spreadsheet?
SolvedHey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadshe...
Conditional formatting from other spreadsheet
Hello, Every day I update my excel spreadsheet based on customer demand. My boss uses a separate spreadsheet that pulls from mine. He wants to be ...
Automatically copy data from one sheet to another
I have read numerous articles about this and none have really solved my issue. I decided to post my own specific question. I have an excel workboo...
Removing false statement
Hello, I would like to remove a FALSE statement, want it to show nothing. My formula is as follow =IF(A23=1,G23,IF(A23=2,G23,IF(A23=3,G23,IF(A23...
Excel formula
SolvedHello, I am having trouble getting the right formula for: Column O is equal to column N if Column C contains the text "Mastercard." Nothing I'...
Send email when a cell changed in excel
Hello, hi guys, straight off, im stupid, extremely stupid so if you can help me please keep it simple as im barely technical at all :) anyways, im...
Recover corrupted pdf files
SolvedHello, I'm trying to recover a folder with some critical data that was damaged or corrupted, likely by a virus. It’s a 10GB folder that contains P...
Creating multiple lists from one master data table
Hello, I am trying to create a master data tab where expenses will get coded. I need each subsequent tab to be for a specific account and that ta...
How do i extract specific data from a cell in excel?
Hello, what function would I use to extract just the city name from the cells below?...thanks! 6211 E Holmes Rd ,, ,Memphis, TN 381418310, U.S.A. ...
Changed pdf to word, now all documents are gibberish
Hello, I changed one of my documents with "Open with" from PDF to word. I has now changed all my word documents to gibberish. How do I get it to ...
Change color of text or cell if the value entered is same
Hi! Can someone please share me how to change font or cell color if a value entered in a cell is already selected before. Ex. I wanted the font or...
Ms word 2007 files converted in to ms word 2003
Plz help me. M research scholar I have created my file in ms word 2007 but after few hours I have opened then I have seen my all files have converted ...
Comparing the two names respective of upper & lowercases letters
SolvedHello, here am trying to know something about the compare of 2 names in excel below is my format Http:CCM_net_C2E http:cCM_Net_c2E i have ...
Macro for inserting multiple rows between data
Hello, I need a macro that will insert 45 new blank rows between each existing row that I have now. can someone help me with this? Also, I have li...
Count if it is monday?
Hey all; I could not manage to work this out after 1 day research and try my chance here. I have dates on column A and numbers (both positive,negat...
Transferring data by row onto new tab unpaid and paid sales
Hi I am new to this forum. I have an excel spreadsheet which looks like this: Date Description Invoice Destination Amount Status ...
Using if statement to add 1 to total
Hello, I am trying to get a formula to add + 1 to a total cell based on the word typed. Example : If I type the word Duty in cells B3:B18 then ad...
Totaling amount from 1st tab depending on another column states
Hello, I have 2 worksheet, 1st worksheet shows 2 columns A1 ($0.00) and A2 (names). 2nd worksheet I want it to calculate if the name column A2 sta...
How to populate data to another tab
Hey there, If anyone could please spare a moment to help me with this, it would be much appreciated, more than you will know ! What I want to d...
Comparing 2 columns from 2 different spreadsheets
SolvedHello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer numbers Spreadsheet 2...
Excel question
Hello, i want to calculate distinction,first,second and third divisions Configuration: Windows 7 / Firefox 13.0
Copy 10 sheets (along with data) into new 10 sheet in same excel
Hello, I have an Excel which contains 10 Sheets with data.., Once a Go button is Clicked it new 10 sheets should be opened in same Workbook along ...
Set a conditional year end date outcomes
Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31/201...
Macro code
Hi there. So I have a question. I want to create a macro that makes uses the list of name in cells B6:B60, E6:E60, B66:B119, and F6:F74 to make a tab ...
Compare two columns input value from another
SolvedHello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we will ca...
Highlight cell if another cell contains any text
SolvedHello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...
Microsoft outlook microsoft exchange is unavailable
Hello, I could not open Microsoft outlook at all, the error message a following: The connection to Microsoft exchange is unavailable. Outlook mu...
