Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear all;
Is there a worksheet change event that will copy all row formulae to the next five rows when the bottom row is filled with data? I have a time/ expense billing database on which each row contains a variety of Vlookups, validated fields, and other formulae. it is approximately 12 rows wide and an increasing number of rows, expanding downwards. I am trying to reduce the filesize, because I have currently copied the formulae etc. down 10,000 rows and the filesize is currently 4mb. Kind regards Dylan Dawson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing chart plot formulae automatically | Excel Programming | |||
How do I convert formulae to values automatically | Excel Discussion (Misc queries) | |||
repost; Automatically updating formulae in multiple sheets | Excel Discussion (Misc queries) | |||
How to represent an empty cell in excel formulae? | Excel Programming | |||
How to represent an empty cell in excel formulae? | Excel Worksheet Functions |