Excel Forum
-
VBA Formula; Automatically update multiple workbooks from MASTER [Closed]
Hello, I am trying to help a friend with his restaurants. There is a MASTER list with all the food/drink items. There are 7 locations. Each...
-
Duplicate row [Closed]
Hello, How would the formula look like for the following: Sheet 1 has 100 rows Sheet 1 has 6 columns Row 1 has headings Formula would go o...
-
compare the values of two worksheets [Closed]
Hello, I want to compare the values of two worksheets say sheet1 and sheet2 (col1) and want to add all the values col2 of both sheets in anoth...
-
unable to move arrow keys in excel [Closed]
Hello, am unable to move arrow keys in excel, please help me
-
Cell Format based on conditional formatting [Closed]
Hello, Can anyone help me figure out if excel 2010 allows for cell formatting based on text? I have two columns, and in Col A, I have text that re...
-
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 of t...
-
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 the n...
-
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 corre...
-
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 thes...
-
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 came in...
-
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 "Reta...
-
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 on "s...
-
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 an en...
-
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 work...
-
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 has ...
-
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 and en...
-
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 row f...
-
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 ; PWGSC ...
-
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 the...
-
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 provided...
-
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 to ...
-
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, # Res...
-
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 pictures...
-
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 find ...
-
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 order. Efecti...
-
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 descr...
-
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 goi...
-
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 I wa...
-
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 & Regards...
-
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 have an...
-
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 client. ...
-
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 start wi...
-
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 what i ...
-
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 jumbl...
-
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 using vb...
-
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 met....
-
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 following...
-
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 column...
-
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 certain c...
-
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 need ...
-
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 cell ...
-
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) and...
-
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 - NOR...
-
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 following...
-
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 cel...
-
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 the c...
-
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 the m...
-
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 form...
-
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 tha...
-
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 name, co...
