Excel Forum
-
Changing a formula when a certain company is used Closed
Hello, I am curious if anyone knows if there is a way to have excel change a formula when a certain word is used, and only change the formula in t...
-
Auto-generate new sheets with starting and ending date. Closed
I started using macro in excel and I would like to inquire how to generate sheets by just giving the starting and ending dates. For example, I have th...
-
Error "Range of object Global failed" Solved/Closed
Hello Everyone, Kindly check my code for mistakes. I am getting an error in this part of my code as "range of Object _Global failed". Dim feat...
-
Excel- if this, than return that? Solved/Closed
Background: I work for a Recruiting Group & we have a list of candidates in Excel with all mailing info, including the County they live in. I need to...
-
Macro to copy rows and populate month/year based on start date? Closed
Hi all, I have a set of data where I need to create a row for every month through December 2016 based on a start date. For example, below is how the d...
-
Graphing Data from a Filtered Column Closed
I am currently graphing a lot of data that I look at on a scatter plot. I have a column that is named "Step name " that has about 30 different steps d...
-
Trying to concatenate a letter with a date Solved/Closed
Hello, I'm trying to keep a date in a recognisable format and precede it with a character. e.g. I want "D" and 27 July 2015 to appear as D 27 J...
-
Macros to Create new workbooks and Name them based on a list Closed
Hello, I have a template which contains all the templates that needs to separated. Is there a macro that will separate all these templates and sav...
-
VBA code for Inserting an Image Closed
Hi guys, I am in an urgent need for a command or code to insert an image from any directory in my computer to a particular cell in Excel using V...
-
If cell contains this text then.... Closed
Hello, Basically I'm looking for a formula that would let me do something like this: If cell d1 contains ANY part of Apple (ie apple pie, apple ca...
-
Setting workheet object variable Closed
Hello guys, I have defined WS as a woksheet and i want take an input from the user to select the worksheet using an input box. But I do not under...
-
convert date format to custom date format Closed
If i try to convert date format to custom format again it went back and showing as date in tab. For example i have a date format like 26-10-2016 and i...
-
Excel VBA; Merging cells when criteria is met Closed
Please I need help with the following, how to merge cells if certain criteria is met. when prefixes in column A match, cells in column B will merge ...
-
Insert Picture in Excel macro, after crop it, save it to a file Solved/Closed
Hello friends, I need to open a macro, after place the name in A1 cell, push a button to insert a picture, base on A1 name, then, after crop it and re...
-
Macro for comma on numeric keyboard Closed
How could I create a macro to toggle the period "." key between a period and a comma ","? When typing numbers it would be nice to be able to use the ...
-
Pictures keep pasting over each other when vba code executes Closed
Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...
-
change date format Closed
Hello, I Want to change date format DD"MM"YYYY (1/2/2016) TO 1/FEB/2016 MS Excel 2003 Please solve my problem urgently Shatrughna unquote
-
Spell Number Closed
I do not get the above function in my Excel 2016
-
If Function with Multiple statements including Vlook up Closed
Hello, Id like for my formula to read if vlookup is found (H:H is found in the freedom report and column x matches text in AV1, say registered. ...
-
Rearranging analysed historic data into a new coding structure Closed
Hello, I'm trying to rearrange historic data into a new coding structure. I have an excel spreadsheet, showing nominal codes analysing rows of...
-
How to transfer specific data from one sheet to another Closed
Hello, I am not an expert in Excel and I would say that I am a beginner on this program. I am working on an enrolment spreadsheet. On Shee...
-
What and where is the "orb button" as mentioned in help? Closed
Requested help on changing default action when entering info in Excel - response was "open excel and press the orb button". I can't find anything tha...
-
Copying values in cell based on a number/identifier in excell Closed
Hello, I'm working on an excel file and need to copy several values from different cell in the same row to another sheet based on unique number/ident...
-
Date if function Closed
Hello, I am looking for the formula to show the date if. Ex: I have been provided with the start date (10/4/2016) and i need to add 28 day's (=...
-
Find words within cell & put text and color in adjacent cell Solved/Closed
Hi there, i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a diffe...
-
Multiple If Function with priority Closed
Hello, I want and If function to have 2 criteria. Where one segment takes priority, I dont know how to do that. Currently I have =IF($R145="...
-
Conditional Formatting based on other cells Closed
I'm relatively new to Excel and I was wondering how exactly to do the following: A1=BALL A2=CAT How do I make it so that when B1=A1, then B1 is...
-
Formulas Closed
I'm trying to calculate my wages by entering the hrs worked each day, after 8hrs it is T.5 and DT after 10hrs. If I end up with a total of 3.2 or .2 ...
-
Copy certain cells from multiple sheets Closed
Hi, I have lots of sheets that I need to copy specific cells and copy them to a summary sheet. I currently have this macro: Private Sub Command...
-
Find Partial Text Match between Two Columns of data Closed
Hi Everyone, I am relatively new to Excel. I am in the process of comparing two columns of data to determine whether the data in each column relate...
-
Copy multiple rows from multiple sheets if certain cell is x Closed
Hello, I have a purchase order document in excel that can have from 30 sheets to 500. In cell B14 on each sheet there is a code, if it is equal t...
-
Macro to copy paste columns of excel data to a new workbook Closed
Hello, Consider the attached image. I have data like this for about 15 columns. I want to copy paste each column for 2 to 3 times in a different o...
-
Macros: Copy Invoice Details From One Sheet to Another Solved/Closed
Would be very grateful for help with this one I have set up a macro that will print and generate the next reference for my invoices raised in excel, ...
-
Auto Populate and Edit Spread Sheets Closed
If Intersect(Target, Columns("H:H")) Is Nothing Then Exit Sub Range(Range("E" & Target.Row), Range("R" & Target.Row)).Copy _ Sheets(Target.Value).Ra...
-
Copy a row of data from one sheet to another Closed
Hello, Trying to copy a row of data from a roster on a sheet into a new sheet when a cell states Line 1 ie When i type Line 1 etc i want excel to...
-
dates come in 2 different formats Closed
Hello, I have a csv file which imported to excel gives me dates in 2 different formats. I need to have one single format so that we can analys...
-
Conditional Format Cells Based on Another Cell and Own Cell Closed
Hi, I'm trying to conditional format cells based on text in another cell and it's own cell. In Column A, the cells would contain either "hit" ...
-
Different Calculation Based on Cell Text Closed
Hello, I am self-employed and currently doing my taxes. I'm trying to set up my spreadsheet to make it as efficient as possible and am wondering if...
-
Help needed with VBA code Closed
Hello, I have a unique situation here. I have got a sheet of data and in column F, there are duplicates values containing letter & Numbers like "O...
-
Populate Master Sheet from another sheet Closed
Hello, I want to create a simple entry sheet/report master sheet where records would would be typed into a single row (entry sheet) and the data w...
-
Add incrementing number to multple items in transaction (VBA) Closed
Hello, I am a new member and relearning Excel (2013). In this, I am also trying to get my head around VBA. I have VBA code that processes 'split'...
-
Macro to split the workbook in different worksheets Closed
Need a macro for Excel that will copy rows from my spreadsheet into a new one if it meets certain criteria. In the example below, I want to copy a...
-
how to insert any word in a cell after a word Closed
Hello, i wanted to insert a word for e.g "and" in a cell which after a word. Can someone help me with it Configuration: Windows 7 / Chrome 50.0...
-
EXCEL Formula Functions 2 (?) Closed
I am intriuged by the conditonal and the if functions. Does this mean I can record data that has a higher probability factor than an actual approxima...
-
Excel Revision (?) Closed
Hello, There is a prompt that states where a member is to record where two lines are accurate, yet I don't understand how or why one would need to e...
-
Copy Paste Data from one Worksheet to Another using macros Closed
Hello, I'm trying to have a macros run to copy paste from one workbook to another, however, I need the macros to recognize the last empty row to p...
-
How to copy names from one sheet to another with just a click Closed
Hello! I am tasked with creating an employee assignment spreadsheet. I cant seem to figure out how to easily formulate clicking names (around 10) ...
-
Summary Workbook Closed
Hi, I have the following requirement in a workbook and I was wondering if anyone could help me? (I am pretty much an Excel rookie) I have a summar...
-
Calculation of positions in excel Solved/Closed
Hello Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...
-
Data Validation refers to Sheet Name Closed
Hello, I would like to request for solving my problem My workbook contains many sheets, some ends with the "-E" (Hyphen Symbol and Alphabet E) S...
