Hi,
I've put some data in a table that gives marks into an array and want to display it in three separate tables. One for Maths only another History only and Finally Biology only.
I can do the first one but is it possible to do this for History and maths. See attached showing desired output.
Please Login or Register to view this content.
There's no data / output in the workbook.
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
Correct attachment added
Hi batchjb69,
maybe so
Please Login or Register to view this content.
Try this for your data in "A1:D5"
Results in rows below:-
Regards MickPlease Login or Register to view this content.
Try this in a new module:
Please Login or Register to view this content.
Thanks and what would I do if I wanted two columns of data for example History and Biology. If I had a big spreadsheet with say 25 columns of data is it possible to put the data in an array and extract and variation of column e.g columns 1, 5 & 8 or 3,20 & 25 into a new table. I know it can be done with copy and paste but with large data sets this is very slow.
If your data is in the same format, then you can just change the "rng" variable to whatever your full range is. So if you have one column of names and 15 columns of classes, then this:
Becomes:Please Login or Register to view this content.
Is that what you meant?Please Login or Register to view this content.
More if you had say 20 columns is there a way to put multiple data into another sheet. After putting the data set into an array.
e.g for output one sheet you could have data from columns 1,2 and 3 of input sheet
sheet 2 you could have data from columns 1, 2 ,5 & 7 of input sheet
sheet 3 you could have data from columns 1,8, 9 ,15 & 18 of input sheet
This might help.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
See the array line in bold - change the numbers in there to include whichever columns of data you want copied. Run it on the Test sheet in the attached file. Hope that helps. MM.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks