Excel Forum
-
Copy and paste a value x times dependent on value of cell [Closed]
Hi, I am looking to make a macro which will copy and paste a value into a column x times depending on the value of x... After it has copied this, I...
-
VBA: Lookup A Value and Deduct A Value [Closed]
Hello! I hope you guys are well! I oh so desperately need your help. Here's what's going on...I'm gonna try to explain this as clearly as I can....
-
Auto create sheets and dates for days and months. [Closed]
Hello, Greetings. I am seeking for a help. I'm a noob to Microsoft Office apps. I need to do something using excel. The issue is how can I auto...
-
how to manage drop list [Closed]
Hello, if i have two dependent drop list one in E15 include 3 item ( only fresh ; only exhaust and both ) other in f 15 when selec...
-
two tables values with diffrent order and number of values [Solved/Closed]
Hello, I have 2 tables of products (diffrent number of products). 1st table contains: all products (name, SKU): NAME | SKU asd.........21398763 ...
-
Compare 2 excel sheet [Closed]
Hello, I have these situation. I have 2 sheet of excel. one is master copy or original 1. second are excel sheet export from application. I need to ...
-
excel urgent [Closed]
Hello, hello im tamil,, i have more then 1000 line no in row,,, the line is nothing but file no,, and i have 1st submission , second submission, a...
-
set range for macro running [Closed]
if i have macro locked cells with change value of other cell , but this macro work from A1 i ask if i can modified code to let macro begi...
-
Conditional Formatting [Closed]
On my spreadsheet I have the following formulas on a date; Ex.J6+30=K6(Due Date), then Today()-K6=L6 (Days to implemetation). Now, when I have no dat...
-
Macro that selects the cell next to clicked button [Closed]
Hello, I need to run a macro on the cell directly to the right of the button I clicked to run it I will be running that macro on around 100 butto...
-
Automatically transfer data to another tab via drop down [Closed]
Hello, I do not know much about excel I'm afraid and have been given a task at work but unfortunately am struggling big time - tried to google it ...
-
clear content without clear formula [Closed]
Hello, i have cells contain formula say ( $e$10 = $e$8+$e$7) i need to clear e10 if e7 = 10 but formula still found when auto fil...
-
calculate my Service Expense as % [Solved/Closed]
Hello, I would appreciate if someone can help me with this problem solving question. I would like to know how to calculate my Service Expense as % ...
-
Changing year format from two digit to four digit [Closed]
Hello, I have data in three columns containing dates that have two formats; some display as dd/mm/yy and others display as dd/mm/yyyy. I need the ...
-
financial review [Closed]
Hello, I have an amount of $153,803 for Service Expense and $1,094,328 for Monitoring and Service Revenue. Problem to solve: Service Expense as % o...
-
Macro to pull data from a report and put into master report [Closed]
Hello I am wondering how I am able to grab data from a report that I have to run monthly but the cell number is not always the same. Is there a way to...
-
How to create several rules to change a cell's format. [Closed]
Hello, I'm trying to create an excel spreadsheet to manage a property but I'm having difficulties in creating rules. Here's the schedule I'm m...
-
Compare two columns and add data from other columns if match fou [Closed]
Ok i have names in Columns D and Columns I. I want to compare those two and if they match i want to copy the data adjacent to column I (J and K) to ...
-
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...
