Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jhabey01

    VBA to Insert Page Breaks that will Keep related Items Together

    Thanks for all the posts on this got everything working just fine
  2. jhabey01

    VBA to Insert Page Breaks that will Keep related Items Together

    @ Andy, no I do not want a page break at every new group name. I want to keep the groups or together on a page and only go to a new page if the group can be kept together, Please see earlier explanation I think Paul understands best and his code seems to work fine only if I have a small number...
  3. jhabey01

    VBA to Insert Page Breaks that will Keep related Items Together

    Hello, I think that Paul's code is very close. I took a look at it this afternoon and it works when the report is only at most two pages. What I mean is that what if I had 40 Group names, the code keeps all of the Group Names on page one, but on the remaining pages the page print is not keeping...
  4. jhabey01

    VBA to Insert Page Breaks that will Keep related Items Together

    The requirement is to have no page break where the group name is the same. I am looking to not have a group split between two pages. The page break has to be coded such that it keeps all of the Clients with in the row titled GroupName together on one page. I would prefer to be able to have...
  5. jhabey01

    VBA to Insert Page Breaks that will Keep related Items Together

    Hello, I am stuck on the approach I want to take, I know what I want but not sure how to get there conceptually. I may not need code here persay but some direction on solving this. @ Andrzejek will this approach put a client on each page or can I group a number of clients together until it...
  6. jhabey01

    VBA to Insert Page Breaks that will Keep related Items Together

    I have been thinking about this for awhile, and I am not sure where to even begin. I have a report like the attached that I produce every month. I would like to keep the information that pertains to the Group Name together on the same page. The last row pertaining to any group is the Group...
  7. jhabey01

    VBA to Use Highlighted Data as A Defined Name

    Sure, I want use the data selected and create a defined name called CurrentMTH. The defined named will be that data that was selected all 150 cells will now be a definednamed called CurrentMth
  8. jhabey01

    VBA to Use Highlighted Data as A Defined Name

    Hi, I have the following code which just highlights all the data in a worksheet. I want to take that data that is highlighted and use it to define a name such as CurrentMTH, I have a few things none of which are working. Any thoughts? Sub DynRange() Dim sht As Worksheet Dim LastRow As Long...
  9. jhabey01

    Using VLookup In VBA

    I have another little twist on the above code from Oct 20. I want to concatenate to columns to make that the look up value. The two colums are column A which is labelled ClientName and Column H which is labelled Plan. Instead of the look up value being Col H . Client Name Plan Greenway...
  10. jhabey01

    Using VLookup In VBA

    Thanks for reply back I stepped away from this for a couple of days and started looking at it again this afternoon and within a half hour I had working.
  11. jhabey01

    Using VLookup In VBA

    Now that would downright silly of me not to do that. Yes I did. I just sent mocked up data. So the Named Ranges that I uploaded would be correct? It has got to be close to working guess I just need to keep toying with it.
  12. jhabey01

    Using VLookup In VBA

    Ok I did that. I just wanted to provide the file I was using to see if what I have is correct. Now instead of a name error I am getting a #N/A error
  13. jhabey01

    Using VLookup In VBA

    Attached is the look up table I would be using. I seem to be missing the named ranges part. I have two name ranges . Are they named correctly? http://www.tek-tips.com/http://files.engineering.com/getfile.aspx?folder=7c33c46f-4278-498a-9c41-eb78437992c7&file=PlanDescriptions.xlsx
  14. jhabey01

    Using VLookup In VBA

    When I run the above code provided by Skip, it is returning a #NAME? any thoughts as how to resolve. ( The code should look up a value and return its description of that value.)http://files.engineering.com/getfile.aspx?folder=d2a7746c-886a-45c8-add0-56d0983b1c12&file=ClientData_1.xlsm
  15. jhabey01

    Using VLookup In VBA

    Thanks it works! I appreciate your help.
  16. jhabey01

    Using VLookup In VBA

    Not sure what you mean by: Be sure to SELECT the entire table before executing this process.
  17. jhabey01

    Using VLookup In VBA

    I am getting an: Application Defined or object Defined error at the following line: .Cells(r.Row, .Range("PlanDescription").Column).Value = xl.Index(ws.[Description], xl.Match(r.Value, ws.[Plan], 0), 1) trying to diagnose this morning.
  18. jhabey01

    Using VLookup In VBA

    All I want the code to do is open up one of the companies workbooks go to the plan description column do a v look up on plan and return the plan description to column I (PlanDescription) for all the rows that have data copy and paste column I as values so as to not have a formula in that cell...
  19. jhabey01

    Using VLookup In VBA

    Understood, but the data from each company unfortunately is obtained one company at a time I can't get my hands on it any other way. I take what I am given and try to implement my solution around that. I don't mind writing code to get around lifes imperfections and this is what I came up against...

Part and Inventory Search

Back
Top