I have two excel spread sheets. Basically I need to copy information from the one excel spreadsheet to the other. Here is the tricky part. the sheet I...
Hello, I have a difficult question that may not have an answer. At least, I haven't found a formula that works. A ...
Hello, 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...
Hello, 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 ...
Dear Concern, I have one excel data file like below But I want to make a automatic data copying system on data sheet to another sheet using mac...
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? ...
Pls assist me on how to gives a class position of students after tabulation of the finals scores based on highest to Lowest
Hello CCM, Please give me solutions to solve my problem.. 1) I have created 2 worksheets, one sheet having two columns like below Code ...
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...
Hi all, I would like to know what to do for the situation below - I have 2 sheets named as "Current" & "New" and they both have the same columns a...
Hello, 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...
Trying to get rate in G14 that comes from the matrix E14 is a list of A3:A10 F14 is a list of B2:J2
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 ...
Hello Guys, I am trying to insert an image into a particular cell by calling the value stored in the variable via an InputBox. The following code...
Hello, I have a list of photos names that I would like to auto insert the photos into the cell according to the name. For example: in cell B1 is pi...
Hello, I am trying to paste a different value [which I copy from cells(1,i)] every 9 rows down column A. For example, will copy value B1 and paste...
can i look up the same value in 2 separate spreadsheet and return the location? Spreadsheet 1 A- item number B item description Spreadsheet 2 ...
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...
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....
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...
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...
Hello, I have 2 tables of products (diffrent number of products). 1st table contains: all products (name, SKU): NAME | SKU asd.........21398763 ...
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 ...
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...
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...
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...
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...
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 ...
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...
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 % ...
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 ...
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...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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 ...