Copying Non Adjacent Columns from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to copy the non adjacent column from excel to PPT. However, the
resulted paste includes the columns not selected. I have series of tables to
be copied from Excel and Pasted in PPT. Some column do not have values,
hence needs to be skipped. Data is like this
----------------WK-------------WK2------------WK3--------------WK4
Category 1------------------------------------------------------------------
Item A----------10---------------25---------------35-----------------45
Item B----------15---------------30---------------40-----------------30
Category 2------------------------------------------------------------------
Item A----------NA---------------NA---------------15----------------25
Item B----------NA---------------NA---------------17----------------35

I have the similar data running into more than 500 lines. Each Category
have around 10 rows. I have to copy the data to PPT which should start from
the WK where there is a integer available.
 
Have you tried hiding the columns in Excel first?
Then importing what you see into PP.

Sounds like a tedious task!

Just a though.
Kyle.
 
Personally, I would copy the cells of interest to a new "disposable" sheet
in Excel. Delete any rows or columns you do not want, then copy the results
into PowerPoint.

If these values are from constant locations on the excel sheet, you can
create a simple sheet of links to cells on this extra sheet and it will
update allowing you to simply copy and paste each month/week.

Take advantage of what Excel does best (spreadsheets) and don't force
PowerPoint to do another program's job.


--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..
 
Back
Top