The discussions
Pdf file saves with a microsoft word icon
Hello, My Dell OptiPlex 3020 is not opening PDF files correctly. If I try to open a PDF file and then save it to the desktop, it saves with a Mic...
Totaling hours by code
SolvedI'm looking for some excel help please :) I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is enter...
Change data status in one same column
SolvedHello, i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired' when it due. ...
Link the data to another worksheet.. with specific names
Hello, good day. i want to ask how can i use macro to make one click button to transfer data to another form like payslip.. i manually copy p...
Conditional formatting colour cells
Hi All, Its my First topic, am looking forward for help me. In my Excel file columns : 1. Sending letter Date 2. duration time 3. expected date...
If statement -
SolvedHello, I'm attempting to create an IF statement. IF a type = 1 then add the total of a corresponding cell to the total amount. =SUM(IF(B24:B51="1...
Problem with word file, showing boxes in all over the pages
Hello, pliz can anyone help me. in my all word file boxeses emerged to the background of what I was typing. I tried to open a blank new page but the...
Boxes are appearing on my word file
Hello, , pliz can anyone help me. When I am opening word file, then square boxes are shown to the background of what I was typing. I tried to ope...
How to create auto sheets and give same headings for all
Hello, I have created one macro, by clicking on a button there are multiple sheets created automatically and naming the sheets with the calendar day...
Lookup across whole workbook (muliple sheets)
SolvedHello, I would need your help with my problem in MS Excel. Here is the description: 1. I have an Excel workbook containing multiple sheets (ca. ...
Quantity surveying
what tape of software is simple and easy to estimate required materials and their cost for building construction.
Autofill master sheet
SolvedI am trying to automatically fill in a table (with whole rows from A-N) on a master sheet (sheet 1) based on whether the data in column H of the table...
Macros write a macro from sheet 1 to copy data when selected
Good Afternoon- I am new to writing Macros, and would appreciate some help. I want to write a macro from sheet 1 to copy data when selected to shee...
Deleting data in 7 different sheets before i update workbook.
Sub Delete() ' ' Macro4 Macro ' Delete contents in attorney tabs ' ' Keyboard Shortcut: Option+Cmd+Shift+D ' Dim lRow As Long Dim i As L...
If cell has text then go to sheet x and insert
Hello, I need a formula that can insert text on another sheet. So sheet 1 A1 has text then take that text insert it into Sheet 2 line "to be determ...
Copy , concatenate and finally paste
Hello, I have a problem that is: Firstly i have to copy the same cell (value, anything or blank) from two different Excel and concatenate them a...
How to show an empty cell if =counta counts 0?
Hello, Iam having a bad time, I want to use =COUNTA but I hate the look of all the zeros when in all the empty rows that I didn't use yet, anyway, i...
Subtracting the date of admission to the current date
GOod am, i just want to ask how will i create a formula as follows on the same excel, 1. subtracting the date of admission to the current date 2....
Convert 12.01.2015 into words
Hello, please convert 12.01.2015 into words System Configuration: System Configuration: Windows / Chrome 55.0.2883.87
Macro to paste special values
Hi All, Am new to macro, i have an excell file in which column A is having dates with formula....for example cell A1 is stored with 01/1/2017 and c...
If cell contains a certain text, add the numbers of another cell
SolvedHello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket , C2=30$...
Need formula for comparing differences of two columns.
SolvedColumn A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I reali...
Opening 602 spreadsheets with window 10 excel. help
Hello, I have used 602 Office suite for several years and now I have 10 years of spread sheets that I cannot open with windows 10. Do I have to purch...
Stripping out some text form a larger string
Hi All, I have very basic skills in excel - I'm trying to work through some data, and I have a long string of text - which has a common word "Naam:" ...
Copy activechart properties to cell (from graphics)
SolvedHello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline, display...
Desktop reminder with excel sheet and vba formula need. please s
desktop reminder with excel sheet and formula need please support.
Copying conditional formatting with formulas accross rows
SolvedHello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Exam...
Short cut keys not working
Keyboard shortcut keys not working in ms word example ctrl+A,ctrl+ A etc.
Multiple if formula in one cell, date comparison
SolvedHello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
Why sum of some numbers is 0
Hello, I am trying to find the sum of some numbers in a column in a maxro book. I make the formula of sum and the sum appears 0. In fakt, althout th...
Convert number to assigned names and joined with another names
SolvedHello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell...
Conditional formatting excel 2013 based on content in other cell
Hello, I have a spreadsheet with columns that have targets and results next to each other. If the target is reached (=) or exceeded (>) I want the r...
If date
ClosedHello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
Macro for merging data from multiple sheets
SolvedHello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...
How to convert date into text.
SolvedHello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...
Updating master sheet with most recent data
Hello, I'm curious if anyone knows of a way to have a master sheet/summary sheet only update with the most recent data entered on a different sheet?...
Copy files from google spreadsheet to excel
Good Day partners How do I copy files from Google Spreadsheet to Excell, or How do I merger files from Google SPreadsheets
Copy row and it's contents based on value in x cell.
Hi everyone, this is my first post so I hope I'll explain myself clearly! I have a spreadsheet with the following content: (Column I (in yel...
If formula needed
Hello, I need a formula that IF there is any data/text in the cell it will EQUAL another cell, BUT... I want the cell with the formula to display th...
Statement that returns pass, fail, ""
Hello, Wanting to test row of numbers to a certain number and return pass, fail, or blank. =IF(AND(X7
Installation licence is expiring
Hi When turning on my Lapt-to a message is telling me to renew my licence ans is sking for cetsin numbers from the original disks by the 01/02/2017 a...
Excel formula
Hello sir, . But its can't working why i dont know! Please find my attachedments. Regards, Bicky Das, bickydas00@gmail.com
Function button: unhide cells between values and hide all other
SolvedHello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several sections. What ...
Cell content move with vba code
I have a workbook that we create service tickets from. The main sheet is used to enter information about the job. When complete I have a button that n...
How do you have multiple out comes for the same if condition in
Hello, I have a condition in my file such that =IF(C5=C4,D3+1,D5=1 ->>>> trying to add this andD4= D3+1) Basically this what I want to happen C...
Recovery of unsaved word/open office document
I recently had my computer worked on at Geek Squad because it crashed on me. After they restored my computer, they were unable to reinstall my Office ...
Conditional formatting based on another cell?
Hi everyone! I'm trying to finish my financial sheet to work out where I am for this year. I need it so that when I type in the word "yes", It shows t...
Formula 1,2,3 division
Hello, sir Plz notice the formula =if(cell address >55%,"1st",if(cell address >50%,"2nd",if(cell address >45%,"3rd","Fall"))) is the correct answer? ...
Can't open microsoft office word
Hello, i'm using Word 2007. Yesterday I opened a file and it kept loading and loading but didn't open. Every files is the same. Then a notification po...
Automatically transfer data from one sheet to another
SolvedHello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items base...
