copying formulas when using a macro

B

BBEXCELNOVICE

I am setting up a macro to run a number of tasks and one of which is to copy
data into a new worksheet based on a given criteria, then creating a formula
in another column in the new worksheet based on the list copied. The problem
I have is that the no of records listed can vary and so I only want the
formula to copy down to the number of records that are there. How can I do
this? Hope this makes sense - can anyone help?
 
S

Steve Schapel

BBEXCELNOVICE,

The focus of this newsgroup is macros in Access, the database
development programme. You will have a better chance of getting good
help if you post your question to an Excel newsgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Drop down list control value in vba 2
Need Help with a VBA subroutine 0
Use TODAY() function as the criteria in a SUMIF formula 1
List all tables, including document structure 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Help with an Excel formula please? 7
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top