Forum Discussion

MzTeeRenee's avatar
MzTeeRenee
Copper Contributor
Jan 05, 2023

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

  • dscheikey's avatar
    dscheikey
    Bronze Contributor

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

    • MzTeeRenee's avatar
      MzTeeRenee
      Copper Contributor
      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....

Resources