Conitional copying of a serie of rows from one spreadsheet to another

  • Thread starter Thread starter david
  • Start date Start date
Max

I (hopefully finally but I can't help fiddling with things) want to
create a page similar to the report for each class that could pick up
the student name from the 'Control' Page and only print the entries for
that student for the date ranges.

I anticipated a validation box on the control page that picks up the
student lists for that clas and then entering the start and end date
for this report.

I expected it would be easy to copy and print the previous report but I
get the student i want but also ohers as well.

I tried to upload thisversion to savefile.com but thre is an error and
I can't do it.

Many thanks

David
 
david said:
Thanks Max this seems to be working OK
Click to expand...

Glad to hear that ..
One final question and
please ignore this if I am taking up too much of your time.
Click to expand...

well, it's definitely not in my nature to ignore, and I would post a closure
in threads if I can't help any further ..
I have tweaked the file to add summary pages for each of the 4 classes
together with the printout page which pulls its criteria from from the
'Control' sheet.

What I want to be able to do is print this 'Printout' page via a macro.
So I would select the form from the dropdown box on the control page
and then press a macro button. To do this I presume I need to be able
to detect which is the last line that there is any data in so the print
range can be set- how can I do this?
Click to expand...
the file can be downloaded from
http://savefile.com/projects/857497
Click to expand...

Apologies, I'm not able to help you on the above. You could hang around here
awhile for possible responses from others versed in vba. But since this
thread is quite deep, I would suggest you post afresh your new query in
microsoft.excel.programming for better exposure.

---
 
david said:
I (hopefully finally but I can't help fiddling with things) want to
create a page similar to the report for each class that could pick up
the student name from the 'Control' Page and only print the entries for
that student for the date ranges.

I anticipated a validation box on the control page that picks up the
student lists for that clas and then entering the start and end date
for this report.

I expected it would be easy to copy and print the previous report but I
get the student i want but also others as well.
Click to expand...

As per earlier response today, I'm not able to help you on the above.
You could hang around here awhile for possible responses from others versed
in vba. But since this thread is quite deep, I would suggest you post afresh
your new query in microsoft.excel.programming for better exposure.
I tried to upload this version to savefile.com but there is an error and
I can't do it.
Click to expand...

The free filehost savefile.com may be down at times (just like any site). If
you review one of my earlier responses, I supplied a list of 3 filehosts. We
could always try either of the other 2 if 1 is down.

---
 
Max

Many thanks for everything you have done - you have given me an
excellent start - I will take your advice & re-post.

David
 
david said:
Max
Many thanks for everything you have done - you have given me an
excellent start - I will take your advice & re-post.
Click to expand...

My pleasure' David. Thanks for feedback.
Good luck and all the best !

---
 
Back
Top