-3
votes
0answers
15 views

i want to compare two different columns and get value from another workbook using vlookup

I want a value from the workbook(2) by comparing two different columns from workbook(1) using vlookup. I want a vlookup coding like ,if WorkBook(1)columns A matches with workbook(2) columns A then it ...
-1
votes
1answer
17 views

Excel, using cell text references as input for formula

First of all thanks for your help. I have a problem regarding the use of text into formulas. I am working on a huge dataset of stocks of several years. The stock are not correctly grouped. I used an ...
0
votes
1answer
44 views

VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell. For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...
0
votes
1answer
31 views

Make formula impossible to find / read

I have developed a spreadsheet for performing various calculations which our employees will complete and then distribute to clients / competitors. To protect the "intellectual property" of the ...
0
votes
1answer
14 views

Formula to determine available options based on prerequisites

Example: A spreadsheet for a single studient has four columns: Course|Completed?|Prerequisites|Available The "Course" column lists the names of courses. The "Completed?" column indicates a "yes" if ...
0
votes
1answer
16 views

Copy a specific cell on all sheets to master sheet

I have a master sheet with the format as below: Master sheet Column A Column B Column C No Description Price And multiple sheets with the format below: Sheet ...
0
votes
3answers
50 views

EXCEL - How to have a formula output and user input on the same cell?

I would like help from someone as I believe this problem requires VB. I basically have a CELL(A4) where people will be entering values to find out the corresponding calculations displayed below. ...
0
votes
1answer
8 views

Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items, with different information in all columns ,although certain columns might have duplicate information. I can do conditional formatting and highlight the ...
2
votes
2answers
26 views

I would like to copy data from 1 row to another in Excel

I am trying to solve the following issue in excel: I am working in two sheets, Sheet 1 and Sheet 2. There is a column of data in sheet 1 (say from A5 to A20). I need every row from that column to be ...
0
votes
0answers
41 views

comparing two columns for matches then return values meeting certain conditions

I have the following: column D ( 300 values representing the average of three cells, A1:A300 & B1:B300 & C1:C300) column H ( 50 values ) column E & column F & Column G; they are to ...
0
votes
1answer
37 views

Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20) The 3 columns are each 1 digit of a 3 digit number. Some of the rows have 3 digits, some are blank. I need a way to return all the non-blank rows of 3 ...
1
vote
0answers
42 views

Excel VBA - User Defined Function to turn string into formula

I'm looking for something similar to the solution posted here: Excel function that evaluates a string as if it were a formula? Problem is this does not seem to work with a function in there. This ...
0
votes
0answers
28 views

excel - ask for input to be used as new cell values [closed]

I use excel 2007 and I want to create the following function: At first I need to add a vba function button that prompts the user to add four different values, e.g. a name, a number, a date and an ...
0
votes
3answers
161 views

Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values in column B, and depending on that value, put the answer in column C. For example, using the table below, it searching in ...
1
vote
1answer
37 views

VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure: Fill one cell with a formula, where arguments to ...
0
votes
1answer
24 views

Get result of formula as text

I have an Excel doc which populates a matrix using formula, for example; | A | B | C 1|=1+2 |=2+2 | 2| | |=4-1 would display as; | A | B | C 1|3 |4 | 2| ...
1
vote
1answer
51 views

Working with cell addresses in excel with VBA

I have a Excel sheet in which are multiple forms. The forms look all the same and they have exact the same cells between them. They are ordered in 4 x 3: x x x x x x x x x x x x x x x x .... There ...
0
votes
1answer
30 views

Error outputting a string to cell

I am using a vba macro to automate part of an excel spreadsheet. The following line keeps giving me a runtime error 1004# application or object defined error Sheets("Material").Last.Offset(0, ...
0
votes
1answer
30 views

Deleting rows that contain a keyword in the column

