automatic copying data from sheet 1 to other sheets

[dgharib]

I am looking for help in trying to input specific formula into excel.
What i want to do is have sheet 1 as the main sheet with a master list of all accounts.
And need a formula to input on sheet 2 to copy only certain accounts from sheet 1.
Please see example screen shots below.
Any help would be appreciated.
Thank You!!!!!
SAMPLE EXCEL SHEET.xlsx

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[mikeTRON]

I would use pivot tables for that.

See attached.

PivotTable with Slicers.xlsx

[hoyasaxa215]

An array is another way to possibly accomplish this.

[FDibbins]

Thanks for the title change

See if the attached, using regular formulas, will give you what you want...

[dgharib]

thank you for everyone help,

this seams to work for data that's already there. but if I add data to sheet 1 I need to to automatically to be placed in the other individual account sheets where it belongs.

is this possible?

[dgharib]

the pivot table seams to do the trick for what i need.

Is there a different way or I would just use this table.

[hoyasaxa215]

Just change the references in the formulas. If your data extends past row 9, then just change the number 9 to however many rows of data you have.

[dgharib]

Thank you!!

FDibbins

This formula works perfect.

If possible can you edit it for it to work with another sheet.

I tried to make the changes but cannot figure it out.

Sheet is attached.

Thank you so so so much!!!!!!!!

[dgharib]

Thank you!!

FDibbins

This formula works perfect.

If possible can you edit it for it to work with another sheet.

I tried to make the changes but cannot figure it out.

Sheet is attached.

Thank you so so so much!!!!!!!!

[FDibbins]

If you were refering to my suggestion, it is based on that small formula I put in J1 on each sheet (you can hide that if you want)
=RIGHT(MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255),3)
It pulls out the sheet name for that sheet, and that needs to be copied to all of your sheets - in that same position

Apart from that, it doesnt really look like you tried to use what I gave you at all?

[dgharib]

FDibbins

I made a new sheet and added columns. I tried to copy the same formula as the first sheet and want it do exactly the same as first sheet, but it just keeps giving me blanks.

Just need the same formula on new excel book that I edited to make more "fancy"

If we can do the same you did to first sheet, just on the new one I attached.

Im not very good on excel I do not understand how to use the advanced formulas.

[dgharib]

I tried to input the formulas in the attached just like the first sheet you did but it is not returning the information as the one you did.

Not sure what im doing wrong :/