# Forum

Search
Close
Results 151 - 200 of about 1,480
• ## IF statement - [Solved]

Hello, I'm attempting to create an IF statement. IF a type = 1 then add the total of a corresponding cell to the total...

• ## lookup across whole workbook (muliple sheets) [Solved/Closed]

Hello, I would need your help with my problem in MS Excel. Description: 1. I have an excel workbook containing multiple sheets (ca. 15-20) 2....

• ## 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)...

• ## Autofill Master sheet [Solved]

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...

• ## If cell contains a certain text, add the numbers of another cell [Solved]

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 ,...

• ## 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...

• ## Copy ActiveChart properties to cell (from graphics) [Solved]

Hello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline,...

• ## Copying Conditional Formatting with Formulas Accross Rows [Solved]

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....

• ## Multiple IF formula in one cell, date comparison [Solved]

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...

• ## Convert number to assigned names and joined with another names  [Solved]

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.......

• ## 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...

• ## 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...

• ## how to convert Date into text. [Solved]

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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

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...

• ## 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....

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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)...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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 ...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## 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...

• ## Excel - A macro to rename existing worksheets based on a list [Solved/Closed]

I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just...

• ## Inserting image in a particular cell in VBA [Solved/Closed]

Hello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding...