Auto copying data from master sheet to minor sheets

[Claire505]

My first sheet has a volume of data from column 1 to column 7, in which column 7 is a list of company names FT, VM, DC ect.
Can the whole row of data be sent to separate company name sheets - so row including FT copies to the FT Sheet for example?
I have about 5 pages of data and input a fair amount daily which I would really like to have auto transferred to the company name sheets as I input the data rather then having to copy and paste everything.

I'm not very technical so a breakdown would really, really be appreciated. I know someone here will have the answer for me.

Thanks in advance

[dflak]

I think things would go better if you attach a sample workbook.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Claire505]

mock up 1.png
Mock up 2.png

I hope this might help... First page is the overview of accounts in and out. Second sheet just shows the information relevant for that company.

[dflak]

It looks like you already have a spreadsheet set up. I'm not going to take the time to reproduce it. In this case, the spreadsheet is small enough to reproduce manually. I am being deliberately picky. I don't think I am alone when I say that I don't feel like re-accomplishing work you've already done.

The bottom line is: in most cases, verbal descriptions and pictures are *not* enough. If you expect someone to work on your issue, then you need to attach a sample file with good, representative data and, if needed a "before" and "after." Pictures of the before and after do help, but we need the file itself.

Now, onto this particular issue. I get what you need to accomplish, but have additional questions. Are the company names Fixed? That is, when you make the workbook, do you also set up tabs for the companies or do you expect the program to detect when a new company appears and create a page for it.

Also how do you want to handle the case where you have a row of data and then go back and change the company name?

[Claire505]

Thanks for taking the time to write back to me.

I see the issue is going to more hassle then it is worth... Stupidly believed it may have a simple formula to transfer it across.

I think we'll just stick with good old 'copy and paste' for the time being.

Thank you again

[PaulM100]

See attached.

[Claire505]

Wow... There's some very clever people out there. Wish I knew were to begin with Macro's.

Thank you Paul. I love the save name too. I'm not Lazy, just very, very old!!

Kind Regards

[PaulM100]

This macro is creating new tabs with the company names found in column F. If you already have data in sheets named so and that data is not found in the Master Sheet it will be deleted. Also, if you will use this code then you will have to change the name of the Master Sheet to "Overview" as I can see above , instead of "Sheet1".
But if it takes care of your problem, please mark this tread as SOLVED. Thanks.