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!

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

auto create new sheets on change of record?

Status
Not open for further replies.
angelandgreg

angelandgreg

Technical User
Sep 20, 2006
106
US
Is there a macro that can take the data from the 1st sheet and copy the data into another sheet per sheet everytime the 1st column row data changes?

I have an Excel file where it's link to MS Access and can refresh sales data.

It has all the reps on this and I need some way of taking the data from the 1st sheet per rep into other sheets in the file and name the sheet to the rep.


I hope this made sense and someone can help. I have seen something like this but have no idea how to write something to make this happen.
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
327
remeng
remeng
S
  • Locked
  • Question
MS Project - how to add a new task into an existing baseline
Replies
0
Views
203
selazar
S
kwbMitel
  • Locked
  • Question
I can't add sheets to my Excel file because it's protected.
Replies
4
Views
2K
StilLearningAlot
StilLearningAlot
E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
738
SkipVought
S
TrekBiker
  • Locked
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
687
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top