Passing data to PowerPoint from Excel

Tarver

Board Regular
Joined
Nov 15, 2012
Messages
113
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I have to do a lot of copying and pasting from Excel into PowerPoint. It's sort of like grown-up arts and crafts time at work.

I'm trying to write macros to do much of that work for me, but without a Record Macro function in PowerPoint, it's a challenge for me, as I'm not a programmer.

In Excel, I use a formula to determine my current fiscal week, which is ="Fiscal Week "&weeknum(today())-5. In PowerPoint, I have a text object that has the right formatting and the right size and position, named "FWQ" that the result of my Excel formula should replace.

Is there a way to take the formula result (in Cell C1 in Excel, for instance) and edit a text object in PowerPoint to match?

Thanks for any suggestions or help you can offer!
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Forum statistics

Threads
1,226,730
Messages
6,192,705
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top