Excel Forum
-
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...
-
=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>" Solved/Closed
Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated... =IF(F21="CTF",I21*15,IF(L21="CTF",O21*...
