The discussions
Conditional formatting on an entire row
SolvedHello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12
My email have been deleting without reading
SolvedHello, I keep getting emails saying that some emails have been deleted without being read. The message below is typical of what I am seeing is: ...
Issue with date and text in if formula
ClosedHello, I'm trying to write a function for a cell which refers to different descriptions in one column - where it only should combine some descript...
Receiving an error message for vba
Hello, I was given a workbook to fix with 5 different sheets. The Summary sheet has a button to "Refresh Equipment List" which is supposed to ...
Error message - pdf wasn't decoded
Hello, when i try to send pdf as attachment in email - when the receipt opens the mail he gets an error that pdf was not decoded. i am sending th...
Where is the downloaded software?
Just downloaded Publisher, but can't find it.
How to sum row color
Hello, Please help us with how to sum numbers marked in different colors. Configuration: Windows 7 / Chrome 48.0.2564.116
Simple way in excel to copy data
Greetings, Can anyone help me. I am working on a huge project and looking for a simple way in Excel to copy data. If I have a master document w...
Copy rows from sheet 1 to sheet 2 if rule is met
SolvedHi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in B2:B12948 ...
Vsb error autogenerate worksheet from list
Hello, So I have an excel that has mutiple worksheets "2016 Census" "Tracker Template" What I did was use a code to automatically pull data f...
How do io open 2 different excel sheets simultaneously
Hello, How do I open 2 different excel sheets simultaneously. Thanks
Adding a value to a cell that contains text
Hello, Can someone please help me? I want my cell to have the word FREE written in it BUT I also want that cell to represent 0.00$ when I add it to ...
Compare two spreadsheets to return a single value
ClosedHello, I'm comparing two spreadsheets and I want to see if items appears on both spreadsheets. I've tried index match but I none of my columns hav...
Only partial return of search for copy and paste rows
Hello, I have a workbook with multiple worksheets with same format that has data in A4:K15 that I would like to search by any field and have the r...
Activate cells after data entry @a1 or cell 1
Hello Guys, Would you mind to help me on how to disable the rest of the cells unless upon inputting data on the first blank cell. (e.g., I input cha...
Vba macro help
ClosedSo i have multiple sheets with data and i was wondering if a Macro could be written to pick up values from one excel file and color the cell in anothe...
Outlook repair tool for .pst files
Solved/ClosedHello everyone, I'm not really sure what happened, but this morning, one of my pst-files was missing and for another I got the error: "Errors have ...
Damaged .pst file, how to repair???
ClosedHi everyone, Does anyone know the best way of repairing a 0.5GB .pst file? I had tried the normal ways through outlook and was just wondering if anyb...
If a cell a contains x then display cell b value
ClosedHello, How to get the cell B value when Call A1 is X the display what ever is there in Cell B1 as in Cell C. If not the leave the column blank or ...
Use date to return value of 1
Hi, can anyone tell me how to use the entry of a date field to return a value of 1 in Excel? I need to tabulate items where a date is the entered reco...
Formula
SolvedHi please I am looking for a formula to get difference between 2 sheets example sheet 1 sheet 2 ndc quantity nd...
How to convert date of birth in word
Dear Sir, With reference to the above mentioned subject, I want the solution in excel for change the date of birth in words. For Example :- if I wi...
2 rows into one in excel
ClosedHello, I would like to sort 2 rows of excel into one A B 2 4 5 6 To C 2 4 5 6
Need cell value copy to defferent -2 work sheets within a excel
SolvedHello, hi all i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a excel...
Excel / comparing data
Hello, my name is Malwina. I would very much appreciate your help, please. I was trying to compare the spreadsheets but really have no idea ho...
Transfer data from an old report to a new one
Good evening everyone. I'm trying to develop a macro that will compare data between two versions of the same report. The old file, contains a list o...
Identify value "o/b", if true search column for "/"
Hello, Im trying to make a break list to be active on a daily basis in a workplace, currently it works immacutely but i have hit a speedbump in co...
Pdf attached to email won't open
Hello, When I receive email with a PDF attachment, they do not have Adobe icon but do have the .pdf extension. If I try to open it, the Windows Medi...
Excel function to check neighbour cells match for all
SolvedHi, I need to check if (each) cell in column A is having a match in column B, Example as below: Column A is phone numbers list, column B is mes...
How to map 2 different columns in from 2 different excel files?
Dear All, I am trying to Map values from 2 different columns from 2 different excel files. I am unsure as how to invoke the sheets and print the re...
Multiple if functions
Hello, I am trying to built a multiple If condition. I want excel to search for 2 words in an array "Lose" and "Tie". If it finds "Lose" then i want r...
A1 draws amount from other cells by live date.
I'm stumped. I need the value in cell A1 to change automatically the first of each month. Column A2:A13 has dates for the first day of Jan through D...
Sum of the total times a column has a certain text
Hello, I am trying to find the total amount of times that a certain text appears in a column. From A2:A689 I am trying to find the amount of times...
To change cell value automatically
SolvedHello everyone here, this is my first question in this forum. In Excel 2013, If I type 1 in cell A1, then it should automatically change as Apple in s...
Help with if statement / vlookup (i think)
Solved/ClosedI work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decisi...
Help w/if statement
SolvedHello, Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return th...
Multiple options for if in a drop down menu
hello, i trying to make a drop down list in which u can select food and it has a price so in the drop down list there is a3,a4 AND a5(in the drop do...
Searching for a specific values on multiple sheets using macro
Hello, I have multiple different sheets, for example I have 4 sheets now. first sheet,second sheet, third sheet, forth sheet. each sheet has 5 ...
Ms office 2010 publisher download
Your link http://ccm.net/download/download-1620-microsoft-office-publisher indicates the download is in English, however when I download it, it's Fren...
Frequent missing emails inbox (blank)
SolvedHello, Please assist me , why my email in my inbox goes missing, this is my 5th time it happen again. Once my inbox emails goes blank, I need to s...
Macro help
SolvedGreetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one sh...
The perpetual question: auto-populating sheets based on criteria
Hello, I realize this question has been asked in a million iterations, but my understanding of programming is so nonexistent that I can't confiden...
Vba single click to get current date
SolvedHello, I'm brand new to VBA and the code that bhargav posted on Feb 6, 2013 10:48AM worked perfectly to get current time in a range of cells with ...
Macro to create, name and fill new sheets based data set
Sorry, I realize this question gets asked all the time. What I'm looking for seems different enough that I will need some specific help. The post righ...
Moving view, not moving selection
Hi there :-) Is there a way to keep the selection, e.g. multiple cells, but move the view to the top of the sheet? Of course another way than scrol...
How do i get a value in a cell based on another cell
Hi, How can I get excel to fill in some information for me? I want the value in column A to be filled in based on the value in either column B ...
How to compare two excel sheets with varying data
SolvedHello, Before I start let me just say Thanks in advance. So I am looking for an ongoing updated answer. Every 3 months we receive a new price lis...
I need to copy the hyper link as well as the text in the followi
ClosedI am new to VBA, This code looks in one sheet and pastes it in a new sheet, but does not copy Hyper link, can this be done. Range(wsO.Cells(1, 1...
How to return to only one line for each mail
Every mail in outlook comes with 2 lines. to open mail I click oj the second (the one with closed envelope). To delete this mail I need to click twice...
Ranking sorting problem
Hello I would appreciate some help on the following formula problem. I have a game where some teams have wins, losses and draws. My problem arises wh...