Populating worksheet based on multiple worksheets
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.
|