Search:

Type: Posts; User: bvbull200; Keyword(s):

Search: Search took 0.00 seconds.

  1. Thread: Formula Help

    by bvbull200
    Replies
    4
    Views
    132

    Re: Formula Help

    My pleasure!
  2. Thread: Formula Help

    by bvbull200
    Replies
    4
    Views
    132

    Re: Formula Help

    Are you saying that if "L" doesn't appear in any cells across that row, that the result should be 0?

    Does this do what you're looking for?

    =IF(COUNTIF(J5:AN5,...
  3. Personal Workbook Locked For Editing *Only* When Running Macro and Not When Stepping Through

    I have a macro that interfaces with SAP. The SAP portion is for it to run a report and open it in Excel. Excel takes over and activates the workbook, then saves it in a location and converts the...
  4. Re: Simple VBA for Undo - Run-time error '1004'

    Man, I'm a dummy. I forgot about that line. Still pretty green with regards to VBA.

    Thanks for the quick response.
  5. Simple VBA for Undo - Run-time error '1004'

    I have a pretty simple bit of code that I'm having trouble with. All it is supposed to do is Undo the last action, then format a target cell. If it is run twice in succession, I get the error -...
  6. Replies
    2
    Views
    2,967

    Re: VBA - Save As Text (Tab Delimited)

    My apologies. I posted here first, there second.

    Did not meant to offend.
  7. Re: Multiple Drop Down boxes to give a value

    Are you wanting the value under the "Code" heading to change based on the combination of values selected in the first three columns?

    That could probably be solved with a string of IF statements. ...
  8. Replies
    2
    Views
    2,967

    VBA - Save As Text (Tab Delimited)

    I have inherited a workbook that is in need of some maintenance. There is one area where I'm a little stumped.

    At the end of the macro I am working on, I need it to save a single sheet as a Text...
  9. Re: VBA - If a Cell Matches Another Cell, Select Entire Row

    You're the best!
  10. Re: VBA - If a Cell Matches Another Cell, Select Entire Row

    This is very close. I have a lot of steps that are run after the "End If", though. I need those steps to not be run if there is no match. There is more, but basically it looks like this, now:

    ...
  11. Re: VBA - If a Cell Matches Another Cell, Select Entire Row

    I have this working for all cases where cell B3 is a match to a cell in column B on Sheet2. Thanks again for that. I have a new need now, though.

    If the Sheet1 cell B3 does not match anything in...
  12. Re: VBA - If a Cell Matches Another Cell, Select Entire Row

    Holy crap, that worked perfectly!!! Thanks a ton.



    Hmmm...I like the error check. Once I get the other functionality done, I'll revisit this. An error check could be helpful. Thanks a...
  13. VBA - If a Cell Matches Another Cell, Select Entire Row

    I have two sheets. On Sheet1, cell B3 is a value that can be changed based on user input. This value is the vendor code. On Sheet2 is an array of data for every vendor. Vendor name, vendor...
  14. Replies
    6
    Views
    323

    Re: Exported Query Including Macro

    The macro includes adding slicers. I feel like this changes things a little bit since it isn't strictly formatting that is being done.

    I wonder what this will look like if the macro is run...
  15. Replies
    6
    Views
    323

    Re: Exported Query Including Macro

    I'll look more in to this. I'm absolutely terrible with Access, so it'll take a little trial and error, but if it can be exported with the formatting already done, that's a good thing.



    This...
  16. Replies
    6
    Views
    323

    Exported Query Including Macro

    I have a query in Access with a saved sequence for exporting to Excel. I want the Excel file to include a macro that I created saved to it. I'm going to be updating the file once a week or so.

    The...
  17. Re: How to list all combinations from 6 rows

    I think that is it. I'll look over the code. Thanks a bunch!
  18. Re: How to list all combinations from 6 rows

    Edit: Thread title says 6 rows, but I meant 6 columns as detailed in the post. Sorry for the confusion.
  19. How to list all combinations from 6 rows

    I am trying to come up with an easier way to display all possible configurations of various part #s from 6 different columns.

    The part #s would all have the data from only 1 cell in each of the...
  20. Re: New to the site and Macros - Combining macros in to one

    Answered my own question. The combination that I posted in post # 3 actually works as is. I was making it harder than is necessary by thinking that it needed some point where it tells the macro...
  21. Re: New to the site and Macros - Combining macros in to one

    First of all, I sincerely appreciate your willingness to help. Somewhere down the line, possibly having the ability to type in the codes you want and have this run is extremely promising. I'll be...
  22. Re: New to the site and Macros - Combining macros in to one

    Thanks, DeusXv. There are some instances where that will certainly come in handy. It isn't a complete solution for me, though, as there are over 300 vendor codes and in many instances, more than...
  23. New to the site and Macros - Combining macros in to one

    Hello all. I have used this site extensively for a number of questions that I've had, but only now registered. Smart folks on this board, for sure.

    By altering some macros that I found through...
Results 1 to 23 of 23