T
ten
Hi,
I have an PivotTable as a basis for some budget inputs. To
have data put in, I need to copy this to a new
spreadsheet, but still keep my sorting based on the first
column from the PivotTable, where I have a lot of
Properties. Later in the process, I want the user to
select one of the Properties (for instance by using some
AutoFilter?), and e.g. print out all the corresponding
rows for this Porperty.
Do anybody have a good solution?
I guess I could use a variant where I put the Property-
names in the corresponing columns, have the user select a
Property using AutoFilter, and then print all the visible
rows with columns (or something). However, I then have to
manipulate the AutoFilter with a * because I also like to
have the Total sum og that Porperty with me.
In basis I would like to populate a user list over all my
Properties, have the user select the Porperty they like
from that one, filter out so that only rows for that
property shows (including Total sum) and then manipulate
the data form there. Then I need:
1) How to make a user list for all my Properties? And show
it to the user for selection. Here I only want the
Porperty-names, not the corresponding Total Sums-rows
2) How to select all Property-rows for that Property (do I
have to populate all the blank cells in the first row with
the Porperty-names?)
3) How to filter including the total sum: I guess I could
manipulate the Input form the User list using a *:
Selection.AutoFilter Field:=1, Criteria1:="*PropertyName"
4) How to select all "visible" rows, for e.g. print (the
print itself I manage)
Sorry for my long question, but really appreciate good
solution(s) for one or more of my questions - thx!
I have an PivotTable as a basis for some budget inputs. To
have data put in, I need to copy this to a new
spreadsheet, but still keep my sorting based on the first
column from the PivotTable, where I have a lot of
Properties. Later in the process, I want the user to
select one of the Properties (for instance by using some
AutoFilter?), and e.g. print out all the corresponding
rows for this Porperty.
Do anybody have a good solution?
I guess I could use a variant where I put the Property-
names in the corresponing columns, have the user select a
Property using AutoFilter, and then print all the visible
rows with columns (or something). However, I then have to
manipulate the AutoFilter with a * because I also like to
have the Total sum og that Porperty with me.
In basis I would like to populate a user list over all my
Properties, have the user select the Porperty they like
from that one, filter out so that only rows for that
property shows (including Total sum) and then manipulate
the data form there. Then I need:
1) How to make a user list for all my Properties? And show
it to the user for selection. Here I only want the
Porperty-names, not the corresponding Total Sums-rows
2) How to select all Property-rows for that Property (do I
have to populate all the blank cells in the first row with
the Porperty-names?)
3) How to filter including the total sum: I guess I could
manipulate the Input form the User list using a *:
Selection.AutoFilter Field:=1, Criteria1:="*PropertyName"
4) How to select all "visible" rows, for e.g. print (the
print itself I manage)
Sorry for my long question, but really appreciate good
solution(s) for one or more of my questions - thx!