Linking Worksheets

  • Thread starter Thread starter SHAWTY721
  • Start date Start date
S

SHAWTY721

I have an excel worksheet that the information is populated from an access
query that I created. The information exported from access goes to a template
sheet I created, now I am wondering is there any easy way to link excel
ranges from one worksheet to another, possibly programmatically. Also is
there a way to have a column in the worksheet be a combination of a couple
different columns from template worksheet that holds the data. The worksheet
I want to link to is in the same workbook. This worksheet will just be the
one where users can go to view the information.
 
The answer is yes, but specifically you stated that "The worksheet I want
to link to is in the same workbook", if this is the case then you can use a
formula e.g. in sheets1 cell A1 you add =Sheets2!A1 etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Automating complex workbook 3
Excel crashes and restarts when accessing newly created worksheet 2
Macro to Copy hidden worksheet to new worksheet 4
Combining Multilple Worksheets Into One 6
Linked Cells and Sort Issues 2
Duplicating worksheet based on range and changing worksheet name 3

Back
Top