Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Bringing quotations back up on screen

I am creating a quotation system and need to have the ability to bring up
saved quotations which I have filed away, back up onto the quote. Once I
finish producing a quote, I will file it away in another worksheet using a
macro. I then need a way to find the quote (maybe using autonumbers?) and
bring it back up in the original quotation display.

Please Advise

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default Bringing quotations back up on screen

There could be many ways to do this:
If the range is the same size then use FIND to find the number and RESIZE
or
if not too many entries use a database and find the number and re-populate
the master with the entries.
or?

--
Don Guillett
SalesAid Software

"flymeoutofhere" wrote in message
...
I am creating a quotation system and need to have the ability to bring up
saved quotations which I have filed away, back up onto the quote. Once I
finish producing a quote, I will file it away in another worksheet using a
macro. I then need a way to find the quote (maybe using autonumbers?) and
bring it back up in the original quotation display.

Please Advise

Thanks



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
Spreadsheet off screen bamph Excel Discussion (Misc queries) 1 August 2nd 06 08:10 AM
Worksheen name referencing to create a 'back' button hyperlink Paul Adams Excel Discussion (Misc queries) 1 August 1st 06 08:18 AM
Excel 2003 back to Excel 2002 Pete Carr Excel Discussion (Misc queries) 3 December 27th 04 08:11 AM
Outlook 2003 demo back to Outlook XP Pete Carr Excel Discussion (Misc queries) 1 December 22nd 04 08:04 AM
Roll back to previous date Jay Excel Worksheet Functions 2 December 3rd 04 03:35 PM


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