I need a macro to move data from a master sheet.

[tirwin]

Hi I have a workbook in which I keep client information, it has 8 sheets. I would like to be able to enter the information on the master and have it populate to the other sheets, however not all the sheets contain all the data and columns are not always in the same place.

[xladept]

Hi tirwin,

Checkout "MasterPeuList" on my website xladept.com and see if that's what you want.

[tirwin]

Hi xladept,

That appears to be similar, my master sheet has 24 columns, and my other sheets need to take data from the master sheet, not all columns appear on the other sheets.

[xladept]

Good - maybe you can adapt it to yours!

[tirwin]

I will try. Thank you for your help.

[xladept]

You're welcome! (Feel free to consult me on particulars.)