I have a "master sheet" in my spreadsheet and I need to do a fill down. Problem is I need it to goto a different sheet for the information each time on the fill down. The cell on the other sheets are all in the same location.Any help would be good. I have a few hundred cells I need to do this with and manually attaching each one is going to take me days
Jerry
I am a bit confused with the question. "I need it to goto a different sheet for the information each time on the fill down." Does this mean that you do the fill down at different times and maybe the first time you go to sheet1 cells a1 to A100, then the second time you go to sheet2 cells A1 to A100, then sheet3 cells A1 to A100, etc, etc. If you can give me a bit more on how your sheets are set up that would help. If you want, you can e-mail me the workbook to RIRSTRESS@aol.com
Richard
Advertisement