Excel Forum
-
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 ...
-
If Then [Solved/Closed]
Im trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...
-
Copy specific data from Master sheet to multiple sheets. [Closed]
Master sheet if first tab in workbook containing following: Case # Case Name Open date Atty Destroy Box # All rows in numerical orde...
-
Macro building [Closed]
I am trying to create a macro that will: 1. Find the cell to the right of where there is an ‘AE’ in column B 2. Copy that cell (example: C1 (218453...
-
Macro [Closed]
Hello, In the following macro, I don't want it to remember the number 100004 which is a number I scanned in after performing Control Find. I wan...
-
copy from one worksheet if yes to differnt worksheet [Closed]
if i8 of worksheet a is yes then copy c8:e8 of worksheet a to worksheet b in location c8:e8
-
to find the grades in excel [Closed]
Hello, in column 1 i have entered one subject mark and in column 2 i have entered another subject marks , if both the subject marks are greater than...
-
create workbooks using a template and information from a table [Closed]
Please help me out, an example of data I have on sheet two Name bio Chem phy lug John 40 60 50 20 Luke 70 50 30 77 Eric 80 90 89 60 I want to c...
-
create workbooks based on a given template using data in a table [Closed]
an example of data I have on sheet two Name bio Chem phy lug John 40 60 50 20 Luke 70 50 30 77 Eric 80 90 89 60 I want to create a workbook per n...
-
Excel CSV problem [Closed]
Hi all, I have a problem with CSV files or with Excel, Excel only places quotes around certain fields, how do I force excel to save a CSV file with q...
-
formula for if specific contains text [Closed]
i am looking after purchase dept. kindly send us formula that one column contains text"BUY" and i want paste some columns in other sheet. Means cell ...
-
Help in creating a macro to copy row [Closed]
Hello, I have a data sheet showing names , numbers and date of termination in different columns. I would like to copy the details of the members in ...
-
How to copy the data in a row to another sheet using a macro [Closed]
I have a data sheet showing names , numbers and date of termination in different columns. I would like to copy the details of the members in a row ,w...
-
EXCEL FORMULAS [Closed]
HI, I NEED HELP WITH CREATING A FORMULA FOR A SPREAD SHEET. THE WORK BOOK HAS THREE SHEETS (UNITS, COMPONENTS, LOADLIST). IN THE UNITS SHEET SETS OF ...
-
Choosing a list item [Closed]
I wish to populate $values in f14 by choosing a name in a drop down list located on the same worksheet Qty Unit Price Price YT004-Oscar Terr...
Subscribe To Our Newsletter!
