fergie_excel
New Member
- Joined
- Jun 6, 2017
- Messages
- 1
Hello,
I've been struggling with this problem for nearly a week and any help would be fantastic.
I have a data source with a large number of columns:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Ref No
[/TD]
[TD]Date
[/TD]
[TD]other1
[/TD]
[TD]other2
[/TD]
[TD]other3
[/TD]
[TD]4
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]7
[/TD]
[TD]8
[/TD]
[TD]9
[/TD]
[TD]Scheduled
[/TD]
[TD]Sent
[/TD]
[TD]timestamp
[/TD]
[/TR]
[TR]
[TD]000
[/TD]
[TD]11/03/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]yes
[/TD]
[TD]yes
[/TD]
[TD]1344
[/TD]
[/TR]
[TR]
[TD]001
[/TD]
[TD]12/03/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]no
[/TD]
[TD]yes
[/TD]
[TD]1216
[/TD]
[/TR]
[TR]
[TD]002
[/TD]
[TD]13/04/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]yes
[/TD]
[TD]no
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]003
[/TD]
[TD]14/04/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]no
[/TD]
[TD]yes
[/TD]
[TD]1432
[/TD]
[/TR]
[TR]
[TD]004
[/TD]
[TD]15/05/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]no
[/TD]
[TD]no
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
each ref no is report that gets sent via email by a user doing so by scheduling it via an excel user form I have made.
When the user schedule's the report to be sent the row and column relating to it is also updated to show whether it has been scheduled or already sent, in some cases scheduled to be sent for a second time (show by both columns value = yes), the time stamp is updated at the point of being sent.
from the data source (Table1 - also dynamic) I need to display in a separate table only those reports that are currently scheduled but is automatically updates whenever a reports scheduled status is changed.
Table2 only needs to list the report ref number, the date, scheduled, sent and time stamp columns.
Table 1 is contained on a sheet called "all_reports"
Table 2 would be contained on a separate sheet labelled "next_sched"
if its possible, I would like to bypass making the separate table and sheet all together and have the data displayed in a listbox with 5 columns on a userform.
Currently I have a listbox (called "AllReports") which displays table1 on the userform, But I have no idea how to display only specific columns and rows based on a criteria.
Hopefully I've described this ok, Any tips and advice would be great, If anymore info is needed please ask.
Thanks in advance
Fergie
I've been struggling with this problem for nearly a week and any help would be fantastic.
I have a data source with a large number of columns:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Ref No
[/TD]
[TD]Date
[/TD]
[TD]other1
[/TD]
[TD]other2
[/TD]
[TD]other3
[/TD]
[TD]4
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]7
[/TD]
[TD]8
[/TD]
[TD]9
[/TD]
[TD]Scheduled
[/TD]
[TD]Sent
[/TD]
[TD]timestamp
[/TD]
[/TR]
[TR]
[TD]000
[/TD]
[TD]11/03/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]yes
[/TD]
[TD]yes
[/TD]
[TD]1344
[/TD]
[/TR]
[TR]
[TD]001
[/TD]
[TD]12/03/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]no
[/TD]
[TD]yes
[/TD]
[TD]1216
[/TD]
[/TR]
[TR]
[TD]002
[/TD]
[TD]13/04/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]yes
[/TD]
[TD]no
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]003
[/TD]
[TD]14/04/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]no
[/TD]
[TD]yes
[/TD]
[TD]1432
[/TD]
[/TR]
[TR]
[TD]004
[/TD]
[TD]15/05/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]no
[/TD]
[TD]no
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
each ref no is report that gets sent via email by a user doing so by scheduling it via an excel user form I have made.
When the user schedule's the report to be sent the row and column relating to it is also updated to show whether it has been scheduled or already sent, in some cases scheduled to be sent for a second time (show by both columns value = yes), the time stamp is updated at the point of being sent.
from the data source (Table1 - also dynamic) I need to display in a separate table only those reports that are currently scheduled but is automatically updates whenever a reports scheduled status is changed.
Table2 only needs to list the report ref number, the date, scheduled, sent and time stamp columns.
Table 1 is contained on a sheet called "all_reports"
Table 2 would be contained on a separate sheet labelled "next_sched"
if its possible, I would like to bypass making the separate table and sheet all together and have the data displayed in a listbox with 5 columns on a userform.
Currently I have a listbox (called "AllReports") which displays table1 on the userform, But I have no idea how to display only specific columns and rows based on a criteria.
Hopefully I've described this ok, Any tips and advice would be great, If anymore info is needed please ask.
Thanks in advance
Fergie