Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
match & add missed items between two sheets Solved/Closed
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 Closed
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 Closed
Anyone........
-
Extract image from filled shape Closed
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 Closed
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...
-
If then excel Closed
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 Closed
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/Closed
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 Closed
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 Closed
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 Closed
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? Closed
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 Closed
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...
-
Conditional formatting: change fontcolor based on another cell Solved/Closed
Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ran...
-
Excel formula with changing rows going in order Solved/Closed
I am mapping one cell to another spreadsheet and I trying to figure out how to change the row without having to manually change each line. For example...
-
Word file Hyperlink and it's title export to excel Closed
Hello, I have a word file content which has many titles and hyperlink for each titles. I need to export Titles and respective Hyperlinks to an Exce...
-
How do I fix Outlook Error 0x800ccc0f? Closed
Hello, I am facing the Outlook Error 0x800ccc0f issue while incoming or outgoing MS Outlook messages. Please help me to resolve this error.
-
Macro to copy row based on condition Closed
Hello, I need to set-up a macro to copy rows from Sheet 1 to Sheet 6 based on data in column 'AS' (If data ="Yes" the row is copied over) I nee...
-
IF function: Conditionally multiplying a value Solved/Closed
Ok so I am trying to create a formula that would use a different calculation based on an answer. So when I get the number 2 in a cell then the data us...
-
If cell = date return yes or no. Solved/Closed
Hello, I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes, No) ...
-
Video playback issue Closed
Hello, I have created a PowerPoint presentation with an inserted MP4 video that plays across the slides. When playing the pptx version, it works p...
-
EXCEL formula IF Closed
Hello, Can someone help me? I want a formula to show OK if the cell beside it have some value. Example: A1: to be filled with D.O number (will o...
-
Use Count and Find number of certain item Closed
Hello, Use Count and Find number of certain items within a field range
-
copy adjacent Columns in excel if the ID numbers same Solved/Closed
Dear all, I have ONE HELP in excel to copy two columns data( Qty & Amount ) from another sheet if the ID numbers are same.. I have created one...
-
If cell contains multiple text how to add other cell value? Solved/Closed
Hello, I am struggeling with my excel sheet and need help. I will rather give it in an example. A1 and B1 contains a price, C1 contains three s...
-
How to set Multiple selection to insert photo in this code Closed
Hello, Can any one please slove this code. I want to get multiple photos at once. Here my code is supported to pick only single selection while goes...
-
PDF editor for desktop like xodo pdf BUT with keyboard shortcuts for editing? Closed
Hi! I am looking for: -A FREE PDF editor -For Desktop (Windows 10) -I use Xodo pdf and it is really good but it does not have shortcuts for ed...
-
match two sheets with another and highlight & create report Closed
hello I have sheet"In & Out Balance" contains data .every month I will insert three columns it should match column B,C,D together with sheets(purchas...
-
Generating new file with multiple sheet template Closed
Hello, I have a file that is currently generating new files based on a template file + a list of names. The problem is that the file is generat...
-
How to Insert an Image into an Excel Comment Box (Mac) Solved/Closed
Hi I'm on Mac with Excel 16.53 and I want to insert an image into a comment box. I read this : https://ccm.net/apps-sites/software/4079-how-to-i...
-
How to calculate position (1st,2nd,3rd) in excel....? Closed
Hello, Hello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in...
-
Formula in excel to show amount in cell Solved/Closed
Hello, I need a formula that show the amount in another cell if some text is found in another cell. Like this; A2: 500 B2: Done C2: result t...
-
Microsoft Word scroll bar issue Closed
The vertical scroll bar disappeared in word. I now have a horizontal scroll bar at the bottom and it turns document pages. The wheel on the mouse is a...
-
Copy and autopast rows from sheet1 to sheet2 IF Closed
Hello, I woul like to Copy and autopast rows from sheet1 to sheet2 IF they are f ex "highlighted" or "bold" or "underlined" is something lik...
-
Excel assistance; IF formula to calculate remaining balance Closed
Hello, How do I write a formula in excel that says if any cell contains a certain value, then calculate a remaining balance?
-
VBA code: calculating time difference Closed
Hello, this is my code i try update the data automatically but the macro is not working of the updating part datetime auto_cycle tool time_differe...
-
How can I link optionbutton and textbox based on selected from combobox Solved/Closed
Hello, hi actually I got this codes from another web and mod some . it succeed and works , but my question how should link with the others tools ...
-
Copy & Paste Closed
Hello, I copied Sheet1 Names( A2:A6) and select the Sheet2 Paste Names (B2). The same name paste entire (B) up to end row . If Sheet2 (A) ro...
-
Multiple IF arguments Solved/Closed
Hello, I am trying to get Excel to look at data in two cells and depending on the combination it finds in those cells, record a different TRUE sta...
-
add missing data before TOTAL row after matching between two sheets Solved/Closed
Hello, I'm new begginer in vba and I hope some help I have data in two sheets . should match data beween them. the match depend in COL ...
-
create excel spreadsheets that update from a master sheet Closed
Good Morning I need to create a master list of individuals in a specific program on a master list that covers all counties in Maryland. I want to b...
-
when i am pressing spacebar dots are coming in word for windows 10 Closed
when I am pressing the spacebar dots are coming in word for windows 10
-
word 2007 in win 11 Closed
Hi I am new on here. My laptop just updated from win10 to win 11 & i opened my word 2007 program & got a box pop up with choose how to open - 1. xls ...
-
Code to move rows into another sheet based on certain values Solved/Closed
Hello, I've seen different variations on this question, but haven't seen any answers that specifically address moving rows based on multiple value...
-
cell value = sheetname to pull information from in excel formula Solved/Closed
I am trying to pull data from another sheet using the formula (located in B26) below, but I want to replace the sheetname ('9.60'! in this case) with ...
-
Return Seq Values Until Blank value then return different set of seq values Solved/Closed
Hello, What is a formula to return a specific set of values in sequential cells until the reference sequence returns a blank value then start return...
-
Sorting table without messing up formulas Closed
Hello, I'm trying to create an excel file to manage my diet and meal plan and counting macros. I have in the same file a table filled with differen...
-
how deal with this complicated code and updating(subtraction between two sheets) Solved/Closed
Hello, I need help from experts to updating this complicated code . I know this way is very complicated to subtracting the item...