#1   Report Post  
Posted to microsoft.public.excel.misc
RalphB
 
Posts: n/a
Default VBA list uodating?

I have a list of suppliers. Each supplier's name on the list is hyperlinked
to their own page.

Any user can remove a supplier's name from the list as needed.

What I need to happen is for the list to be updated upon completion of the
deleting by removing the blank row left by the deletion.

And upon the completion of the deletion to have that supplier's own page
also deleted from the workbook.

The page with the list and the individual pages for each supplier on the
list are in the same workbook.

Is this possible and if so what code do I need to make it so and where would
I put the code?

Any help would be appreciated.
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
List box setup, placement, and functionality Ladybug726 New Users to Excel 3 November 21st 05 03:52 AM
Data Validation and Blanks in List GoneRural Excel Worksheet Functions 1 October 26th 05 05:03 PM
Loop through email address list to send e-mails Paul. Excel Discussion (Misc queries) 1 April 12th 05 12:41 PM
Refresh a Validation List? jhollin1138 Excel Discussion (Misc queries) 3 February 17th 05 05:48 PM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 08:32 PM


All times are GMT +1. The time now is 02:28 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"