link sheets

  1. J

    Copy 5 rows from one sheet and paste in another sheets based and save as PDF based on condition

    I have data in Sheet1 in Column A & B, I want 5 Rows from Sheet 1 to copy into Sheet 2. For example I want the data from Sheet 1 A1:A5 to copy into Sheet 2 A8 to A12 and B1:B6 to copy into C8 to C12 of Sheet 2 and save the page as PDF in desktop then continue the process till last row of...
  2. E

    Linking two sheets without source sheet (bi-directional linking of sheets)

    Hi all, I am new here, but couldn't find the answer in previous posts. Feel free to send a link to an old post solving this issue if you know of one! Now to my problem. I want to link two worksheets in the same document, whereby if changes occur in A, the changes should also be entered in B...
  3. B

    Link 3 Worksheets that have common field

    I have copied 3 foxpro dbf files to Excel (2007). The field that all 3 have in common is named "Stock ID". I need to create a report pulling 1 or 2 fields from each file (or worksheet). Is there a way to do this in Excel, possibly using Pivot Tables or is there some other way? Thank you!
  4. P

    Edit Links in Protected Sheets / Link to a file "in the same folder" (without specifying the path)

    I have a protected spreadsheet that links to another spreadsheet that is in the same folder (C:\example\master.xlsx and C:\example\subordinate.xls) I want to be able to use them both in any computer (that means, in any folder). For instance, I would like to be able to paste those two files in...
  5. O

    Need help copying results from an autofilter to a new worksheet

    I'm working on a quote template that has 600+ products with descriptions and prices that gets autofiltered down to one product. After it has been filtered down to that one product how do I link that to a new worksheet?
  6. H

    Locking rows in excel between sheets

    I have a very lengthy and, what I think is, a very complicated Excel question: I'm working in Excel 2003, I'm looking at inventory depreciation forecasts between two different sheets. The two sheets are entitled '2002-Present' and 'Present-Forecast'. The reason I'm using two sheets is because...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top