EXCEL AUTO FILL DATA FROM MULTIPLE WORKSHEETS

Copper Contributor

I'VE HIT A MAJOR PROJECT AND NEED SOME (EXCEL FOR DUMMIES TYPE) HELP. I WOULD LIKE TO INSERT DATA IN THIS SHEET FROM OTHER SHEETS WITHIN THE SAME WORKBOOK. THE INFORMATION I WOULD LIKE TO FILL WITH ARE LOCATED IN ROWS NOT COLUMNS. HOW, IN THE WIDE WORLD OF EXCEL WOULD I BE ABLE TO MAKE THIS HAPPEN. THANX IN ADVANCE, I KNOW THIS IS A TALL TASK, FOR ME ANYWAY. ANY ASSISTANCE IS GREATLY APPRECIATED

2 Replies

@MzTeeReneeCopy your data and then paste it into the right place using "Paste Transpose". Try it with this.

Maybe I'm not sure what it is I am trying to do. Lemme say.... I have an Excel worksheet with info situated in rows. I would like to take that info and fill a checklist of sorts......which i have previously attached. Maybe I should try autofilling a Word doc instead of Excel....