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

    Jul 1, 2012, 09:38 PM
    How to link multiple excel sheets to one main source excel sheet
    I have a master price list and multiple ( individule ) sheets for customers..
    I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs)
    Thanks
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Jul 2, 2012, 10:52 PM
    You can use VLOOKUP formulas to lookup the prices in the PRICE sheet based on the item codes from your PRICE sheet that you manually enter your customer sheets.
    vks64's Avatar
    vks64 Posts: 59, Reputation: 1
    Junior Member
     
    #3

    Nov 21, 2012, 08:07 PM
    Please post a sample sheet for reference and another sheet showing your desired result
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #4

    Nov 23, 2012, 11:47 AM
    Any particular reason you're trying to revive an old question with a posted solution already?
    varadhu's Avatar
    varadhu Posts: 14, Reputation: 1
    New Member
     
    #5

    Dec 7, 2012, 12:10 PM
    Quote Originally Posted by JBeaucaire View Post
    Any particular reason you're trying to revive an old question with a posted solution already?
    Sir,

    Sorry for the interference,

    I want to know, how to use the solution posted by sir.JBeaucaire.
    I don't even understand the question in full. Please forgive me for all this

    I believe a illustration would help me better. I have not used these VLOOkup formulas etc. so far. Please forgive me for my ignorance. Actually I too wanted to learn to use the Vlook up formulas with samples. I have a need very much similar to the question raised by sarsar2121 please.

    A sample VLOOKUP formula (solution) is what I too expect for the original question. Of course with a sample excel sheet(on the question) please.

    I have also posted a similar question separately in the forum please.

    Hope I have NOT created any nuisance or problem in the forum.

    Sorry for the interference, once again,

    varadhu
    vks64's Avatar
    vks64 Posts: 59, Reputation: 1
    Junior Member
     
    #6

    Dec 8, 2012, 02:14 AM
    Quote Originally Posted by JBeaucaire View Post
    Any particular reason you're trying to revive an old question with a posted solution already?
    Sir,

    I am interested in the question posted by sarsar 2121.
    For the purpose, I badly need to understand the reply posted by yourself sir.

    Hence I requested sarsar2121 to put up a sample sheet for his question so that I can attempt to apply you're the solution for my benefit.

    In such case, I will also request you sir, to give me the solution specific for the sample sheet which I believed would be easier for me to digest/understand and further adoption according to my requirement.

    Please do not mistake me sir.

    I am a layman in the field of software.

    A little bit of sample and explanation would help!

    Thanking you
    vks64
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #7

    Dec 12, 2012, 09:18 AM
    Excel has excellent tutorials built in that do an excellent job of demonstrating functions.

    Press F1 in Excel and lookup the help file on VLOOKUP.

    You should be able use that to understand the function quite readily.
    fcf's Avatar
    fcf Posts: 6, Reputation: 1
    New Member
     
    #8

    Jan 24, 2013, 10:45 AM
    hi are all the sheets you want the values to go to in the same 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!

Excel Sequential Invoice Number in multiple sheets [ 2 Answers ]

Hi This is my first time at this site! :) I am a virgin! :p I have a master copy of my invoice with the invoice number contained in cell K3. I would like to know 2 things which would help me out greatly. 1. I would like to copy that master sheet invoice say 20 times and have the...

How to link excel sheet? [ 2 Answers ]

How to link the excel cells with next colums so that when we miss any colums to fill then we don't hv write to fill next colums

Excel 2003 Macro VBA Hide / Unhide Multiple Sheets [ 5 Answers ]

I'd like to assign a macro button to hide / unhide a range of sheets in a workbook. I have tried various codes from web but have not been successful. (acutally one of the codes worked if I selected 'run' from the macro menu but does not run if button is clicked). I have tried 'recording'...

Link of excel sheets [ 1 Answers ]

Link excel speadsheet


View more questions Search