Welcome Guest.   Make a donation to an author on the site October 22, 2014, 06:15:52 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2012! Download dozens of custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1]   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: Copy (and Auto-Paste) Directly to New Excel Worksheet  (Read 2934 times)
nkormanik
Participant
*
Posts: 285

View Profile Give some DonationCredits to this forum member
« on: August 03, 2011, 03:04:20 AM »

Skwire provided ClipTrap which I use often.  Terrific program.  Captures copy and pastes automatically to file.

Now I have another semi-related request:

I'm copying from a complex time-line chart (on the surface, a graphics image).  Each line on the chart actually, when copied, is the data BEHIND the line on the chart -- a column of data (date, value).

I need to get the data from each line on the chart into a separate Excel worksheet -- one worksheet per chart line.  There are around 50 lines on the chart.  So..., 50 separate worksheets would be the result I need.

Ideally, as with ClipTrap, each time I copy, the data would automatically go into a (separate worksheet) file.

Naming the files will be an issue as well -- names will simply be xxx numbers, 001, 002, etc.

If we can't arrive at the ideal solution, can any here think of the fastest, easiest way of pasting data into 50 separate worksheets?

I'll be happy to clarify if the above isn't clear enough.

Thanks for your help.

Nicholas
Logged
wr975
Charter Member
***
Posts: 369



View Profile Give some DonationCredits to this forum member
« Reply #1 on: August 03, 2011, 05:00:15 AM »

Perhaps ASAP Utilities for Excel (freeware) might help?

http://www.asap-utilities...ilities=20&lang=en_us

« Last Edit: August 03, 2011, 05:36:04 AM by wr975 » Logged
nkormanik
Participant
*
Posts: 285

View Profile Give some DonationCredits to this forum member
« Reply #2 on: August 03, 2011, 04:41:55 PM »

Appears to be a good lead.  I'll try it out.  Thank you!
Logged
Pages: [1]   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.025s | Server load: 0.25 ]