The discussions
Cursor in excel does not work
I use Window 7 and Office 2010 with license. I bought in Bangkok, Thailand. This morning my cursor in excel has been changed from arrow to be thick...
Arrow cursor has been changed to cross and cannot move any cell
Hello, Please help me, I cannot use cursor in excel to move cell or drag. Thanks & Regards, Configuration: Windows 7 / Mozilla 11.0
Function formula date and text
SolvedGood day I am looking for help with a function formula PLEASE. Example Decleration Start Date 2016.02.17 Last inv_ Inventory_ Decl frm 1...
Spellnumber vba in excel
SolvedHello, I alreadly use spellnunber but the problem is it does not convert incorrect for my currency. Present Situation =SpellNumber(1,100,000) =...
Conditional formatting for 2 columns
Hi I am currently using conditional formatting on cells with dates, I have used cell value rules to highlight a pending date within 14 days and one...
If a cell a contains x then display cell b value - please advise
Hello Everyone, 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 b...
How to change oct 26,2015 to 26-10-15
Hello, Can any one help me to change Oct 26,2015 to 26-10-15 in a excel cell. Configuration: Windows 7 / Firefox 44.0
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 ...
