using value in cells to populate VBA code

[bruno2580]

Hi guys just wondering if anyone could help me.

I use a admin spreadsheet to track my work groups administration and reporting for my boss with the network we use it requires to save on the members profile when they log in and i am trying to make this simple so all members that are in my position can easily use this document on there workers.

Im trying to figure a way were i can refer to sheet Data for particular things within the VBA code is this even possible.

You will see in my template i have a sheet for each work colleague and a overall sheet.

key things i am looking at trying to populate from the data sheet are workers names workers emails so it automatically sends to them and the bosses profile, this way members wont need to change the code they just change Data sheet.

Thanks in advance for any assistance.

[torachan]

try to save all your data to a 'pseudo database' structured table format - then have a single report template instead of individual personal sheets.
for data storage and manipulation do not use merged cells they cause all manner of problems manipulating data.
I know this is a big ask, however it will save you and anyone assisting you a lot of heartache.