Excel Forum
-
Date and If function [Closed]
Hello, Thank you for your time! I want excel to determine the date on multiple conditions. If the given date in A1 is 29-Nov-1980 and one...
-
Convert A Single Row to Column, with an undefined number of rows [Closed]
Hello, Hopefully somebody can help, I have a number of files where I need to convert the single row too columns, however the issue I have is...
-
Add "x" years to date when it has certain words [Closed]
Hello, I need help trying to add 5 or 10 years to a date if another column has this "word" or that "word"... Hopefully I explained myself...
-
Help! Need to copy only some columns in rows that have X condtn [Solved/Closed]
OK, Full disclosure, I am a Novice Excel user at best.....I have a Google Sheet Workbook that contains Google Form Responses (the Sheet name that...
-
Searching out Phrases in What-If Scenarios [Closed]
Hello, I am having a hard time figuring out this What-If formula. I have my employees make notes in Cell A. So A1 might read "The customer...
-
Use of '@' in formulae [Solved/Closed]
Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the...
-
Is this possible (IF with dates) [Closed]
Hello, I need some help with what to input into Excel for a function I'd like to see. What I'm looking at doing is: Lookup all dates...
-
IF function using dates [Closed]
Hello, I'm trying to write a function that will use an divisions data and turn it into manageable data. They record in their spreadsheet...
-
need to extract data from a cell in a macro enabled sheet [Closed]
Hello, I created an invoice for my business with a macro to run so that every time I click on a certain cell it will save that sheet into a new...
-
conditional Formating question [Solved/Closed]
Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7...
-
IF formula with dates [Solved/Closed]
Hi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date...
-
Copy rows from one worksheet to another based on criteria [Closed]
Hello, I have an excel document for our clients based on the type of service they have. I would like to be able to copy and paste the entire...
-
Excel formula question. [Closed]
I have these cells info. CBSA ; RCMP EC ; FO ; HCAN ; NATRES ; ND CRA ; PSC ; PWGSC ND ; PWGSC ACOA ; CFIA ; CRA ; CSC ; FO ; HRSDC ;...
-
Copy row from one sheet to other based on 2 conditions [Closed]
Hello, Any assistance would be very much appreciated I'm just getting into macros and coding. I'm trying to copy a list from sheet 4 and input...
-
Search 4 worksheets, copy rows to 5th [Closed]
Hello, I am using Excel 2010. I am new to the forum and have a very basic knowledge of VBA. I am trying write a macro that takes info...
-
Moving data [Closed]
Hello, this is driving me mad and im sure its simple. i have 2 sheets in 1 workbook. if column F on sheet 1 contains the word "YES" i need it...
-
How do you make a VBA function in removing a specific value in a [Closed]
How do you make a VBA function in removing a specific value in a cell. Example: remove "#, " and ", #" #, 1, 2, 3 1, 2, #, 3 1, 2, 3,...
-
EXCEL, If column terms match text In range b equal to or less th [Closed]
Ive been racking my brain, the attached photo illustrates roughly what Im trying to do, top and bottom images illustrates a collection if 12k...
-
Comparing Two Excel File. [Closed]
Hello, I have to compare two Excel files for data consistency. Both the file have equal number of column with equal records on it. My job is to...
-
Complex Macro Set-up Question [Closed]
Hello, I need to set up a macro that takes data from 6 different excel files and deposits parts of them in a new file, in different...
-
Copy answers from 1 sheet to another based on condition - VB [Closed]
I want to copy description mentioned in particular cell only when the adjacent cell (i.e. adjacent column cell) says 'YES' . I want to copy this...
-
Auto. transfer rows of data to a new sheet based on 1 variable [Closed]
Hello, I'm currently working with some data that needs to be broken for better viewing purposes and presenting to non-data minded people. It's...
-
Creating master spreadsheet for mailing information [Solved/Closed]
Hi there, So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and...
-
Macro only for Alphabetic Sheets [Solved/Closed]
Hello, I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z Thanks &...
-
Compare and Combine two sheets into one [Closed]
Thank you in advance! I have one excel spreadsheet with rows of customer contact information and the account they are associated with. I...
-
VBA Coding Vlookup to single workbook from different tabs [Closed]
Hello, I am trying to pull data through Vlookup to master sheet from different worksheet which is having a different tabs for different...
-
macro for conditionally moving info from one worksheet to others [Closed]
Hello and thank you up front for reading my question. This feels complicated but i have only minimal experience with macros and VBA. We...
-
Comparing data [Closed]
I have two sheets with data, for example product name, quantities sold and price. All product names on sheet 1 may not be there on sheet 2. So...
-
Two lists of Names that are jumbled up [Closed]
Hello, How are you all? I have two lists of names, one has all the names (A) e.g. Michael Luis Stevens, the other does not or the name is...
-
Excel VBA to open a EULA script when opening a spesific workbook [Solved/Closed]
Hi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected...
-
Summing until criteria are met in another column [Closed]
I have a situation where I want to sum a column of numbers from bottom to top but want the summation to stop when criteria from another column is...
-
VBA Macro Copy and Paste Loop Help [Closed]
I need to create a macro that allows me to copy and paste a set of formulas/values down a certain number of times. For example, if I had the...
-
Conditional Formatting [Closed]
Hello, Can someone help in figuring out a formula. If in the spreadsheet I enter under the condition column "good" or "bad" I need the next...
-
I need your help with Macro's please [Closed]
Hi there, I have been doing some reading up & watching YouTube tutorials regarding Macro's that will copy data from one sheet to another if...
-
Macro sum the values coloumn wise into brekup level [Closed]
I have a senario where i need to sum the values coloumn wise into brekup level, i have given the example below the number of items can vary so i...
-
Populate list [Closed]
Hello, I'd like to scan a column for a certain word (e.g. "Yes") within particular date in workbook, and i need to copy the text in some other...
-
If value in column A exists between values in column B and C [Closed]
Hello, Looking for assistance on the following: I want to know if value 302000000 (column A) exists between value range 382777400 (column B)...
-
Copy all Rows with specific Name to new Sheet [Solved/Closed]
Dear Friend, Am having a Excel Timesheet with following columns SITE - EMP NAME - EMP ID - EMP JOB TITLE - DATE - TIME IN -TIME OUT - TOTAL ...
-
VBA Formula [Closed]
I need to create a macro that allows me to copy and paste a set of formulas/values down a certain number of times. For example, if I had the...
-
Conditional formatting, using a formula to determine cell format [Closed]
Excel 2010 Hi, I need to make a spreadsheet and I want to use a BRAG rating to do so. To do this I want to type BLUE, RED, AMBER, GREEN into a...
-
Vba to change cell colors and highlight rows [Closed]
Here is what I have going on. I have a spread sheet, across the top are the dates of days that my crew works and the first column is everyone on...
-
Need help with a formula [Closed]
Hi I am putting together an expense calendar and need help with a search formula. What I am in need of is a formula that searches the days of...
-
Stacking 3 columns into 1 with matching cells and headers [Closed]
Hello, I have a table with data dating back weekly for 7 years. I am shifting it over to a new system but need to import the data in another...
-
Comparing two string columns in excel sheet [Closed]
Hi Can anybody help me to correct this data? There is a long list of this type of data.I want shortcut method to solve it as if there are columns...
-
macro that will allow tab 1 's information to be copy to tab 2 [Solved/Closed]
Hello, Please help. My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project...
-
transfer a row of data from one sheet to another same workbook [Solved/Closed]
Hello, I am trying to transfer a row of data from one sheet to another in the same workbook but my code is not working could anyone help me...
-
compare two cells in excel and if matches need to print its adja [Closed]
Hello, I want to compare two cells in excel and if matches need to print its adjacent value in next column. for example: I need to compare...
-
Help with search formula [Closed]
Need help trying to search for a specific variable, then return another variable that corresponds to the first. I will be entering...
-
Convert number to letters in Excel [Solved/Closed]
Hello, I have to define the numbers to their associated letters and based on the combination of numbers the next cell should show the...
-
Convert date of birth into words [Solved/Closed]
Sir, Kindly help me in changing date of birth into words. Example:20.03.2001 as twenty march two thousand one
