Formula help

E

eechris

I have a long list of contacts with phone number and a team name and I want
to create sheets of each team member.

Like on "team" sheet I have Green in column I and I want to bring all the
items from Row A-C and G-H to the Green sheet.

Can anyone help with this I would GREATLY appreciate it
 
P

paul.robinson

Hi
Your question is too vague - it is more like a rough idea of a
question. Where are the phone numbers and team names. Does that phone
info come too and how? Is there other info you want too? Where in
column I? Is Green a colour on the screen or a word? Is Green the name
of a team? You have a "team " sheet - are there lots of sheets? Is
info coming from lots of sheets to the Green sheet?? Do you mean Row
1-3 or Column A-C?
See the problem for anyone who can't see what you are looking at?

regards
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for seperating data 1
Comparing two worksheets and highlight unmatched Data 0
change sheet name based on cell 4
Couple subs need help with 2
Search other sheets for numbers & color them 10
find an exact number in a different sheet and use the cell containing the number to output informati 4
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Create if partial match then copy and paste data from one cell to another 1

Top