I'm back again on bended knee.
Thank you to FormR for their help previously with renaming sheets.
Today's issue is slightly different however it encompasses some of the same problems.
So, my workbook currently comprises of 3 sheets
Main, Imported, Data
Main is the Main Menu
Imported is a copy of a sheet inside a particular network based workbook, this is imported through the use of another macro
Data is where user configurable information is stored.
The issue I have revolves around both Main and Data.
My Main Menu has an update records button on it which when clicked runs a macro to split the imported data worksheet up into seperate sheets based on a cell value called "code"
The sheets are named using this code value
The next step is to update a drop down list on Main with the name of the sheets that are available. At present I can only get it to display the code as the name but instead what I want it to do is pull info out of Data and use that as the drop down values.
For example
Data sheet
[TABLE="width: 500"]
<tbody>[TR]
[TD]0007[/TD]
[TD][/TD]
[TD]Agency Supply[/TD]
[/TR]
[TR]
[TD]0812[/TD]
[TD][/TD]
[TD]Training - Staff
[/TD]
[/TR]
[TR]
[TD]0864[/TD]
[TD][/TD]
[TD]Insurance[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD][/TD]
[TD]Repairs[/TD]
[/TR]
[TR]
[TD]3941[/TD]
[TD]ATT[/TD]
[TD]Attendance[/TD]
[/TR]
</tbody>[/TABLE]
When the worksheets are created and named 0007, 0812,0864 etc. I would like the drop down on Main to include Columns A, B and C for the respective sheet using A1 & " - " & B1 & " - " & C1 etc, e.g.:
0007 - - Agency Supply
0812 - - Training - Staff
Is this even possible or am I asking way too much?
Thank you to FormR for their help previously with renaming sheets.
Today's issue is slightly different however it encompasses some of the same problems.
So, my workbook currently comprises of 3 sheets
Main, Imported, Data
Main is the Main Menu
Imported is a copy of a sheet inside a particular network based workbook, this is imported through the use of another macro
Data is where user configurable information is stored.
The issue I have revolves around both Main and Data.
My Main Menu has an update records button on it which when clicked runs a macro to split the imported data worksheet up into seperate sheets based on a cell value called "code"
The sheets are named using this code value
The next step is to update a drop down list on Main with the name of the sheets that are available. At present I can only get it to display the code as the name but instead what I want it to do is pull info out of Data and use that as the drop down values.
For example
Data sheet
[TABLE="width: 500"]
<tbody>[TR]
[TD]0007[/TD]
[TD][/TD]
[TD]Agency Supply[/TD]
[/TR]
[TR]
[TD]0812[/TD]
[TD][/TD]
[TD]Training - Staff
[/TD]
[/TR]
[TR]
[TD]0864[/TD]
[TD][/TD]
[TD]Insurance[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD][/TD]
[TD]Repairs[/TD]
[/TR]
[TR]
[TD]3941[/TD]
[TD]ATT[/TD]
[TD]Attendance[/TD]
[/TR]
</tbody>[/TABLE]
When the worksheets are created and named 0007, 0812,0864 etc. I would like the drop down on Main to include Columns A, B and C for the respective sheet using A1 & " - " & B1 & " - " & C1 etc, e.g.:
0007 - - Agency Supply
0812 - - Training - Staff
Is this even possible or am I asking way too much?