企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 947|回复: 4

Xcelerator copy and paste as values

[复制链接]

87

主题

373

帖子

564

积分

高级会员

Rank: 4

积分
564
QQ
发表于 2014-6-29 17:43:47 | 显示全部楼层 |阅读模式
I have a large xcelerator/excel report, 17 tabs in one workbook.

To disitribute the data from the xcelerator report, I currently have to copy and paste the data from the original spreadsheet into another spreadsheet as values.

So I run the report once, copy and paste all of the values and then save the spreadsheet.

Change one parameter, and then start all over again.

Can anyone point me in a direction re how I can automate this process, run the report and then click a buttom which will automate the movement of data from the original spreadsheet to a new spreadsheet. I also want to save the formatting from the original spreadsheet.

I want to make sure I start in a direction that has worked for others in the past.

thanks
回复

使用道具 举报

81

主题

429

帖子

608

积分

高级会员

Rank: 4

积分
608
QQ
发表于 2014-6-29 20:04:58 | 显示全部楼层

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

85

主题

433

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-6-29 20:19:31 | 显示全部楼层
You haven't been very clear as to what exactly the "parameter" is that is being changed but if it is a dimension element and you can cycle through a subset then the built-in "print report" function in the TM1 and Xcelerator add-ins is probably all you need. Are you aware of this feature?
回复 支持 反对

使用道具 举报

80

主题

407

帖子

591

积分

高级会员

Rank: 4

积分
591
QQ
发表于 2014-6-29 20:21:42 | 显示全部楼层
The parameters are office locations, the 17 tab xcelerator report needs to be run once for each of 15 locations.

I will look at the print report function, but it sounds like it will print rather than create an electronic xls version of the report.
回复 支持 反对

使用道具 举报

67

主题

355

帖子

520

积分

高级会员

Rank: 4

积分
520
QQ
发表于 2014-6-29 20:22:30 | 显示全部楼层
Don McC wrote:The parameters are office locations, the 17 tab xcelerator report needs to be run once for each of 15 locations.

I will look at the print report function, but it sounds like it will print rather than create an electronic xls version of the report.
Well that's where you would be wrong.  

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2019-1-17 19:50 , Processed in 0.166997 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表