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: 121
Default creating pages with 1 click..

hi all!!
i try to explain my problem easily.. im italian so i will use a maccaronic
english !!
i have page 1 and page 2 saved in the folder..

page1 is simply an empty grid .. with numbers from -20 to +20 for rows and
standard numbered columns,
page2 is a sample page..with code and formulas...

i need this .. when i select a cell in page 1, for example cell "L200" ,
and i press "CTRL+K" i need to run a macro that creates a new page that saves
page2,
with written this in cell A18:

]Sheet1'!$D$200

and thus it is a "L" ,have to write -7 in cell A19 of page2 (if it was U it
would have been a 0 , V 1, W 2 , X 3....AO 20)

and also personalized name of the file...like this..
F.MI.-7.200.xlsm

let me know if u have any suggestion..ty !!
 
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
automatically creating new xls pages N+ Excel Programming 1 June 11th 08 09:12 AM
Creating shortcuts for a database between two pages Brigitte[_2_] Excel Discussion (Misc queries) 1 August 27th 07 11:22 AM
Creating Same Links On All Pages Launchnet Excel Worksheet Functions 0 June 15th 07 04:22 PM
creating 1 linked page from 26 pages Klaus A. Excel Discussion (Misc queries) 0 May 11th 05 05:52 PM
creating pages from an alphabetical list Andrew Excel Worksheet Functions 1 November 19th 04 02:45 AM


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