Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Formula with varying information need pasted multiple times Closed
Hello, I have what may be a simple issue. I have a spreadsheet that I need to apply a formula to in certain fields. One formula may need to be =...
-
Master Sheet to affect multiple sheets Closed
Hello, I am not sure how to explain this... I have a master sheet that has a list of all the names and grades for each row alphabetically. I have ...
-
how to find grade Closed
How find grade in excel, old tell me about the formula
-
Autopopulating multiple sheets from one main sheet Solved/Closed
Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...
-
How to sum a number from a range of cells, based on value Solved/Closed
Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....
-
Excel Closed
Hello, i have 5 numerical values in 5 columns but in same row and these 5 values need to be compare(e.g whether the five values lies between the t...
-
Subtracting numbers based on data in another cell Closed
I use a cell to show that a number has been deducted from an account. How can I make a subtraction of that amount form a total amount based on the inp...
-
Name check Closed
Hello, How to check the name with two cells. if any part name matched with second cell, it have to be show as TRUE. What formula for this?
-
Change the date format in Excel Closed
Hello, how I can chnage the format of 12-07-2003 to 2/22/2017 in excel 2010. Give the exact route inder
-
Self-generating sequenced number each time a sheet is opened Closed
How do you create a ( for example an invoice) self-generating sequencing number so every time an excel sheet is opened it will generate the new number...
-
Rank of numbers between specified range Solved/Closed
Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...
-
Paste x Times with Multiple Conditions Closed
Hello, I have no real knowledge of macro, but I think macro has a solution to my question I have data in Sheet1 and would like output in Shee...
-
Microsoft office 2013 Closed
Hello Dears, I have dawnloaded microsoft office 10 for windows 7. But, I couldn't install because I do not have product key. Would you please he...
-
How to download MS Office 2010 Closed
i can't download office 2010
-
Formatting cells based on certain criteria Solved/Closed
I want to make a cell change colour based on a number of different criteria: Cell A1 Has an incident date B1 Displays the date 14 days after the inc...
-
New Tab Copy Paste Closed
Hello, Being extremely new to VBA I am trying to create a macro that Creates a new worksheet and then have it copy and paste data into the new works...
-
save as in a macro Closed
Hi i am trying to save a copy of my workbook ie p&l report plus the date so i can save it each week, so far the macro i have will print all info and c...
-
How to use AutoFilter Macro in Excel Closed
Complete Macro Newb, so I apologize for my ignorance. I know what the problem is, I am just not sure how to fix it. I am filtering one spreadsheet...
-
Microsoft Windows 10 error saving PDFs on a USB drive Closed
Hi, I have had only problems and huge wasting of time since I installed MS Windows 10. Along with everyone I have spoken to, we are all utter...
-
Creating Macro for Auto Updating Multiple Workbooks Closed
Hello, I have been assigned a daunting task to create multiple reports(5) for specific clients in one workbook. This project is large as there ar...
-
Microsoft office home 2010 did not got the product key Closed
Hello, I'd downloaded Microsoft office home and business 2010 but i did not got the product key. please help me. Windows / Firefox 55.0
-
Attendance database Closed
I am trying to form a database where I can enter name and age of attendees, then check off per event for a whole year. From this list, I need to be ab...
-
Need help with a Macro that can copy and paste last 10 active da Closed
Hey Guys, I am a newbie to these Macros. I need desperate help from the EXPERTs. A few things I need for my macro are: 1. I have multiple d...
-
Attendance log help Closed
Hello, I have an attendance workbook I am working on and need to make different worksheets according to age. I have everything entered into the fi...
-
Copy paste rows from one sheet to another n times. Closed
Hello, I need help with Macros. I have my primary data(seeking production schedule) on sheet 1. I will have 100-120 rows Of data. Column A(no of ...
-
How to compare excel sheets Closed
Hello, Hi I'm stopping by to know if any one could help me to compare between to sheets in excel with some conditions. Like it finds somethin...
-
Find matching data in two worksheets and copy entire row Closed
I have one sheet that has about 350k rows and columns A-AW. Column Z contains phone numbers. I have a second sheet that only has phone numbers (about ...
-
product key Closed
i just downloaded Microsoft office 2010 and i can not locate the product key
-
SUM IFS function Solved/Closed
Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a co...
-
How to remove small squared on Word? Closed
Hello, Started to do a word document and page has small squares. Clicked on blank page, no change. Advise? System Configuration: Windows / Inte...
-
Excel Macro: Copy formulas across worksheets Solved/Closed
So first off, I have no Idea how to program, but I can kind of understand simple programs. Either way, I'm trying to figure out a macro in MS Excel...
-
Rajbha Closed
I have some columns like this A. B. C. D 8 66 1 86 1 86 1 79 3 78 1 16 99 2 14 8. 10 3. 78 4 11 4 11 1 79 8 66...
-
How To Get B Column Value Against A Column Closed
Hello I have 3 columns like A B C D 1 2 5 2 5 4 3 9 2 4 8 1 5 7 3 Now I Will Compare A And C Column...How To Get B Column Value...
-
formula search keywords in multiple columns Closed
Hello, I need to find a excel formula (column A) to track keywords in a table with multiple columns. the key words are for example Accor F...
-
Help : Copy Paste to end of list without formatting Closed
Hello everyone :) System Configuration: Macintosh / Chrome 60.0.3112.113 I'm new to Macros in Excel so I really need some help. Basically I ...
-
Enter value in cell, have range of cells copied to another sheet Closed
Hello, I have an materials list spread sheet that when I order a line/row, I'd like that row with the amount ordered to transfer to blank sheet 2. ...
-
Help with comparing and merging 2 spreadsheets Closed
Hi, I have 2 spreadsheets; each contain an employee number, but 1 contains the department of the business and the other contains the employee's hom...
-
How to do a macro in Excel with random pics? Closed
I need to do a macro with random pics. When in column "K" in scheet "SHEE4" find word "OK" then replace or paste in next cell random image from folde...
-
Arrow keys scrolling in Excel Solved/Closed
Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do not...
-
Product key Closed
How can i get product key?
-
Excel work sheet not copy to another sheet Solved/Closed
Hello, System Configuration: Windows / Firefox 52.0 I am =DGET(Sheet1!1:156,"NAME",$A$1:E$2) but it is not work
-
Filters will not include cells beyond the first blank? Closed
Hello, its not working for i checked into other system System Configuration: Windows / Chrome 60.0.3112.90
-
Help with formula please Solved/Closed
Hi, please could someone help me with a formula to add up cells that have data in them. My spreadsheet has data in columns B-N - some of them have ...
-
Criteria dependent data transfer. Closed
Good Morning, I would really appreciate some assistance with regards to a workbook I am creating in Excel 2010 to track equipment movements. I have ...
-
Saving .pub file to .pdf issues Closed
Hi, Im attempting to create a pretty large file using MS Publisher. I'm using the mail merge feature to create numbered tickets. The issue comes wh...
-
Subtract last column from first column Solved/Closed
Hello, I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last colu...
-
IBM LOTUS SYMPHONY DOWNLOAD IN ENGLISH Closed
I would like to download LOTUS SYMPONY IN ENGLISH PL HELP
-
merge 3 general cells to one date cell Closed
Hello, I made a mistake formatting my HUGE tour schedule. I thought I was so smart using 3 cells for dates a1= 10 (for 2010), a2= month 1-12, and a...
-
Bank reference changed format help Closed
Hello, I am trying to reconcile some standing order income at work, we have changed bank account and the reference has changed format! The process...
-
Need help with data sorting & updation Closed
Hello, I have a sheet with 6 coulmns each with (ABC & DEF) some value and different data Column A & D have same values. e.g. A B C D E F I want...