Data Entry Form to Update Numerous Worksheets

[Jennster]

Hi!

I was wondering if anyone could help me with this code?
I have created a userform that will update a worksheet. However, I am wanting to have this same user form update numerous other worksheets as well. Each worksheet will contain the same info but the column order will differ. (I am wanting to do this for other reasons - I appreciate that it can seem a bit strange!)

Can anyone help please?

Here is the code:

Please Login or Register  to view this content.

I've asked this question here too: http://www.mrexcel.com/forum/showthr...ous-Worksheets

[rvasquez]

Hello there,

Could you please provide a sample of you workbook that shows where the columns are located in the other worksheets and what the header rows are named?

Thanks!

[ARGK]

Hi
If the data is the same in each worksheet you can create a link in each cell in each copy sheet to the master and it will pickup the contents of each cell in the master.

Hope this helps.

Tony

[Jennster]

Hi Tony...

Sorry, me being a bit of an excel novice I'm not too sure what you mean ?

---------- Post added at 02:35 PM ---------- Previous post was at 02:34 PM ----------

Rvasquez,

I have attached a sample worksheet in the original post of this thread. It has appeared before I said Hi!

Thank you! :-)