Forum Discussion
MzTeeRenee
Jan 05, 2023Copper Contributor
EXCEL AUTO FILL DATA FROM MULTIPLE WORKSHEETS
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
- dscheikeyBronze Contributor
MzTeeReneeCopy your data and then paste it into the right place using "Paste Transpose". Try it with this.
- MzTeeReneeCopper ContributorMaybe 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....