How to remove Apostrohe in excel eg. '6018-8400-1532-3636 to 6018840015323636. I successfully remove the dashes by using "Find & Replace" but can't...
Hello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...
Hi, I have 2 columns. I want to change the color of column A based on value in column B. If value in B is blank no conditional formatting required Bu...
I am looking to re-arrange several tables. They are all in this type of format. Each table does not have a set number of rows and columns. Also...
Hi All I am trying to copy conditional formatting from an original cell to others but the format still refers to the original. Sorry if this is obvio...
Hello, I made changes in a pc and when opening the document in a mac excel 2007 without VBA the changes were screwed up (ie. formatting, formulas, e...
Hello Apologies if this has been answered in another thread, I have tried to ask the question in many different ways but cannot come up with anything...
Hi, I need a Macro Which can help me to collect data from different Xl sheets in master One. That data can be Identified With Its Title i.e. Data und...
Hello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...
Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
Hello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...
Hi everyone. I am trying to figure out a macro to create a new set of rows/columns ive created with formulas and such. The way i want it: 1-I have ...
I am having some difficulty trying to apply conditional formatting to 1 cell with numerious rules - as i have found 1 rule will always work as new rul...
Hi Team, I need step by step procedure how do i set the automatic reply to me if any of the team member update a excel sheet. kindly help me i m...
I am trying to change all of the dates in an excel spreadsheet to the mm/dd/yyyy format, but when I go to format the cells, it does not change, even w...
Hello All, I'm in the middle of a very big task trying to figure it out. I've 50 assemblies.. Each have variants. I select Ass#1, for this an option...
Hi, I need to compare two columns and need to populate the missing values in other column. EX: Column 1; Column 2; Column 3; a, b, c, d; a, b,...
Hello. I'm using Excel and I need do create a comand button to open an external software, e.g. I need do order that button to open "Profis Anchor f...
Hi Team, Need some help! I have been working on a userform for entering in and editing data in a database sheet which is located in my share dri...
Hello, When I do the below formula the results are different. What's the difference between Sum function and simply doing the subtraction directly...
Hello, Using Excel 2013 What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those cells t...
Hello, I need some assistance pertaining to copying certain specific cells from one sheet to another in the same workbook - conditionally. I ne...
Hello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that refreash...
Hello, I am just starting to use macros and am lost on figuring this out. Any help would be appreciated, thanks. Inventory comes in a 9x9 bo...
Hi i need auto start a specific row in second page from previous page in excel i hope your replay Configuration: Windows 7 / Chrome 45.0.24...
some one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P" and C...
Hello, i'm new to these forums and new to writing macros, I've been trying to find a solution to my problem but haven't found one yet. I need a ma...
Hello, I need to compare the two table values and return the result as true or false based on two table value in another table . It should be high...
Hello guys, I am using simple macro for one sheet (ControlSheet) to hide rows, in which certain cell (B11;B51) contains text "Corrective Action not ...
Hello, I'm trying to figure out a formula to calculate adding 84 days to an original date. However, if the calculated date does not fall on a Sund...
Hi I have a excel workbook containing several worksheets. To keep things simple Sheet 1 contains a column headed Dates listing 36 weekly starting dat...
Hi, I've two files, I would like to copy the data and not able to do so. Source file: Multiple rows (some times has 60 rows sometimes 80 with fe...
I am just starting to use macros and am lost on figuring this out. Inventory comes in a 9x9 box with position 1,1 (rows, columns) in the bottom lef...
site: https://ccm.net/faq/6261-excel-a-macro-to-delete-rows-with-specific-values I have reviewed this VBA code and it keeps getting stuck when it ...
Hi, I have imputed all the information onto excel sheet 1, now I need to consolidate all the information from this sheet onto another excel sheet 2...
Hello, so I am working on a payroll excel sheet which pretty much tallies up the number of hours that each employee does bi-weekly. On my first worksh...
Hi , Anybody plz help me in writing macros to prepare summary of records i will be uploading txt files into excel each file will have header and...
I'm trying to create a conditional formatting to come up as a text. For example I want an if then statement... if the cell = 7, I want a text to com...
Hi I am very new to macros and trying to record (rather than write through vba) a macro that can be used each week. The purpose of the macro is to f...
Hello, i need to block the cell after entering data to it which means i need each cell to accept entry one time only note.the worksheet must be pr...
Hello, I want to change date format from D/MM/YYYY (as it's being downloaded from a google form) into YYYY/MM/DD but I can't get it to work. A...
Hello, Ok This is the scenario, I've a excel sheet, with inside 2 sheet. In sheet1 i've a table with some some datas. In the collum B there ...
I have one cell vales. I want to store that value into different cell in different sheet. Suppose I have 10 in cell A1 from sheet 1 today which will ...
First of all, Excel is not new to me, and although I am not fluid on creating pivot tables, I can create some pretty awesome formulas on my own...and ...
We have an excel spreadsheet of sales for the year. The headings are Monday thru Friday. The rows are labeled for different categories. We would li...
I have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart bloo...
Bonjour tout le monde, j'ai un problème qui me bloque depuis un bout de temps, je veux ôter la protection des structures et fenêtres pour un classeur ...
Hi Team, I wanted to create macro which can select some data from cell A1 (not whole cell) eg if i have 10 characters in cell A1 i want select only 5...
Hello, How do I lookup a value in say column and in returning the found value replace the it with a typed value. An example is; a b ...
Hello, i want to print some 18 document in Google sheet as a PDF format. i want to create a formula, by which. If i enter the default value in ma...
DON'T MISS