1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sheet reference to another sheet in same workbook

Discussion in 'Ask an Excel Question' started by shamsheer, Feb 12, 2018.

  1. shamsheer

    shamsheer New Member

    Messages:
    8
    Hello,
    I have been looking for an solution for below:
    When i update sheet1(source in this case) everything should get reflected in sheet4(target) of same workbook simultaneously. Sheet 4 is mainly used for printing purpose which shall be formatted as per user requirement.
    The source sheet contains chart,table etc.
  2. Marc L

    Marc L Excel Ninja

    Messages:
    3,820
    Hi !

    Do not copy / paste data to Sheet4 but just use formulas
    so when Sheet1 is updated, Sheet4 too …
  3. shamsheer

    shamsheer New Member

    Messages:
    8
    Formula reference shall not work in case of charts. There can be many changes that can happen over the period. Any option to automatically get the new sheet get updated.
  4. shamsheer

    shamsheer New Member

    Messages:
    8
    I received a VB from another web as below. Problem here is each time when i run it creates new excel workbook instead of updating in existing workbook in different/specified sheet.

    Sub CopySheetToNewAndFormat()

    'copy sheet 1
    ThisWorkbook.Sheets("Sheet1").Copy
    'set new workbookSet NewWorkbook = ActiveWorkbook

    With NewWorkbookWith.Sheets("Sheet1")

    'formatting example with rangeWith.Range(.Cells(1,2),.Cells(5,5))'borders.Borders(xlEdgeBottom).LineStyle = xlContinuous.Borders(xlEdgeBottom).Weight = xlThin'aligment.HorizontalAlignment = xlCenter.VerticalAlignment = xlCenter

    'colorWith.Interior.Pattern = xlSolid.PatternColorIndex = xlAutomatic.ThemeColor = xlThemeColorAccent1.TintAndShade =0.799981688894314.PatternTintAndShade =0EndWithEndWithEndWithEndWith

    EndSub
  5. shamsheer

    shamsheer New Member

    Messages:
    8
    Did anyone managed to go through my request please.
  6. shamsheer

    shamsheer New Member

    Messages:
    8
    Hi i have attached a sheet. Where whenever i update in booking sheet this should reflect in print sheet. Especially the filter condition & chart from source sheet to target sheet. Target sheet shall be formatted desperately for user to take print out.

    Attached Files:

  7. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,565
    Hi ,

    Nothing is clear.

    The tab labelled Print is a blank worksheet.

    What kind of formatting , print range has been done ?

    Do a complete job of building up your workbook , and then upload it.

    Narayan
  8. shamsheer

    shamsheer New Member

    Messages:
    8
    Thank you Narayank for the reply. I would require all data from Booking to be viewed / updated in print sheet. Especially when i do filter condition at same time this should get updated in print sheet also.
    cell reference shall work for numbers & characters. But for Filter condition & chart i'm not sure how to get in this sheet.
    But i will be doing the print format in print sheet at later stage as per users requirement.
    Sorry, I cannot upload the actual file since it is confidential.
  9. shamsheer

    shamsheer New Member

    Messages:
    8
    If my request is still unclear please let me know. I shall try to explain better.

Share This Page