ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy Data (https://www.excelbanter.com/excel-discussion-misc-queries/205654-copy-data.html)

Chris

Copy Data
 
Hi,

Is there a way I can copy say: cell A6 to L48 into another spreadsheet via a
Button?

Regards,
Chris

Mike H

Copy Data
 
Hi,

Yes that's possible but will it always be that range?
Where on this other worksheet do you want it?
What is the name of the worksheet you want it on?

Mike

"Chris" wrote:

Hi,

Is there a way I can copy say: cell A6 to L48 into another spreadsheet via a
Button?

Regards,
Chris


Chris

Copy Data
 
Hi Mike,

Yes the workbook is always labeled the same.

File Is Called "Telephone Tracker"
1st Tab Is Called "Telephone Performance Tracker"

Id like the information to be sent to a excel file in C:\Stats
Called "Telephone Stats.exl"
Tab 1 will be called "Stats"


Regards,

Chris

"Mike H" wrote:

Hi,

Yes that's possible but will it always be that range?
Where on this other worksheet do you want it?
What is the name of the worksheet you want it on?

Mike

"Chris" wrote:

Hi,

Is there a way I can copy say: cell A6 to L48 into another spreadsheet via a
Button?

Regards,
Chris


Chris

Copy Data
 
Yes, id like the contents moved to CELL B1, B2, B3 etc..

"Chris" wrote:

Hi Mike,

Yes the workbook is always labeled the same.

File Is Called "Telephone Tracker"
1st Tab Is Called "Telephone Performance Tracker"

Id like the information to be sent to a excel file in C:\Stats
Called "Telephone Stats.exl"
Tab 1 will be called "Stats"


Regards,

Chris

"Mike H" wrote:

Hi,

Yes that's possible but will it always be that range?
Where on this other worksheet do you want it?
What is the name of the worksheet you want it on?

Mike

"Chris" wrote:

Hi,

Is there a way I can copy say: cell A6 to L48 into another spreadsheet via a
Button?

Regards,
Chris



All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com