newbie autofill help

dieselx

New Member
Joined
Feb 28, 2003
Messages
13
Any help is appreciated, this is hopefully a simple question.

I have x number of rows that are constantly being added to and deleted on a weekely bases.

When a new row is entered I need the formula for that column to automatically fill in with the appropriate forumula, font, and color without having to drag down the cell.

thanks,

Phil
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
This will probably require the use of VBA code. You can probably use the macro recorder to get the formatting part.

How is the data entered/deleted? Is there cutting & pasting involved?
 
Upvote 0
Rows that need to be deleted I have just been using the delete row function.

New rows are entered manually.

Thanks,

Phil
 
Upvote 0
I would recommend creating an Event Procedure macro (using the Worksheet_Change event). Basically, you would check a column to see if it has an entry. If it does, then you would create/copy formulas in another column.

For information on this, see http://www.cpearson.com/excel/events.htm

If you need help writing it, you will need to post the more explicit details (i.e. methodology, columns invloved, etc.) and maybe even an example.
 
Upvote 0
Thanks for you help I will take a look into it.

The spread sheet is used to enter a clients name, DOB, date of appointment to keep track of patients.

These are the formulas I will be using.

Formulas:
1. Number Clients 1-n
2. Clients current age
3. Clients age at appt
4. A Date 6 mos after clients last appoint.

Columns
- number Clients (formula 1)
- Name
- DOB
- Clients age (formula 2)
- Age at appt (formula 3)
- Last appt
- 6 months after last vist (formula 4)
 
Upvote 0

Forum statistics

Threads
1,226,452
Messages
6,191,133
Members
453,642
Latest member
jefals

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top