linking data between sheets

S

SPL

I'm trying to link/copy specific rows of data to specific sheets from a main
worksheet. For example, row 16 of the main sheet would be copied to the first
unused row of the sheet specified by the contents of cell A16 of the main
sheet. Contents of row 17 of the main sheet would be copied to the first
unused row of the sheet specified by the contents of cell A17 of the main
sheet. Can you suggest a method to do this?
 
S

Shane Devenshire

Hi,

If you mean copy, then there is no function to do this automatically, you
will need to write a VBA program. If you mean link then you might create a
rather complex formula to do it. But you need to decide exactly what you
want and you need to tell us how the program should decide what sheet to copy
or link to. What is in A17 that clues us in?
 

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

linking cells to other sheets within a workbook 1
Summary Worksheet. 1
Data Population for multiple sheets 1
specific macro on specific sheets 5
Excel If a Cell Contains a Certain Text (From Another Table) 0
Summarize data from multiple sheets 2
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
formula help PLEASE PT 2 5

Top