What I want to do seems frustratingly simple ....... Macro?
Hi,
. It probably is so simple that even a beginner like me could have a go for you as a bit of practice some time over the next couple of days. There are also probably lots of different ways to do it so it is difficult to give you exact instructions, especially as we do not know exactly what you want, or how your sheets look.
. It would be most useful to have an example copy of your Spreadsheet Tables / Sheets showing the data to be pulled into the overview sheet and a manually made short example of how you want the overview sheet to look like finally.
To do this:-
. 1 Either type this info to us in a reply manually, (or use some sort of “screenshot”)
or if you are able try any of the following:
.2 Follow the instructions for downloading the Excel Table / Spreadsheet maker program (It is free) “MrExcel HTMLMaker20101230” – the second link in my Signature below. The download (again it is free) is the last link in my signature below.
.3 My Favorite: You can upload your workbook to
FileSnack | Easy file sharing (Again that is free after registering), mark the workbook for sharing and then copy and paste to us the link given for your workbook. Again it would be useful if you include in your workbook a short manually written overview sheet showing how you want it to finally look like. ( Note: I use
FileSnack | Easy file sharing a lot and find I can upload anything if I am using Internet Explorer 9. If you use Google Chrome Internet Explorer you may need to “Zip” the file before uploading.
. It does not need to be a full workbook, but should have an example list of all the different sorts of sheets and data you have.
. Once I have that file I could have a go at writing the code and then send the final workbook with code back to you.
. (There are other file sharing things out there I think, that you may prefer to use, for example
https://www.box.net/de_DE/home/ but I have not tried them yet. I noticed that some experienced users of this board use
FileSnack | Easy file sharing )
Alan