code needed to copy cell data to a newly generated tab

Try this macro. First enter the location and who is hosting the meeting in your "Master" sheet. Then enter the data in B3.

Please Login or Register  to view this content.

Hi Mumps1,
that works like a dream!
the only problem that I have is that because its an events diary the rows are set out in months, so I could add an event for April which would mean me entering the the data on rows b18, b19 etc and then one in December which could be on rows b26, b27 etc, so I cannot specify actual columns or rows if that makes sense?
The new tab generates from any cell within the column 'B' as I set the range from b2:b1000, could the same apply to the code you have just written for me?
The more I think about it the more impossible I think it is, but hats off to you for this code as it does work how id like it just not exactly.

Thanks

Could you post a copy of your file with a detailed explanation of what you would like to do?

Hi,
What i am wanting to happen is when you enter an event in the B column for the new tab to contain the data that has been filled in in the B, C, D cells to auto fill in the new tabs B1, B2, B3 etc.

The code you supplied works fine but only fills in when you specify a cell range in the code.
As I could be entering an event anywhere on the spreadsheet as in is in months I wont know which cells to enter in the code.
For example if I fill in b3, c3 and d3 on the events tab, a new tab opens named after the data I entered in cell b3. then the new tab has the data in cells b1, b2 and B3 which I entered on the events tab.

The problem is if I then enter data in cells b16, c16 and d16 the new tab generates but will not copy the data into the b1, b2, b3 because I havent specified the range in the code.

Hope this makes sense.

Thanks

http://snk.to/f-c7kfri8p

Try this code. Because it is a Worksheet_Change event, the macro will be triggered when you enter the event name in column B and then exit the cell. This means that the event name must be the last cell entered. First fill in the venue, then the organisation and finally the event name. If this is awkward, you could put the event name in column D. This would help in entering the event name after the venue and the organisation. If you do this, let me know because the code will have to be changed slightly. As well, I noticed that the organisation is in cell B4 in the template not B3 so I allowed for that. If this is not correct, please let me know.

Please Login or Register  to view this content.

Perhaps I should have suggested this macro from the beginning. It will work without having to change the order of your columns. The macro is now triggered by entering the Lead Organisation last so that you can enter the data in order.

Please Login or Register  to view this content.

Hi Mumps1,
That is incredible!both work great. If I need to make any changes im sure I can work them out myself.

Thanks again

My pleasure.