Ask Experts Questions for FREE Help !
Ask
    prakashtoosmart's Avatar
    prakashtoosmart Posts: 1, Reputation: 1
    New Member
     
    #1

    Nov 14, 2012, 04:21 AM
    How to connect excel sheet
    Dear all,
    I import sum p&l acc details from tally to excel sheet 1. but I want to get results in 2,3,4th page in 3 headings. What is the formula/procedure to get the results. Thanks...
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Nov 15, 2012, 08:56 AM
    There's no simple answer to a vague question like that. Data can be transferred from one sheet to another in so many ways...

    It can be done with formulas like VLOOKUP or INDEX/MATCH if the data on sheet1 is used to update specific rows on the other sheets.

    It can be done with VBA if you simply want the data specifically copied to the other sheets enmasse based on some criteria you have yet to explain.

    Best attach a sample workbook showing all these sheets with good sample data if you want specific suggestions.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

Connect two different sheet in Excel 2007 [ 6 Answers ]

I am using Excel 2007. I want to put the calculation part or the detail figure in one sheet. And I want to put the relating pi chart or some other graphical representation on some other sheet. How I would relate these two sheets so that when I make any changes in the figure in the first sheet...

How can I connect one sheet 1 in excel to sheet 2 so it will update the information. [ 7 Answers ]

What I am trying to do is I have a schedule with drop down boxes I want to beable to click on a name in the dropdown box next to a time slot for appointments which are listed under the days date like a calendar, but once clicked I need it to update the list on the first sheet next to the same name...


View more questions Search