Question about Microsoft Windows XP Home Edition

1 Answer

Create link from system generated report to another sheet

Hi everyone,

can you help me on this??

i have a system generated excel report of totals...
what i want is that, when i click a cell with total, it will show the breakdown on another sheet...so how can i create that links???
and how will i do that without sacrificing the run time,...
Thanks...

Posted by on

  • GuayM Nov 05, 2008

    to frcs68,

    What you were telling me is the manual creation of hyperlinks..i mean the report is there and i have to create the hyperlink myself per cell...it won't be convinient for me..

    what i need is..in the report generated, there is already the hyperlinks...it should be automatic..
    so how can it be done...??

    thanks anyway..appreaciate it..




×

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Genius:

    An expert who has answered 1,000 questions.

  • Master
  • 1,605 Answers

The easiest way to do that is use hyperlink.
right click on the cell you want and select the hyperlink and link it to other worksheet or document you want.
one caution: if you are going to copy the worksheet to other than where it is now, you have to copy all of the attached worksheet and document. otherwise, you will get a error message.

Posted on Nov 05, 2008

  • Frank
    Frank Nov 06, 2008

    please repost to request help from a porgrammer.

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to print a report on preprinted letter head


What's the problem? Put your pre-printed sheet into printer (you're to try some times until you get a proper positioning of printouts)

Mar 28, 2015 | Microsoft OFFICE 2013 PROFESSIONAL 1 PC...

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Operating Systems

1 Answer

How many ceels are in microsoft excel 2003


Till Excel 2003 the total cells of one work sheet are 16777216.

Regards

Feb 04, 2011 | Operating Systems

1 Answer

How to get all balance sheet entries tally to excel


This is a very handy process when you're totaling or subtotaling columns. On the cell that you want the 'total' in type '=sum(column letter row number),(column letter row number). The first 'column letter row number' is where you want the first cell to be started in the total factor and the second 'column letter row number) is the last cell you want added in the total factor. The help (?) section is good at explaining formulas. Hope this helps, keep this process handy if you use Excel much because it'll be helpfull each time you subtotal or total columns.
Bob

Sep 23, 2009 | Operating Systems

1 Answer

Want to write a code in VBA for a Chart prepared in Excel


Dear Customer,

you have not define your all details,

Plz give all details than & only than some can help you ,

so,Please mention all required details

THNX

May 08, 2008 | Operating Systems

1 Answer

Pls hepl me wit Excel VB integration


you can use a OLE object that is available in VB as standard object. Drag the tools to your form that your creating and it will ask for create or link existing object. so now browse to the excel sheet and embed it into the VB form or use run time for manuplating the cells and other info in excel.

Mar 25, 2008 | Operating Systems

2 Answers

How to hide sheet tabs in MS Excel


Do you mean by Visual Basic / Macro?

if so this is what you need:

ActiveWindow.DisplayWorkbookTabs = False

Mar 07, 2008 | Operating Systems

1 Answer

One problem in the application of excel sheet


I can make out that
You are speaking about creating a macro to take data from one constant updated cell and to put that data into another cell or form sheet.
You will need to get precise help from a programmer on this.
If you want to see a little on macros just open a sheet and checkout the help section on macros.
Some macros can take many hours to write and test.Some make take months.
hope this helps.

Jan 30, 2008 | Microsoft Windows XP Home Edition

1 Answer

How to create labels from excel data sheet


sir u just have to write all info row wise then ur issue will be resolved good luck

Oct 21, 2007 | Microsoft Windows XP Professional With...

Not finding what you are looking for?
Microsoft Windows XP Home Edition Logo

Related Topics:

93 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Alex Krenvalk

Level 2 Expert

401 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...