FatalLordes
New Member
- Joined
- Dec 22, 2017
- Messages
- 49
Morning all
So I'm using Excel Online within OneDrive which has a workbook with multiple sheets. Sheet 1 has each row with a load of data relating to the unique entry in cell A. Sheet 2 has rows of data where multiple rows (not necessarily in order) may have info relating to that unique entry on Sheet 1. What I would like to do is create a report that would be listing all the data for each unique entry pulling from both Sheet 1 and Sheet 2. Something like:
Unique One, blah, blah blah, blah
Row One of data in Sheet 2 for Unique One
Row Two of data in Sheet 2 for Unique One
Row Three of data in Sheet 2 for Unique One
Unique Two, blah, blah blah, blah
Row One of data in Sheet 2 for Unique Two
Row Two of data in Sheet 2 for Unique Two
and so on
I know I could figure out how to do it in desktop Excel using VBA but, of course, VBA is not possible in Excel Online. So my question is, can Excel Online produce something like this or am I dreaming? And if it can, how would I look at going about it. I'm no expert but I have worked out to so some fancy reporting before by googling VBA and trial and error, but I have no idea how to approach this for Excel Online or if it is even possible. So I thought I would ask before I waste any time like if it just isn't possible.![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Thanks in advance.
So I'm using Excel Online within OneDrive which has a workbook with multiple sheets. Sheet 1 has each row with a load of data relating to the unique entry in cell A. Sheet 2 has rows of data where multiple rows (not necessarily in order) may have info relating to that unique entry on Sheet 1. What I would like to do is create a report that would be listing all the data for each unique entry pulling from both Sheet 1 and Sheet 2. Something like:
Unique One, blah, blah blah, blah
Row One of data in Sheet 2 for Unique One
Row Two of data in Sheet 2 for Unique One
Row Three of data in Sheet 2 for Unique One
Unique Two, blah, blah blah, blah
Row One of data in Sheet 2 for Unique Two
Row Two of data in Sheet 2 for Unique Two
and so on
I know I could figure out how to do it in desktop Excel using VBA but, of course, VBA is not possible in Excel Online. So my question is, can Excel Online produce something like this or am I dreaming? And if it can, how would I look at going about it. I'm no expert but I have worked out to so some fancy reporting before by googling VBA and trial and error, but I have no idea how to approach this for Excel Online or if it is even possible. So I thought I would ask before I waste any time like if it just isn't possible.
Thanks in advance.
Last edited: