Formula needed

Hi all

Im doing a workbook that has a total of 7 sheets. What i want to do is on the first sheet column A has a list of names, which has over 200 rows.Column B has the financial year ends. I have created a form with a text box and have the button on the first sheet. When you click on it, the text box will open and then you type in the financial year end and click ok. All i want it to do is any of the names in column A of that financial year end to copy to the 7 sheets. Their can be upto 15 names. But for the life of me i can't seem to work out the code i need.

Boy i hope i make sense.

Can you post your workbook with your attempts so far.

Uploaded to my folder now how do i post it here

Wendy

Bob can either fetch it from there by clicking on your user name or you can attach it by clicking on the options tab when you are composing or replying to a post.

For this occasion I'm sure Bob will fetch it to stop duplication but if you wanted to post it you could delete the one on your profile

Thanks Nick

I'll leave it their saves on duplication

Hi Wendy

I have downloaded your file, but I am not at all clear about what you want to do.
Can you provide detailed instructions about what you want to achieve.

Hi Roger

When you click on the FYE button on the 1st page of the spreadsheet. A box will pop up. When i type in the financial year end of a building Column B. I want just the buildings in Column A that match that financial year end to copy into the rest of the sheets.

Hi Wendy

Unfortunately there is still not enough information to provide a comprehensive answer, but the code in the attached file may help to get you started.
Fo instance, you say to copy to all sheets, but I am not certain that is what you want.
You do not say whether you want existing data to be cleared from those sheets first, or whether the data is to be appended.

Basically, I am not using your Form at all, instead I have attached my macro to the button on your sheet.
I have added an autofilter to A2:G2 on sheet Building Master
When you run the macro, it asks for the date of the Financial Year end.
It then filters on column C for this date and copies the data from column B

It then finds the next available row on Sheet FYE Account Preparation, and pastes the values in column A at that point.
(Note, I am starting the count of rows from Row 25 upward, as it appears you have another table below. This is what makes me wonder whether you want to clear the exiting data first, as opposed to appending, as otherwise you will eventually overwrite your second table on the sheet)

It then proceeds to do the same thing for sheet Meeting Preparation.

You can add the same block of code to deal with whichever other sheets you wish, having determined where on each sheet you wish to Paste.

Hopefully this will get you started.