Help!

Automatically pulling specific data into a separate spread..

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Sharing Contacts - how to see when creating an em..  
Author Message
HectorLPerez
External


Since: Jul 01, 2009
Posts: 1
PostPosted: Wed Jul 01, 2009 7:07 am    Post subject: Automatically pulling specific data into a separate spreadsheet
Archived from groups: microsoft>public>excel>misc (more info?)
I have a master spreadsheet that has information on 12 different facilities.
I want to set up 12 separate spreadsheets for each individual facility that
will automatically pull certain columns of information from the master sheet
into the new sheet when a new row for that facility is added. So I am
thinking the formula should have something like : IF A4:A200=FacilityA pull
info to FacilityA Spreadsheet , IF A4:A200=FacilityB pull info to Facility B
Spreadsheet
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum