LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default need to append range name size with new entry automatically

I am transferring and old lotus program to excell. I
wrote macros in lotus that gave a range a name, then I
wrote an insert command which appended my sales data base
to include the new information. In excell I now how to
name my salesdata base, and to take my new information and
add it to the cells below my current data base, but my
problem is to automatically update the salesdata base to
include the new record. I can do it manually, but I need
to have the macro include a function to append or add the
new record. Thanks for any help. Don
 
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
Referencing a named range based upon Range name entry in cell Barb Reinhardt Excel Worksheet Functions 14 June 20th 07 07:19 PM
Graphing a dynamic range that automatically picks up the most recent entry. gimiv Excel Worksheet Functions 2 July 10th 06 07:58 PM
day of the week entry automatically DennyD Excel Worksheet Functions 3 September 22nd 05 09:56 PM
Date entry automatically abfabrob Excel Discussion (Misc queries) 3 April 12th 05 01:55 PM
Append new row of data to range Art[_5_] Excel Programming 4 October 26th 03 01:14 PM


All times are GMT +1. The time now is 11:19 AM.

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

About Us

"It's about Microsoft Excel"