Excel Forum
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Email with Multiple Attachments through VBA [Solved/Closed]
Dear All, I need to send the multiple emails via Outlook through VBA. Column A Row 2 = Name of Person, Which must be Displayed on .Body Column...
-
Send an email using VBA when a cell value changes [Closed]
Can someone help? I have been struggling with this for days. VBA is something new to me and I think it hates me I have a spreadsheet that updates...
-
can anyone pls help me [Closed]
Hello, Private Sub CommandButton1_Click() Dim orange As Range, acell As Variant, bcell As Variant, ccell As Variant Dim ws As Worksheet Dim...
-
How to import data from one excel workbook to another using VBA [Closed]
I have two different files. 1. Name of the Source file - "Dump" 2. Name of the target file - "SLA File" I have the data in source file from A...
-
Conditional format based on another cell containing text [Closed]
Hello, i want to format a cell(make it red and negative value) if the cell next to it cantains one of the words:...
-
Tracker for License, Registration and policies and Letter updat [Closed]
Dear sir, Please provide me a excel tracker which could be used for find out expiry date of License and intimate before one month of expiry. For...
-
Date Value of a cell Determined by Specific Text in Another Cell [Closed]
Hello, This is a two part question: 1) I have three columns (A, B & C). Column A is populated with specific text such as "interviewed" or "set...
-
Separating Dates Using IF Function [Closed]
Hello, I'm trying to set up an IF function, I believe...I have a spreadsheet that lists dates back to 2013 as MM/DD/YYYY. I'm trying to create a...
-
Macros/VBA [Closed]
Hi, I'm trying to add 2 different cells in a work sheet to the header in a new worksheet. Then I need to excel to save the new worksheet as a...
-
Copy rows into sheets depending on a condition in one column [Closed]
Hi, This thread has been really helpful. The first part of my code works and copies data that includes the term "EMAS" into the appropriate...
-
automatic copy paste [Closed]
I want to copy same highlighted cells from one sheet to another ,for example sheet 1 contains a column with different highlighted colours now i...
-
IF and IS TEXT or IS NOT Blank [Solved/Closed]
Hello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute...
-
Conditional Formatting range of date cells based on another cell [Solved/Closed]
Hi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone...
