Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
Formula to add 1 with IF statement Solved/Closed
Hi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I want...
-
Forgot cyber cafe pro's admin username and password Solved/Closed
please can somebody help me. after installing cyber cafe pro 5 for just 4 machines, I completely forgot the admin username and so I decided to unins...
-
how to remove mark up area in microsoft word 2007 Solved/Closed
Hello, How to remove mark up area in word file Configuration: Windows 7 / Firefox 29.0
-
Not Pasting values in Excel file Solved/Closed
Hello, I would like to know that I have a Excel Macro Enabled File. it has macros, sheet vba code, modules and user forms code and no merging...
-
Coping formulas to next row using a macro Solved/Closed
Hello, I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original row. I...
-
add a restriction to a column Solved/Closed
Hello, Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should st...
-
Conditional Formatting through Macro Solved/Closed
Hello, I would like to request that how Conditional Formatting would apply through Macro and the Conditions are Range is E11 to E510 if Colum...
-
Sum values from one column if another column equals x Solved/Closed
Hello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried...
-
Transfer worksheet Solved/Closed
Hello, How can I transfer an excel worksheet into another excel file. And when transferred I won't have to modify anything. Right now i'm cutting a...
-
EXCEL FORMULA Solved/Closed
Hello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks
-
Scroll mouse in ListBox Solved/Closed
Hello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...
-
Copy a 'Template' sheet onto multiple other sheets Solved/Closed
Hello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...
-
Add Sheets to ComboBox Solved/Closed
Hello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...
-
conditional formatting on multiple criteria Solved/Closed
hi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...
-
Comparing columns in Excel 2010 Solved/Closed
Hello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...
-
Set Rows Height also Exception in Range Solved/Closed
Hello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...
-
Adobe Reader Error 0:104 Solved/Closed
One of my users is having a strange issue. When she tries to open a PDF file from within Internet Explorer 8 using Adobe Acrobat Reader X (latest ver...
-
Comparing Rows on two worksheets and pull data into a new sheet Solved/Closed
My requirement is following: I need to compare Column A, B and C of worksheet 1 to column A, B and C of Worksheet 2 If Above condition is met then I...
-
Remove (Shape) Straight Line Solved/Closed
Hello I would like to request how to remove straight line shape through vba It was made through the following vba code Sub Str_line() ActiveSh...
-
Home Button Solved/Closed
Hello, I would like to request for the Macro which always take to "Sheet1" and also deactivated at "Sheet1" Thanks & Regards Configuration: ...
-
Next and Previous Button and De-Activate at Last Sheet Solved/Closed
Hello, I would like to request to create a button on Sheet that will click which goes to next sheet and this button also de-activate when it g...
-
A macro to create new spreadsheet and copy data Solved/Closed
Hello, I m a University student and currently learning VBA programming. I have a VBA coursework where i have a file with 63 sheets. is any macro w...
-
Showing the $ value difference Solved/Closed
Hello, I am using Excel 2016.. and need some help. I am doing a budgeting sheet and cant figure out how to do the following; Column A - Budget $ ...
-
Tell excel where to look Solved/Closed
Hello, I am trying to make a cell return a word when you tell it which cell to look in for that word. If i type J2 in a box i want a cell to then l...
-
Excel: If Date =, then enter a value Solved/Closed
I am using this formula and it works well: =IF(A8=DATE(2015,3,27),"1","--") How do I now create a string to check a number of dates (company holid...
-
Adding two non-adjacent cells (number and text) Solved/Closed
Hello, I seem to be having a problem with a nested IF(statement) I am on a separate worksheet that I use to calculate my formulas for my summary page....
-
Drawback of Copy and Clear code Solved/Closed
Hello, I have requested that please solve this issued if it could be solved. I have found major drawback (May be I am wrong) in the code of Copy ...
-
how to extract target value from other cell Solved/Closed
Hello, I would like to request that Suppose this line of code is working for Column B MsgBox "You entered is Invalid" this will show the m...
-
excel is automatically changing dates to a numeric code Solved/Closed
Hello, I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlightin...
-
Protecting your formulas in multiple worksheets Solved/Closed
Hello everyone, thank you in advance for any help I receive with is question. I have multiple worksheets in a workbook that have formulas in them b...
-
Fix The Code Solved/Closed
Hello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...
-
Date format changes when editing it Solved/Closed
Hi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...
-
Copying entries from multiple sheets to new sheet, then summing Solved/Closed
I run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...
-
Merge two macros of 2 diffrent workbooks Solved/Closed
Hello, I have 2 macros in 2 different workbook Currently i have to run 1 st macro(!st work book),then open 2nd macro workbook then have to run...
-
Remove or Clear Data Solved/Closed
Hello, I am grateful if this query be solved. If user Enter any value in C2 and also user enter "Best" or "Worst" in Cell D2, how it may clear th...
-
Multiple If in Data Validation Solved/Closed
Hello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2
-
Conditional copy of cells with corresponding values Solved/Closed
I have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but ...
-
Count formula (need help) Solved/Closed
Hello, everyone I want to thank you in advance because I know that excel can be frustrating. I hope this is an easy one I have the following data list...
-
Using IF function with dates Solved/Closed
Hello, I want to thank everyone for their time in advance. My problem is that I have a two cells/rows (78 & 87) in a column on this worksheet ...
-
Macros editing Solved/Closed
Hi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate wor...
-
refer only one column from named range Solved/Closed
Hello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...
-
Lookup Relevant Value from table Solved/Closed
Hello Team, I have a doubt, Consider the table : Event A B C 1 3020 3420 1324 2 3005 3405 5462 3 2990...
-
Copying dates in Excel Solved/Closed
Hello, I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in...
-
How can I restore corrupt .edb? Solved/Closed
Hello, I have an exchange server with a .edb that is in a dirty shutdown state. I have 2 storage groups. The second storage group will not mount d...
-
have changed shortcut Solved/Closed
now i can not open microsoft excel 2013
-
If statement Solved/Closed
Hi, Could you please tell me what I'm doing wrong in this statement? I can't find the issue :( =IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Pass...
-
Copy data from 1 workbook to another based on sheet tabs Solved/Closed
Good day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...
-
Link data from one cell to another Solved/Closed
Hello, ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. ...
-
Excel:Print one enlarged page to multiple pages Solved/Closed
Hello, Is it possible to print a enlarged page to multiple pages in excel? Configuration: Windows / Chrome 45.0.2454.101
-
Entering current time in specific cells Solved/Closed
Hi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (o...