Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 11th 09, 05:52 PM posted to microsoft.public.excel.misc
SPL SPL is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 6
Default linking data between sheets

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?

  #2   Report Post  
Old February 11th 09, 06:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default linking data between sheets

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?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"SPL" wrote:

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
linking data to specific sheets SPL Excel Discussion (Misc queries) 0 February 11th 09 05:51 PM
Linking data in workbook to its sheets April Excel Worksheet Functions 0 August 17th 07 02:19 AM
linking data between sheets using drop down list JohnOC Excel Worksheet Functions 4 March 13th 06 04:25 PM
linking selected data between Excell sheets Alexandra Excel Discussion (Misc queries) 3 May 19th 05 12:05 PM
Linking sheets when sorting row and column data Sean 3DD Excel Worksheet Functions 0 January 5th 05 12:21 PM


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017