Excel Forum
-
Excel VBA scripting - Changing a cell color based on contents [Closed]
My VBA is a bit rusty so hopefully I can get a little help. There is a report I need to create every week that I want to automate a bit. I have a ...
-
Conditional Formatting Excel 2013 based on content in other cell [Closed]
Hello, I have a spreadsheet with columns that have targets and results next to each other. If the target is reached (=) or exceeded (>) I want the r...
-
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...
-
If Date [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...
-
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...
-
Display dates from multiple cells in one cell [Closed]
Hi, I want to combine dates from multiple cells into a single cell in the same row, with the result displayed in the format: dd/mmmm/yyyyy, dd/mmm...
-
a lot of names and dates [Closed]
Hello, I am trying to find out a formula to use. I have a lot of names and dates. and another tap has names with days worked. I am trying to find ...
-
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...
-
convert number to assigned names and joined with another names [Closed]
I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell A - i will enter 123 cell B - will have result of Biju, Daisy, Mah...
-
Excel 2013 coping on row of a spread sheet to another [Closed]
I have a workbook with spread sheets wk End 1-15-2017, wk End 1-22-2017, wk End 1-29-2017 Looking for a way to have the row that is unfinished to mov...
-
Calculating rate based on date range [Closed]
I'm trying to figure out how to calculate a rate of payment based on two sets of date ranges: 3 days or less - $15 4 days or more -$10 How would I ...
-
Insert New Excel Sheet [Closed]
Hello, I need the code which will create a new sheet in existing workbook if data are entered in a row. data generating should be in the format whic...
-
Using 1 Table to Apply Values to Subsequent Cells [Closed]
Hello, I usually search google for my excel questions, but this one is tricky! It may even be beyond the scope of Excel. In a nut shell, I'm design...
-
Updating Master Sheet with most recent data [Closed]
Hello, I'm curious if anyone knows of a way to have a master sheet/summary sheet only update with the most recent data entered on a different sheet?...
-
How to create auto sheet in excel macro [Closed]
Hello, I need a excel Macro which contains separate sheets for each day in a month. By running the macro there should be auto sheets created in wor...
-
copy files from Google Spreadsheet to Excel [Closed]
Good Day partners How do I copy files from Google Spreadsheet to Excell, or How do I merger files from Google SPreadsheets
-
Copy row and it's contents based on value in X cell. [Closed]
Hi everyone, this is my first post so I hope I'll explain myself clearly! I have a spreadsheet with the following content: (Column I (in yel...
-
IF formula needed [Closed]
Hello, I need a formula that IF there is any data/text in the cell it will EQUAL another cell, BUT... I want the cell with the formula to display th...
-
Statement that returns pass, fail, "" [Closed]
Hello, Wanting to test row of numbers to a certain number and return pass, fail, or blank. =IF(AND(X7
-
Adding 2 cells to another sheet under If condition [Closed]
Hello, if i have 2 sheets and i want to add 2 cells of the 1st sheet to the other one -- only if another 3rd cells has the text "Done" what should i...
-
Excel Formula [Closed]
Hello sir, . But its can't working why i dont know! Please find my attachedments. Regards, Bicky Das, bickydas00@gmail.com
-
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 ...
-
Macro for adding pictures according to cell value [Closed]
Hi! I have this visual sheet (pic attached), and I would like to create a macro that would insert a picture from a folder on my computer in the cell ...
-
Cell content move with VBA code [Closed]
I have a workbook that we create service tickets from. The main sheet is used to enter information about the job. When complete I have a button that n...
-
How do you have multiple out comes for the same if condition in [Closed]
Hello, I have a condition in my file such that =IF(C5=C4,D3+1,D5=1 ->>>> trying to add this andD4= D3+1) Basically this what I want to happen C...
-
Conditional formatting based on another cell? [Closed]
Hi everyone! I'm trying to finish my financial sheet to work out where I am for this year. I need it so that when I type in the word "yes", It shows t...
-
Formula 1,2,3 division [Closed]
Hello, sir Plz notice the formula =if(cell address >55%,"1st",if(cell address >50%,"2nd",if(cell address >45%,"3rd","Fall"))) is the correct answer? ...
-
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...
-
Quick Access Tool Bar [Closed]
Hi Everyone, I'm new to this forum. Thanks for the help and advise in advance. I'm a beginner to VBA. I have created a custom Quick Access Tool bar ...
-
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...
-
auto populate data [Closed]
I have a workbook that has a tab for each week of the month. At the end I have a budget tab that I want certain information to auto populate into the ...
-
Excel Formula for Conditional Formatting of Dates [Closed]
Hello, I am having trouble coming up with an Excel formula that will provide conditional highlighting to a cell whose corresponding cell is not fil...
-
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...
-
charts in defferents tabs transfer of DATA [Closed]
Hello, I have a workbook divided in 12 tabs (12 month), each tab have exactly the same charts and cells.In other words, each tab are copy paste from...
-
Macro question [Closed]
How can I write into a macro how to find a specific row and column from 2 input boxes? One input box identifies a number located in a row. The other...
-
Excel Macro [Closed]
I run a golf league excel program. I would like to place a golfers score into a specific row(golfer name) in a certain row(week). I would use an inp...
-
date formate [Closed]
Hello, how to change the date format to 19-july-09 19.7.2009 23.04.2008 26.07.2010 System Configuration: Windows / Chrome 55.0.2883.87
-
Increment cell value according to cell colour [Closed]
Hi Guys, Can anyone help with a problem I have. I need to increase a cell count by 1 or 0.5 based on the fill colour of the cell. I am using the foll...
-
Copy/Paste row based on Date [Closed]
Greetings, I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the d...
-
Copy data from one sheet to multiple sheets [Closed]
Hello, i have 50 Excel work Sheets named Probe 1, Probe 2, Probe 3.............Probe 50. Now i have another worksheet (called Tabelle 1) which has...
-
Copy Row if specific word is in a column [Closed]
I have an Excel File with a tab named Ledger. I want to copy a row if it contains a specific word (Pets, Entertainment, Dry Cleaning, etc) and add th...
-
Google spreadsheet Importrange - continuous formula [Closed]
Hi, I am finding out solution on how I can make the Importrange formula continuous on the google spreadsheet. Currently, I am manually changing the ...
-
Excel If statement with date condition [Closed]
Hello, =IF(I20=0,0,IF(I20-M20-P20-'Rate '!$D$9
-
need a macro code [Closed]
Hello, need a code to copy a column from one sheet to another based on the heading name
-
When cell reaches equal to or over a sum, start new sum [Closed]
Hello, I have numbers in columns A through C that are input manually row by row, and column D provides a sum of each row's numbers and adds the prev...
-
Macro: copy, paste, unitl [Closed]
Can someone please help me out with this? I am trying to create a macro that will: 1. Find the cell to the right of where there is an ‘AE’ in colum...
-
Copying down/pasting across and not all of them! [Closed]
well here's to hoping someone can help, this is far beyond any ability that I have, so my apologies in advance! I have included a picture so that you...
-
how to show a specific column [Closed]
sir i want show only a specific column on another sheet.for example i have A-Z column with data and i want to print only specific column means show da...
-
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...
-
Multiple Cell Conditional Formatting in Excel 2013 [Closed]
I have three columns related to the prices of equities. Column A is for the name of individual equity, Column B is for the individual equity price of ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Recover Your Yahoo Account
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire