Info from 6 different worksheets populating one Master sheet

[Designia]

Hi Guys,
(EXCEL 2003) I did a search for auto populating on the forums but none of the problems were quite my problem. Also I'm not a whiz on code so please be gentle with me. And of course I'm an Excel n00b.
I have 6 worksheets for 6 separate ad reps that will be populated with customer info. To make my life simple I just want column A from each of the 6 worksheets to show up on a master sheet in column A. But what also needs to happen is if we add and delete customers that also needs to happen on the master. I understand the "=" and then pointing to a cell in another sheet and hitting enter. I got that to work but I just have soooo many cells to work with that would just be way too time consuming.

I'd appreciate any help you can give me and let me know if you need any other info.
Thanks very much!!

[FDibbins]

Hi and welcome to the forum

If you already have the =A1 bit, and want top copy it, if you click on the cell with the formula and look at the bottom rt corner, you will see a very small black square "on" the corner. You can just click-and-hold on that and drag it down as far as you need.

It might help if you uploaded a sample of what you are working with, we may be able to simplify things for you?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Moo the Dog]

Here is some VBA from Microsoft (via Ron DeBruin) that copies all values in column A (A2:Axxx) from every sheet in your workbook, to a newly created "Master" sheet:

Please Login or Register  to view this content.

It won't update automatically, but you can use another macro to 'listen' for changes in column A of any of the sheets that will trigger this macro to run.

See the attached example workbook.

- Moo