Office Software Forum
- Excel (9,805)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
-
Convert
Hello, Sir/madam how to convert 30-1-2009in words
-
pasting a column into alternating rows in new column
Hello, i have a column of ID numbers and a column of names next to it, I want to copy and past the names with their corresponding id in cell under the...
-
How to lock in specific cells in a formula going down rows Solved
Hello, I am having an issue with easily repeating a formula I've made. the formula is =IF(AP2=Sheet2!K3,Sheet2!L3,IF(AP2=Sheet2!K4,Sheet2!L4,IF(...
-
Google Sheets Formula
I need to search column D for "Text 1", then if its true, any row that has it, take the data in column B(same row) and enter it into another cell. for...
-
Counting and stop counting in a cell
Hello, I need to create a formula for a cell involving number of days between dates. A2 - start date B2 - lead time C2 - end date D2 - showi...
-
Hello friends. Please help ! COUNTIF formula ? Solved
Hello friends. Please help ! I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12"...
-
Highlight cell if another cell contains specific text
Hello, I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 h...
-
change cell color of all cells in my formula
I often have huge spreadsheets where I have to add random cells together. In order to make sure I don't miss any cells, I want to change the color of ...
-
Excel formula to check if cell contains a date
Hello, Hi, I am trying to write a formula to check if there is DATE value in a particular cell. If there is a DATE value, need to say "DELETED...
-
Automatically update one sheet from multiple other sheets Solved
Hello, I have a workbook with each office location having its own sheet to keep track of project information all with the same column headings. Co...
-
Create and populate sheets based on values in master list
I have seen a few similar forms but cannot seem to achieve the functionality I'm hoping for. My workbook will have a master spreadsheet that is per...
-
Formula to compare 2 columns and count missing values
Hello, I have an Excel spreadsheet where I want to compare values between two columns A and b and to see if any values are missing in column b. ...
-
Email notification when cells in a column are changed
Hello, I am trying to set up a macro to send an email when a cell changes in a certain column in excel. I used a conversation in this forum that g...
-
Conditional format B1 based on a specific word in A1 & calc
Hello, I would like to check how to use the conditional formatting to get a colored cell in B1 containing numbers (based on a "INC VAL" in Cell A1...
-
summing values based on matching column across sheets Solved
Hello, Hello, I would match data across sheets based on matching columns B then should add & summing the values to sheet summary under heade...
-
Link info between 2 slides powerpoint not a hyperlink
I have a trivia game I built with a scoreboard that has vba coding to update scores and totals . I want the totals to allear on a separate Slide as ...
-
how to copy data after at a fixed cell Solved
Hello, I have the following data for which it needed to be copied on another sheet after a gap of 7 cells for each entry in Sr No. column. Li...
-
Keep Track of Customers Service Visits
Hi All, I need help in keeping track in excel of the customers service visits. I have customers that are visited weekly, some twice a month, most of...
-
Comp. value in 2 columns against a list and disp. text in 3r
Hello, I need some help as I cant figure out how to construct this. I have been using a combination of IFS, AND, & VLOOKUP functions but I cant se...
-
Excel formula for filling another cell
I have four columns in excel. Column A is named "Date" while Column B is named "Day". Column B depends on the value in Column B and I got the Formula...
-
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS Closed
In creating an excel app to calculate the aggregate for students in their exams as used by WAEC to determine the student aggregate in BECE . The Excel...
-
Powerpoint Navigation menu in VBA (instead of hyperlinks)
Hello all, My ppt has almost 100 slides, whereby 5 slides usually belong to one topic ("to the same package"). Now I would like to insert a menu wind...
-
Conditional formatting in Sheets rows based on text in cell
Hello, I have looked through some past answers and have not found a solution yet; I am trying to apply conditional formatting to a sheet where if te...
-
Code to move rows into another sheet based on certain values
I found this lovely little script on this forum. It has worked flawlessly. I have a spreadsheet with multiple pages and I would like this code to work...
-
Macro: change cell color based on value in another cell
Hello, I'm am trying to fix a spread sheet at work but what i need is a macro that i can run to do the following if the word Traffic appears in...
-
Autogenerate alphanumeric ID numbers in Excel? Solved
Hiya! Let me start off by saying I am NOT a tech person so I don't even know if this is possible. I am trying to create an excel sheet where I can ...
-
search across all open workbooks for user defined criteria Solved
Here is my problem - we store info into files that use an index number (changes with each file created) plus 2 criteria to keep track as we produce ma...
-
auto-fill items repeatedly for two sheets based on another Solved
Hello, I have two sheets(FIL1,FIL2) should auto fill some items into column A repeatedly . it depends on sheet REP after matching based on colum...
-
Copying a row based on a integer in a cell Solved
Hello, I am needing help making a macro that will allow me to do a number of things, that may or may not be able to be done with one single macro. (...
-
How to Speedup Formula processing
I have been using this formula which macthes the List of Cells to Raw String and if match found then write same value. This function is working fin...
-
Automatically creating code like OTP
Hello, I want to make some automatically code or number against once I enter data in cell. I mean it's like OTP number . It's not necessary that it'...
-
how split column into multiple columns for multiples sheets Solved
Hello, I need macro to split column C for sheets REP1,PROC1 into columns C,D,E based on matching column B with column B into sheet RP ...
-
UserForm VBA excel. Saving data depending on the parameters
Hello, I created a UserForm through Excel VBA with the data text input which contains dates (ex. 2015,2016 etc.) I need this data to be put into d...
-
Reference and tranpose cell information
Hello, I am trying to get get the formula in SHEET 2 ROW 3 to copy the data from SHEET 1 COLUMN D. I tried to just copy and paste or copy and dra...
-
match & add missed items between two sheets Solved
Hello, I have two sheets contain the same structure of data . the result should show in column B,C into sheet2 based on matching with sheet1 . ...
-
Copy row and insert based on value in column
I have never used macros before! I have a spreadsheet where I need to duplicate rows based upon a quantity in a column. For example, Row 1 has a value...
-
Unable to send/receive emails in Outlook 2016 after setting up Outlook 365 ? Closed
Any suggestion?
-
Best way to Open Archive PST Files
Anyone........
-
Extract image from filled shape
Hello, I have a presentation with many shapes filled with images poasted from clipboard. How do I extract those images? I want to edit them. Th...
-
How to add rows that meet specific conditions Solved/Closed
Hi Every week at work we get data about new jobs that have been completed at our company, and I add that data to a raw data tab. In the summary tab...
-
Export Office 365 mailbox to PST
Hello, Anyone can provide manual methods to export my Office 365 mailbox to Outlook PST? Else, do I have to do it by using third-party software...
-
How to extract text from column that got text
Hello, I would like help on how to extract text from column which has text. Some column might not have text or blank, want to know how to extract th...
-
If then excel
Hello, If AA cell says not recorded, I need AB, AC, and AD to be shaded in red. I’ve read multiple forums and unable to find help for this. ...
-
Adding narration to PPT that already has existing audio/SFX
I have an existing 26-minute PPT that has 145 slides, embedded music, video, sound effects, etc. (It looks like an amateur Ken Kurns documentary). I u...
-
Changing values in one cell depending on drop down Solved
Hello, I created a drop-down list of scores (ie. 10, 20, 30 to 100) in cell A1. In cell B1 I want it to show a specific number value based on which...
-
30 days prior date popup notification
Hello, I've currently done condition formatting on the expiry date column to turn RED 30 days prior to expiry using formula =AND($H2>TODAY(),$H2-TOD...
-
Start and stop counting at the zero value
Hello, How to insert a COUNTIF function to count values once it reaches to the first zero value to stop. And count again the cells between the first...
-
Excel Macro: compare 2 sheets and create result sheet
Hello, I have two excel spreadsheets, spreadsheet 1 a sheet that list device names, spreadsheet 2 has device/machine name and custodian. Need to ...
-
How? Transfer columnar totals only from 1 sheet to another?
Sheet 1: several columns of #s, each column totaled. I want to transfer the columnar TOTALS ONLY that were the result of formulae to Sheet 2. How do ...
-
Trying to build a weekly sales comparison
Hello, I built a workbook that has as 8 weeks of of sales data. Each week contains the items that were sold with the quantity and and how much re...
