Search results

Hello all. I have a challenge I can't quite solve. I attached an example. I need a formula to match two criteria. I found a lot of examples on the Internet of formulas using two criteria. But in my example there is one text criteria and the second criteria is a number that I want to match...

The problem can't be recreated with the reduced file. The formulas are the same except for the column reference so I copied the formulas from a "good" column to the "bad" columns and it took care of the problem. Thanks for your help. You led me to the solution.

I attached a small portion of the file. I had to take a lot out to get the size down to upload it.

Hui, Ctrl+Alt+Shifht+F9 did recalculate all formulas but it didn't permanently fix the problem. If I update the data the formulas in the issue columns still doesn't update. So I started to look at backup files to see if the problem had always been there. What I found is the problem started...

Thanks Hui!

Hui, Everything calculates when I use Ctrl+Alt+Shift+F9. Do you know what this might mean? I'm wondering if the issue is related to my data source. I'm using Oracle Smart View which updates the data directly in Excel. It seems Excel is not recognizing the dependent data has changed when I...

The calculation is set to automatic. I have the same formula for all the data columns with just a different reference for the column lookup. Most of the columns are calculating correctly. Some of the values in the columns that are an issue are calculating correctly. I'm considering...

This is a very strange issue. I have an Index/Match formula that calculates incorrectly when I update the data source. But when I troubleshoot the formula by deleting part of the formula and then clicking undo to return the cell to the original formula the cell calculates correctly. This is...

Perfect! Thanks!!!

I am looking for a quick method, formulas or VBA, to combine data from two lists. I copied a file for an example. The output needs to be a table with two columns; the first column List A and the second column List B. List B needs to be repeated for each item in List A. The total number of...

I just haven't worked on the bottom part of the macro because of this challenge.

In the macro if there is a "True", I have to change the Active sheet to to the report template sheet to calculate and print the report (the report is not in the file I attached). Once I do this I need to return to the Check Box tab and look for the next product item that has a "True". But how...

I am stuck coming up with a solution for a project I'm working on. The goal is to give users the ability to select multiple product levels for printing a report. I created a file with check boxes. I can handle creating a macro that will check where there is a "True" and then have the macro...

Thanks everyone!

Dang it! That was too simple! Thanks!!!

Luke M, I may be more remedial than you are used to. I created the function and a macro with then code you have above and nothing happens. What am I doing wrong. Is there more I need to add to the macro? Do I need to change "Range" to "MyRange" in the function somewhere? I have worked in VBA...

Hello Luke M. Thanks for your help. My list of numbers will often be over one hundred long so I'm definitively looking for a macro solution. Also the range of numbers will vary so I would like the range to be created dynamically. And I'm confused was the code above designed to live outside...

I need a simple macro to combine a list of numbers (rows) into one cell separated by commas. I picture a loop that starts at the first cell and continues until there is a blank. Thanks in advance! :) Input: 9500 9501 9502 Output: 9500,9501,9502

Yes I was trying to make this much more difficult than needed. The simple If Then works fine. Thanks Luke M!

Perhaps I was trying to make this more difficult than it needs to be. I will have to do some testing after a meeting.

I have a macro for a template. In the final step I need it to do an if statement and then do one of either two actions. The macro should stop after whichever direction it goes. Will the two different actions need to be subroutines? If so how do I switch to them from an if statement? I'm...

Well that was easy. Thanks again! You can mark this one as complete!

This does the trick. But I do want to ask a follow-up question because I'm going to use this code for some different variations of templates. I notice the data input has to be in row 1 for the code to work. If it wouldn't require a significant change I would like to know what it would look...

Thanks!!! I want to use the macro approach because the ranges will be changing. And I don't want users to have to adjust the formula range. But I appreciate the extra suggestion!

This is a followup question to an earlier post. I decided I need to have the output on a separate tab. I have the data on "MerchList" tab and I data on "Output" tab. I tried adding two Sheets statements but I get an error after: Sheets("Output").Select Thanks in advance! 'Start Merch...