@ 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...
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...
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...
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...
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...
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
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...
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...
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.
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.
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
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
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.