Hi, I have a problem with a userform that for some reason I cannot seem to work out.
The basic problem is as follows:-
I have a "data sheet" which contains complete order details, complete invoice details and basic Customer details. a separate sheet contains complete customer details.
what i am trying to do is create a multipage user form (no reason for this except i think its a good idea! so if there is a better way please feel free to comment) as follows.
on page 1 - create a report of All invoices unpaid (from the orderdata sheet)
on page 2 - create a report of All invoices unpaid AND overdue (from the orderdata sheet)
on page 3 - create a report of customer names (using the overdue invoice list from the orderdata sheet which has basic customer information + the customer contact details from the CustomerData sheet)
So what i am trying to do is search the relevant sheets for the relevant values, (which i think i have got worked out) and the for EVERY row that contains a match transfer the information to the particular multipage. I have added scroll bars to enable the user to look down the list but am not filling the page with data.
i hope this is clear enough, any suggestions would be grately appreciated.
EDIT - I have just managed to add a spreadsheet to one of the pages on the userform. using this previous thread topic,
http://www.excelforum.com/showthread.php?t=586636&highlight=user+form+multi+page
but cannot seem to find out how to fill it with data from the other sheets within my workbook.......anyone got any suggestions?
Bookmarks