Excel Forum
-
link info Closed
how do I link text information from one worksheet to another?
-
desktop reminder with excel sheet and VBA formula need. please s Closed
desktop reminder with excel sheet and formula need please support.
-
Copying Conditional Formatting with Formulas Accross Rows Solved/Closed
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. Exam...
-
Multiple IF formula in one cell, date comparison Solved/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...
-
Text colour doesn't change and cell borders don't print Closed
I cannot change the text colour in a spreadsheet and the cell borders do not print out although they are there on screen. I have the CD for Office Ho...
-
Why sum of some numbers is 0 Closed
Hello, I am trying to find the sum of some numbers in a column in a maxro book. I make the formula of sum and the sum appears 0. In fakt, althout th...
-
Convert number to assigned names and joined with another names Solved/Closed
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.... Cell...
-
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
