Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macro to add formulas to added worksheet

Hi

I have had some excellent help in gettin a new worksheet
to be added pulling data from an Active Worksheet and
formatting it into individual statements using a macro.

The new worksheet added has 290 names and addresses, with
each name and address having a space of 25 lines between
the next name and address.

What I need to be able to do now is to haver certain Cells
to have a formula added into the added worksheet.

For example, each cell in column "L" and in row 15 of each
statement might have the formula F23/3.054. There are
quite a few cells in each statement that need this so I
would like to automate it as the worksheet is added.

Is this possible.

Many thanks

Malcolm
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically appending newly added data on worksheet to a master list worksheet tabylee via OfficeKB.com Links and Linking in Excel 0 December 17th 09 04:24 PM
Automatically copy formulas to new rows added. LCN Excel Discussion (Misc queries) 3 December 2nd 08 06:30 PM
Macro changes formulas on destination worksheet Karen Excel Discussion (Misc queries) 2 August 12th 08 11:07 PM
Sum formulas do NOT expand when rows added ! Blue Max Excel Worksheet Functions 5 April 29th 08 05:13 PM
how do I lock formulas, but still allow rows to be added or delet. ericaamousseau Excel Worksheet Functions 3 January 18th 08 07:10 PM


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"