Excel Forum
-
How to remove Apostrophe in excel [Closed]
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...
-
Auto populate rows from master sheet to other sheets Excel 2013 [Solved/Closed]
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...
-
Conditional formating if another cell is non blank [Closed]
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...
-
Re-arrange data table [Closed]
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...
-
How to copy conditional formatting to other cells but not refs [Closed]
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...
-
lock specific cells [Closed]
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...
-
Match two unique criteria, total from a third .add to new sheet [Closed]
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...
-
Collection Of data from different Worksheets Under specific name [Closed]
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...
-
script which can check if a debit has a corresponding credit [Solved/Closed]
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...
-
IF functions with dates [Solved/Closed]
Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
-
Excel - Compare data in two worksheets [Solved/Closed]
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...
-
Macro to create a new set of rows/columns [Closed]
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 ...
-
HELP! conditional formatting to 1 cell with numerious entries! [Closed]
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...
-
Automatic reply if anyone updated in excel [Closed]
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...
-
Unable to Convert Date in Excel [Solved/Closed]
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...
-
Make cells unavailable for selection based on prev selection. [Closed]
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...
-
Populate missing value in a column [Closed]
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,...
-
Using a comand button to open an external software? [Solved/Closed]
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...
-
Edit and delete data from database using userform in excel [Closed]
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...
-
Sum funtion to substract [Closed]
Hello, When I do the below formula the results are different. What's the difference between Sum function and simply doing the subtraction directly...
-
How to populate a version # change to a text sentence [Solved/Closed]
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...
-
Conditional copy to another excel sheet based on date [Closed]
Hello, I need some assistance pertaining to copying certain specific cells from one sheet to another in the same workbook - conditionally. I ne...
-
Dynamic database [Solved/Closed]
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...
-
Excel Macro to rearrange data- combine cells and move sheets [Closed]
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...
-
auto start a specific row in second page from previous page [Closed]
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...
-
sum different alphabets in an excel range. [Solved/Closed]
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...
-
Macro to copy rows of data off of a sheet into several different [Closed]
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...
-
comparison of two table [Closed]
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...
-
Auto-running macro when cell is changed. [Closed]
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 ...
-
If Then rule with dates help [Closed]
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...
-
Transferring data to successive worksheets [Closed]
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...
-
copy data and paste using vba [Closed]
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...
-
Macro to rearrange data in excel- merge 3 cells and move sheets [Closed]
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...
-
macro to delete rows matching certain column criteria [Closed]
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 ...
-
How to reference Excel information onto other sheets [Closed]
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...
-
Help. Difficulty with adding a new row [Closed]
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...
-
Macros for counting the record count of each sheet [Closed]
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...
-
Conditional Formatting as a text [Closed]
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...
-
Macro with variable rows [Closed]
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...
-
cell blocking [Closed]
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...
-
Change date format [Closed]
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...
-
Table relation [Closed]
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 ...
-
Coping one cell values into different excel sheets by different [Closed]
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 ...
-
VBA for copy/paste a tutor perhaps.... [Closed]
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 ...
-
Comparing sales of Mondays [Closed]
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...
-
Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format [Solved/Closed]
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...
-
Ôter la protection [Closed]
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 ...
-
Macro [Closed]
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...
-
How do I lookup a value in say column and in returning the found [Closed]
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 ...
-
Google sheet Help required [Closed]
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received