I have an excel file that has a id as one of the columns, each id has multiple entries and follow a set of survey questions. I need to delete all of the rows that have that keyword (which is in a ...
0
votes
1answer
42 views

Excel: portable formula to reference data on previous (relative) worksheet

I need to create a fairly simple Excel spreadsheet (workbook). I need 12 sheets (tabs), one for each month. Each sheet references cells in the previous sheet. For example, the "May" sheet is ...
2
votes
1answer
124 views

Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following: = A1 + A2 = B2 + B2 etc., ... I would like to replace each of these cell references with the values without ...
0
votes
1answer
132 views

Hide columns based on content (sum of rows)

I'm trying to hide columns based on the sum of selected rows (i.e., cells) in those columns. For example - if the sum of E9:E12 is 0, then hide column E. Additionally, and probably a little harder - ...
1
vote
2answers
75 views

Excel 2010: Calculate full months between dates

I have dates in two columns and I would need to calculate amount of full months between two dates. I export the spreadsheet from SAP ERP in .xls format but opening with Excel 2010. DATEDIF function ...
0
votes
1answer
51 views

Convert formulas in table to structural references

I have converted my range in excel 2010 into a table. However, the formulas which were before like that(see below) stayed the same and do not convert into structural references. ...
0
votes
2answers
30 views

Showing name of row instead of excel cell name

I am having extremely long formulas over an extremely big sheet. At the moment I am tracking the formulas with the Formula Auditing Tool. However, my idea would be to just replace for example in a ...
-1
votes
1answer
252 views

Compare the value change of data in Excel between two similar sheets without VBA?

I need to match data in the column A's of two different sheets with similar data and then compare the values in column C. sheet 1 features data from this month, sheet 2 from last month. I have column ...
0
votes
1answer
72 views

Months and Date keep being switched around when running VBA

I have a column on my sheet, Column F which is full of dates. Now I need these dates to be in this format "dd,mm,yyyy" but sometimes they are in text form, us/armenian format in the original data. Why ...
1
vote
1answer
72 views

Clear contents from matched column of data in another sheet

I have a column of email addresses on sheet 2 col A (but I could put them on sheet 1 if it would make it easier / faster) that I want to remove from sheet 1 col D if matched (there may be 2 or more ...
0
votes
1answer
80 views

How to require a cell input if another cell has a value

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I ...
0
votes
1answer
205 views

VBA Solution to VLOOKUP with Hyperlinks

I am looking for some help with a VBA solution for preserving hyperlinks when using VLOOKUP on Excel (2010). I have a load of data on Sheet 1 for internal use only, and a cut-down version of this ...
4
votes
1answer
938 views

Add/Subtract button Excel VBA

Here is an example of my project in this picture I like collecting, so I am making an inventory sheet in Excel. I want to make a way that I can click a button and it affects the next, or previous ...
1
vote
2answers
2k views

Searching for a value in Excel, returning yes or no

I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...
1
vote
3answers
107 views

Trouble using Excel OFFSET function

I have an Excel workbook with numerous sheets entitled "Week1", "Week2", "Week3" ... "Week7". Each week, I input the customers IDs of people buying my product in column C, and -- as I am interested ...
1
vote
1answer
118 views

Excel - Change cell colour based on a date in the comment or mixed in with text

I am using excel 2010 and I am trying to set up a rule that will change the colour of a cell based on a date within that cell. For example the cell may contain Site meeting - 11.05.14 I would like ...
2
votes
3answers
150 views

Listing non-blank cells in Excel based on adjacent column(s)

Given columns A and B, I want to list the A-values that have a non-blank B-cell in their row, in column C: A B C One Two Two x Four Three Four x ... The best I came up with ...
3
votes
3answers
184 views

Custom user function without using VBA

Is it possible to create a custom user function in Excel without using VBA? My problem is I have a long string of standard excel functions strung together to make one very long function. This function ...
0
votes
1answer
155 views

Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100. On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...
1
vote
1answer
344 views

Excel 2010 VBA only affecting last row in range

I have some VBA code written in Excel 2010 to force padding around the rows in a table, but part of the code only affects the last row in the range. Here's the full code: Private Sub ...
0
votes
2answers
414 views

Excel 2010 formula, How do I write this formula? (VBA)

I need a bit of help from the more experienced Excel VBA users. Basically I have 2 groups of 3 cells (6 cells total) If one group of 3 cells is filled in it needs to accept it and not return a ...
0
votes
1answer
790 views

Updating another Excel spreadsheet from current spreadsheet

I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...
0
votes
1answer
216 views

Insert columns, within a range, based on cell reference

So am trying to tell VBA to insert a certain number of columns between two other columsn based on a cell reference. I've managed to get excel to insert columns within my range: Sub INSERT() ...
0
votes
1answer
63 views

compare and update spreadsheets

Please I need some help with excel spreadsheet here. I have two worksheets, one holding the old records and the other holding the current record. What I wish to do is to develop a vba code associated ...
2
votes
1answer
148 views

Excel VBA code Private Sub Worksheet Change Power function not working

I'm making a worksheet where the wind speed defines the potential energy of the location. This value is the basis of a few sheets in the same Excel file. I'm trying to write a code that where I10 is ...
0
votes
1answer
248 views

Generate ordered numeric list in Excel based on cell value

I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to ...
2
votes
0answers
327 views

Splitting an excel 2010 spreadsheet into multiple workbook files based on column value

I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...
1
vote
1answer
121 views

Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc. We are basically trying to ...
-1
votes
1answer
32 views

Need Macro to perform formula based on cell not number

I am working on a budget workbook and in column I (I5-I1135) I have numbers that I need to upon prompt (such as CTRL C) have the numbers divide by 10 then multiply by 12.. Example: cell I5 has ...
2
votes
1answer
163 views

excel vba: to export multiple excel sheet into its designated jpg file

I am working on an excel vba command to export multiple excel sheet to its designated jpg file. I have 16 worksheet in one excel workbook and it would be best to export each sheet into jpg format. ...
0
votes
1answer
377 views

Excel formulas for budgeting sheet (or VBA code)

I'm (an amateur) and I'm creating a sheet to help me with Budgeting. I've got bills that I can enter, but that come at a variety of different intervals. I'd love it if I could enter the total from ...
0
votes
1answer
115 views

Excel 2010 - Show cell contents - wrong number appearance

I was trying to create a simple function in Excel VBA editor. When I click on a cell within the certain range, I want to copy its value into another cell I have set. Private Sub ...