The discussions
Inserting image in a particular cell in vba
SolvedHello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this...
Merge cell
Hello, What if the compared cell is a merged cell. Example, comparing the values in column C with the merged cell values in Column A, expectin...
Autoploting (master to other sheets)
Hello, I have a master file for all the transactions in one financial year. This file currently has 4 sheets: EGC,SSM,RSL,MF. The first three are...
Macro - new sheet per name list and add template in each sheet
Hi all, I'm a new comer here, but looking forwards to learning and helping others!. I am trying to create a macro that will: 1. create a new s...
If statements with dates and criteria
SolvedHello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set of En...
Help with excel formula
Hello, I am a beginner at Excel. Trying to figure out formula for: IF DATE in column A is greater than DATE in column B, highlight. Configur...
If a cell has specific data, copy entire row to new worksheet
Hello everyone :) This is my first post and I'm really needing some assistance if at all possible! I am a school teacher, trying to create a spreads...
Difficult lookup formula
Hello, I have a difficult question that may not have an answer. At least, I haven't found a formula that works. A ...
Duplicate values in multiple columns
SolvedHello, I'm looking for a formula for a case mentioned below: Consider we have values in three columns I need to find a formula which compar...
Copy data of one sheet to other sheets
SolvedHello, I want a VBA code or excel formula that automatic copy of data from one sheet to another sheets(either sheet 2 or sheet 3...etc)..suppose In ...
How to activate the button as activecell
Hello Guys, I would like to know if there is any way to make the cell in which the button is inserted as the ActiveCell when i click the button? ...
Report sheet
Pls assist me on how to gives a class position of students after tabulation of the finals scores based on highest to Lowest
Respective names required
Hello CCM, Please give me solutions to solve my problem.. 1) I have created 2 worksheets, one sheet having two columns like below Code ...
Want to implement a macro to find and copy to another sheet
Hello, I have tried to implement a Macro on Excel for my data, I have a search box made for my data on cell D1 I want to make a macro in which...
Copying & pasting data in next available row in same worksheet.
SolvedHello, I would really like assistance to write a vba code for a macro (using a drop down list) that copies data from A4:E4 and pastes it down in t...
Value from matrix table
SolvedTrying to get rate in G14 that comes from the matrix E14 is a list of A3:A10 F14 is a list of B2:J2
Trasfering data with vba
Hello, I have sheet1 of data with 2 columns with 26 row And i want to copy this data to sheet2 but when i copy this data it overwrite the old one ...
Vba: lookup a value and deduct a value
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.
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
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
SolvedHello, I have 2 tables of products (diffrent number of products). 1st table contains: all products (name, SKU): NAME | SKU asd.........21398763 ...
Set range for macro running
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
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...
Automatically transfer data to another tab via drop down
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
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/ClosedHello, 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 % ...
How to create several rules to change a cell's format.
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
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 ...
Error "range of object global failed"
SolvedHello 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?
SolvedBackground: 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?
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...
Trying to concatenate a letter with a date
SolvedHello, 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...
Vba code for inserting an image
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....
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...
Insert picture in excel macro, after crop it, save it to a file
SolvedHello 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...
Pictures keep pasting over each other when vba code executes
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...
If function with multiple statements including vlook up
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. ...
Date if function
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
SolvedHi 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
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
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...
Macros: copy invoice details from one sheet to another
SolvedWould 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, ...
Conditional format cells based on another cell and own cell
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
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...
Macro to split the workbook in different worksheets
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
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...
Copy paste data from one worksheet to another using macros
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
Hello! I am tasked with creating an employee assignment spreadsheet. I cant seem to figure out how to easily formulate clicking names (around 10) ...
Calculation of positions in excel
SolvedHello 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...