Lists and Macros

**andysila** · 11-05-2010, 04:07 AM

Hey everyone, I'm new here... I'm finishing up a project for the start of my new business and I need some of your help.

I have a spreadsheet that contains 22 rows for employees and 15 columns. Each day an employee makes a certain amount of money and that's the data i need to enter in the row on the necessary day (column). Is it possible to make a list that correlates with the list of names I have for the employees (included if I add a new one too) in where as if i decide to fire somebody I can click a button so it can turn the row a light red color and state the date the employee left (the same day i click the button).

My only problem here is when I record a macro, It only does it for one individual row and I have another 21 rows. Plus I might even add more employees!!

Help!! How do i carry over a simple macro from one button to the next and the next (but the next button correlates it's row)

help!

**davesexcel** · 11-05-2010, 07:57 AM

Hello and welcome to the forum,
Lets see the code.
Copy your code,
Click new post
Click the # icon and paste your code

Or better yet, attach a sample of the workbook.

**andysila** · 11-06-2010, 05:16 AM

There is the attachment, don't mind the names, I just needed to fill the blanks. (this is the second spreadsheet I have made so bear with me!)

The Monthly Sheet

My first concern is being about to use the list above period 1 in selecting a current employee if they get terminated or leave the company. I've tried recording macro's but it hasn't been working the way i want it to.

The same thing for period 2 (period 2 is the 15th day to the 31st day of that month).

And then, once the employee is termed, I want the row to turn red and the date they left in the "Left" column.

The Yearly Sheet

I've also been trying to figure out how to store the data in the "Net Pay" column (the Monthly Sheet) into the according column on the Yearly sheet. Even if an employee gets termed, I would like to be able to keep the record of that on the Yearly sheet.. I know this sounds quite difficult but I've really had it..

After many many hours and restless nighs, I just couldn't figure it out so I decided to ask for help and it looks like I'm in the right place. Full of intelligent people, Thank you to everyone and anyone who takes the time to help me, I truly appreciate it

**andysila** · 11-09-2010, 12:55 AM

Any luck with it ?

Lists and Macros

LinkBack

Thread Tools

Rate This Thread

Display

Lists and Macros

Re: Lists and Macros

Re: Lists and Macros

Re: Lists and Macros

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions