Tasks for work

Hi all, firstly just found this forum after doing a google search to attempt to answer the questions I have. A great idea and I'll probably end up being around here a bit!

Right, I have some things that I need for work that if I can get sorted will save me a huge heap of time.

First task....

I need to create a file that will do a target sheet every week for the staff, allowing them to write down their income for the session and compare it to the income from last week. I already have a file set up, but I have to copy income data into it every week after I have already put it into another spreadsheet. This is a pain, to say the least because we have different departments at work and I have to do a sheet for each one.

Ideally, I'd want a spreadsheet for my target figures where I would tell it to look, say, at the income figures for week one. The next week when I want to do the new ones, I would select it to copy across the income figures for week 2 and it would automatically update.

Is this possible?

Secondly, we want to create a rota that would tell us how much we're spending on wages. Before anyone says that this would be easier with some sort of database, we don't have any such software at work.

To save time, I'd want to have a record of the staff member and their rate of pay.

On the rota sheet I would select their name, put in how many hours they will work and the sheet will then work out how much they are paid altogether, culminating in telling us how much we're spending as a whole.

We would then want to print a copy of the staff spend, and print off a sheet with just the rota on it (no pay rates for obvious privacy reasons) to pin up on the staff noticeboard so that they know when they're working the next week.

I'm pretty good with excel when it comes to formulas and stuff... but this sort of stuff and macros is way above my skill level, so any help would be much appreciated

From your question, I'm envisioning column A has the individual's name, and expenses, column B, C, ect would be the weekly totals.

Would it work for you if each individual/department filled out their sheet, then sent it to you. You could have a macro that inserted a new column, making column B blank, then inserted formulas to connect to the individual sheets. I would suggest that after it connected, you have the macro copy, and paste special - Values, so that your formulas don't get messed up in the furture.

You said macros is above you head but really, it's like making a tape recording of your actions.

Go to Tools, Macro, Record new Macro. Give it a name, and start doing your actions. The program automatically puts a little stop button on your screen. When you're with your actions, hit the stop button.

To test it, just go to Tools, Macro, select your macro from the drop-down list, and hit run. Usually, it takes me a few tries to get exactly what I want,but when it's done, it was worth the effort.