FNMGR wrote:

I have 86 worksheets with data that I need to populate an "upload"
sheet. Each worksheet will have its own column. I manually did the first
sheet and really dont want to have to do 85 more.. Is there a macro i
can use to do this for me? My file exceeds the max limit here, so if
anyone needs to see it then I can email it or find another way to upload
it.

Shouldn't be a problem. Either upload your worksheet to one of the bazillion
filesharing sites, or just post some sample data -- what the 86 worksheets
look like, what the upload sheet looks like, and what data on the 86 needs to
go to the upload.

--
I'd much prefer hiring someone who nailed it
than someone who took twenty lines to get it wrong.