link sheets

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...

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...

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!

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...

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?

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...