Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
- Solved
-
Lookup across whole workbook (muliple sheets) Solved/Closed
Hello, I would need your help with my problem in MS Excel. Here is the description: 1. I have an Excel workbook containing multiple sheets (ca. ...
-
Data in Cells Appearing in other Pages Solved/Closed
Hello, I am having a problem with entering data into a cell on one page (tab) of a spreadsheet, and having that data show up in the same cell(s) on ...
-
Autofill Master sheet Solved/Closed
I am trying to automatically fill in a table (with whole rows from A-N) on a master sheet (sheet 1) based on whether the data in column H of the table...
-
If cell contains a certain text, add the numbers of another cell Solved/Closed
Hello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket , C2=30$...
-
Need formula for comparing differences of two columns. Solved/Closed
Column A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I reali...
-
Copy ActiveChart properties to cell (from graphics) Solved/Closed
Hello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline, display...
-
Copying Conditional Formatting with Formulas Accross Rows Solved/Closed
Hello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Exam...
-
Multiple IF formula in one cell, date comparison Solved/Closed
Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
-
Convert number to assigned names and joined with another names Solved/Closed
Hello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell...
-
Excel Sheets automatic updates Solved/Closed
Hello, I am trying to collect budget request from different departments and if all approvals fields are Approved, I want all data to be collected in...
-
Macro for merging data from multiple sheets Solved/Closed
Hello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...
-
how to convert Date into text. Solved/Closed
Hello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...
-
Function button: Unhide cells between values and hide all other Solved/Closed
Hello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several sections. What ...
-
Automatically transfer data from one sheet to another Solved/Closed
Hello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items base...
-
range of numbers Solved/Closed
hello, I would appreciate help on the following problem :- If cell R1equals any number in the range 12 to 31 then I wish cell b1 to equal 2. Is ther...
-
Add incremental number based on conditions in Excel Solved/Closed
Hello, I have a column that contains variables (for example; days of the week) and I am trying to add an incremental number in the second column bas...
-
Outlook Can Receive but not Send with Certain Wifi Networks Solved/Closed
Hello, I moved my PC to a new home and found that my Outlook can receive but not send when connected to the home's wifi. When I set up a hotspot on...
-
Generate excel workbooks based on excel list Solved/Closed
Hello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel...
-
If Then Solved/Closed
Im trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...
-
Email with Multiple Attachments through VBA Solved/Closed
Dear All, I need to send the multiple emails via Outlook through VBA. Column A Row 2 = Name of Person, Which must be Displayed on .Body Column B Ro...
-
IF and IS TEXT or IS NOT Blank Solved/Closed
Hello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price...
-
Conditional Formatting range of date cells based on another cell Solved/Closed
Hi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be...
-
Search for a Keyword. Add Value from another cell. Solved/Closed
I'm looking for something that's very difficult to search for. I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Depos...
-
A IF(istext) formula that needs a trimming, please help? Solved/Closed
Hello, Am really struggling with a IF(is text) formula, it works its just really large and I need to be able to trim it a bit as I need to replicate...
-
Worksheets into Workbook Solved/Closed
Dear All, I need to copy each worksheet into workbooks and saved in the specific path except 04 worksheets named NMS, MS, Master and Missing. Further...
-
Text from two different cells to give value shown in certain cel Solved/Closed
Hello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cel...
-
Conditional Formatting for Word and Date Solved/Closed
Hello, I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between tw...
-
Auto copy and paste cell range to a separate sheet Solved/Closed
Hello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...
-
Need to create multiple tabs based on data in table Solved/Closed
Good Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...
-
function in excel 2013 Solved/Closed
Hello Dear All. who I can do this function in excel 2013 If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value Configuration: W...
-
Nested IF functions using time values Solved/Closed
Hello, can someone tell why this wont work. The time value functions work separately on their own, and I followed the excel help for nested if func...
-
Cell format - COUNTIF then subtract from another cell Solved/Closed
Hi, I have a spreadsheet with holidays on. I'm using =COUNTIF(D16:D380,"H") I want to then subtract this number from another cell - What do I need ...
-
If/Then Formula Help Solved/Closed
Hello, I could use some help on the formula below. I need cells in one column (Y) to show specific text ("SEND") if cells in another column (G) has ...
-
date format Solved/Closed
Hello, i am trying to create a report which will show me the first date and last date of the previous month. I need first date in one field and seco...
-
EXCEL 2013 :Searching for text and display a different value. Solved/Closed
I am fairly new at this, but I work in excel files that are extracted from out problem management system. I created a formula that will look for a key...
-
Building a new spreadsheet using information from another Solved/Closed
Hello everyone, I'm new to the forum and VBA and would like to thank you in advance for your assistance. I have received a spreadsheet that contains...
-
Run macro automatically Solved/Closed
Hello, I wrote a macro and I want to run it automatically if one special cell change but have problem, because contents cell change by formula in oth...
-
Macro copy and paste in next blank cell Solved/Closed
Hi guys, I need some helping in excel macro. I have two sheets in a workbook. Sheet1 is for summary and Sheet2 is for the raw data. I need to update/...
-
automatically copy the values from the active row from sheet Solved/Closed
Hello, Struggling already for a couple of days.... so a help would be more than welcomed Need to write a macro in Excel which would: automaticall...
-
HOW TO FIX 'CANNOT ATTACH A FILE IN OUTLOOK' Solved/Closed
Hi team I find your website very helpful so I am returning the help - After searching the web and trying to resolve the above problem for hours, I fo...
-
Macro to copy entire row to next workbook Solved/Closed
Hello, Configuration: Windows 7 / Firefox 50.0 I have the following macro to copy entire row when the column has a capital X. I would like...
-
A and B column query to provide Sum of column C Solved/Closed
Hello and thank you for your help. Please use this scenario for reference: - A B C 1 abc x 1 2 abc y 2...
-
search, find & display Solved/Closed
Hello, I have been manually filling out the week no's, in a budget sheet, but want to try and auto populate. I have a table with dates and Week No...
-
Change cell color based on another column Solved/Closed
Hi All, I am not very good at excel, however I am looking for a solution for the following problem. There are two columns (Column A and Column B...
-
Best resources to learn about PowerPivot? Solved/Closed
Hello, I'm expected to use PowerPivot extensively - meaning with complex data models. What would you recommand for a newbie who wants to learn?
-
How To Make an Excel Sheet Equal to Another Solved/Closed
Hi, I'm new in Excel, and what I'm trying to do is this: I want to make an entire sheet equal to another, except for one cell, so if I change somethi...
-
Copy paste Rename based on cell value Solved/Closed
Hello I have a worksheet named template. I need a VBA code which would copy "template" automatically into a new worksheet and rename the new wor...
-
Searching for values and creating a list Solved/Closed
Hi there, I hope you can help me, so far I have managed to create a formula which searches a range of data (SKU’s) and returns a count of the occurr...
-
how to find value from a column with unique random values Solved/Closed
Hello, I need a formula that can get me a value from a column that has unique values and return another cell from that row, can someone help me? e...
-
Auto Generate workwheet from a list and from a template workshee Solved/Closed
Hello All, At the moment, I found out how to auto generate worksheet from a list. However, the generated ones are blank worksheets. May I ask ho...