Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Data auto population Closed
Hello, I have to maintain record of calculate PPM for day, weekly, monthly, year, and supplier-wise contribution to that PPM by just feeding it onc...
-
How to average a time field format 00:00:00 (hrsminutes/secs)? Closed
have a document that won't average a six digit time field. need to convert to ?
-
True or False Value based on 3 difference cells' criteria Solved/Closed
Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...
-
Copying rows with data from multiple sheets to one master sheet Closed
Hi guys, I'm trying to figure out how to copy rows from multiple sheets with values in column Q to a master sheet. I have seen a set of codes a...
-
Saving input into 2nd worksheet while keeping the 1st empty Closed
Hi there, Spoiler alert: Excel dummy I hope you can help me with this. I need to have a worksheet that would be used on daily basis and can be ...
-
Compare and separate data Closed
Hi, I am obviously new to the forum here, but I came across a question kind of inline with my own on here and wanted to see if I could get some hel...
-
Acrobat Reader gets the error Closed
Hello! The problem is that: I downloaded a PDF fixe document, when read with Acrobat Reader gets the error: "an error Occurred while opening this docu...
-
Inventory Master List Help Closed
Hello, So I have a workbook with an inventory master list that i would like to pull inventory numbers from all of the other sheets in my workbook....
-
Record Scenario Iteration Results macro Closed
Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations using a macro a...
-
Record Iteration Results Closed
Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations and record the ...
-
Creating an auto updating sheet based on copy paste information Closed
Greetings and salutations. I've been trying to figure out how to create a score card sheet for our field technicians based on some automatically ge...
-
Copy data from workbook to another work book using date range Closed
Hello, i am new to this form and need some assistance in solving my problem i have below code which copy data into same workbook between 2 date ranges...
-
Reading text file containing data and output data in excel Closed
Hi, ...
-
Send reminder email 3 days before the date Closed
Hello, I'm new at this, any help will be appreciated. I need excel to send automatic email 3 days before expiration date. On my sheet theres...
-
Converting data in one column spanning three to four rows Closed
dear sir i have an address book over 500 addresses in column A. i am not able to index the book alphabetically i need to shift the data in a2 of ...
-
Product Key Closed
hi, how can I get my product key for Microsoft office 10 free?
-
Macro for coloring cells according to the value of the cell Closed
Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...
-
Macro for coloring cells according to the value of the cell! Closed
Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...
-
Repeating a simple macro loop up to 1,500 times Solved/Closed
Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...
-
Excel external data connection not working properly Solved/Closed
Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...
-
Highlighting Multiple Cells When Using Complete or Partial Text Closed
I currently work at a distribution center, and each day we perform lane assignments for outbound products. Attached is an image of our lane assign...
-
Value look up Closed
Hello, On excel I have a master Sheet that I enter Names of people which is used to transfer the names to other sheets making it simple to print. H...
-
HTML TO PDF Convertor Licence Cost? Closed
Hello, SWP: HTML TO PDF Convertor (Full packedge) what is the cost for an enterprise one/unlimited user license for a year? thank you Mor Sagr...
-
Conditional Row Copy/Consolidate Closed
Hello, I am working with a database that deals with student scheduling in schools. I am getting repeated lines for each class a student is enrolle...
-
How to create a macro to copy and paste Closed
How do I create a macro in excel to copy and paste row 1 through 18 in column A into column C. I want to copy and paste every 18 rows in order in colu...
-
Auto create new columns Closed
Hello, I have a spreadsheet where I track attendance for my church throughout the year. We have events that happen on a daily basis. Most days I o...
-
Macro for coloring cells depending on values and presenting them Closed
Hello guys!! I have an excel file with 2 columns of percentages. The first column has theoretical values of an experiment and the second column has...
-
Index formula questions Closed
I have an index formula that will be calculating price points based on the values entered into the excel document. Is there a way to make sure that th...
-
Using VBA macro logic in Excel Closed
One static Excel workbook with a ton of raw data that has a static number of columns (A-EK) that is always the same but the lines (1-X) is not static ...
-
Macros Closed
I have a spreadsheet of 15000 lines, I need to copy the Cell ranges B:E onto the next line B:E, then go down to the next populated cell and do the sam...
-
Help creating macro Closed
Hi, I have multiple excel sheets in multiple folders. I want to copy part of excel sheets which are in multiple folders and paste it in a new excel sh...
-
What function of Excel does this? Closed
Hello, I know there must be a function in Excel that does this but I don't know what. If you know, please share or if I need a piece of code then ...
-
MS Office 2010 installing problem Closed
kindly solve my problem with ms office 2010
-
I need to create a formula IF with dates and 2 variables Closed
Im trying to create the following formula in excel If theres number greater than 0 in a column and if the date in the other column is before one mon...
-
Compare two column from two different sheets Closed
Hi...I want to compare two column from two different sheet which contain time and date.In sheet A column with date and time.In sheet B , there are two...
-
Search option did not getting in Filters Closed
Hi All, Hope you doing well !! When I update fliter in my Excel sheet then I did not getting the search like this, please find the snip below. ...
-
Urgent Help-VLookUps in Excel Closed
Hi, can we compare 2 excel sheets in which we have date related to Emails ID'S (Email recipients) but one sheet is having 230 rows and other 160 , i n...
-
Convert PST to MBOX for importing into Thunderbird Solved/Closed
I have a pst file which contains all my outlook mail backups. I want to convert .pst to .mbox for importing those mails into my Thunderbird account. ...
-
Create a date from 3 different cells Solved/Closed
Hello, In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3). I want to put these 3 numb...
-
Forgot my password to restart my Outlook 2007 Closed
Hello, I forgot my password to restart my Outlook 2007. Please help. Thanks
-
Check register with VLookup Closed
Check Register Col.A Col. B Col.C Col H Col I 1 Payee ...
-
Comparing Two Excel Sheets and copying like data to third Closed
Hello, I used the below answer and it works but i actually need to tweak it to copy from the second sheet. So I have sheet 1 has full data and co...
-
Creating a Calendar that autopopulates from multiple sheets Closed
Hi all, I am attempting to make a calendar that will auto populate or vice versa from multiple other sheets. This is all to track training hours fo...
-
+1 for every letter "S" Closed
I am trying to add 1 for every letter "s" between C5:C53,F5:F53,I5:I53. So far I have this formula =SUM(IF(C5:C53="S",1,0)) Which is giving...
-
Macro to insert multiple rows between existin Solved/Closed
Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after every 2 entries. The amount of rows needed wil...
-
Conditional Format help Closed
I have an excel spreadsheet set up with 4 columns: Start Date/30 days after Start Date/60 days after Start Date/90 days after Start Date What I wo...
-
Microsoft Office 2010 - Downloaded from CCM.net Closed
I downloaded the so-called FREE Microsoft Office 2010 Home and Business software and went into the installation process, but it is asking for the Prod...
-
Student position formula Closed
Hello sir : I want to find the student position. But those student who fail in exam not incldue in the position.
-
Macro for creating separate files with fixed password from colum Closed
Hi All, I need urgent help for a macro which will create separate files from a column value I have this data in the picture attached http://sta...
-
Word document on Lenovo IdeaPad Closed
Hello, Hoping someone can help me out here. I've got a strange problem with Microsoft Word 2016. I cannot open Word document on my Lenovo IdeaPa...
