hi - i have a question, how can i make a copy of data in different sheets from master file without doing a re-done-done typing.
my reference is on column D with.
thanks!
nelcee
hi - i have a question, how can i make a copy of data in different sheets from master file without doing a re-done-done typing.
my reference is on column D with.
thanks!
nelcee
Hi nelcee
I would suggest 2 options:
1/ Use Index and match to look up the values from your 'Masterfile' sheet and put them in the cells you want to have filled up.
=INDEX(Return_value_range; MATCH(Lookup_value; Lookup_value_range; Match_type))
Return_value_range The range that holds the return values
Lookup_value The value you want to find in the lookup value array
Lookup_value_range The range containing lookup values
Match_type Exact (0), Nearest Less Than (-1), or Nearest Greater Than (1)
2/ Go a bit further and use PivotTable Report Filter Pages. You will need to invest some time first, to win time and great flexibility afterwards. Once this is set up, you only have to worry about the input ('Masterfile'). Output (all the other sheets) is easily generated (and re-generated) with a few clicks.
2a/ Turn your data into a Table (Insert > Table).
-->This is optional, but I recommend it because it turns your data in a dynamic range. Also, input and manipulation are easier.
2b/ Create a PivotTable based on your Table ( Table Tools > Design > Summarize with PivotTable) (OR: Insert > PivotTable)
2c/ Set up your PivotTable, putting your column D 'Account Names' in the Report Filter
2d/ Create a worksheet per Account Name. (PivotTable Tools > Options > Options > Show Report Filter Pages)
If you're new to Tables and PivotTables, I'dd suggest to find some tutorials and play around with them.
Good luck!
Sleezypeazy
Please hit the star icon if I helped. Thanks.
hello sleezypeazy,
thanks for the reply. i'll try to figure out your suggestions.
i'll give you feedback for the progress
thanks!
nelcee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks