Paste using All using Source Theme using Formula

Question

Hi

I would like to check if there is a way we can "Paste using All using Source Theme" with only Formulas and not VBA.

Have certain data that i want to copy on another sheet but it do not give me the info with the Orignal format.

Please assit

Answer 1

try this, copy formula the information first, then go to sheet 1 highlight the whole sheet, press in the ribbon the format painter, go to sheet2 click to select the whole sheet

Answer 2

Its not only one cell in actual sheet that i want to copy, its a huge list.

Also the sheet requirement is to have a formula do it for me, rather than me do copy right click Paste special.

Answer 3

Hi, when you go to sheet2, click on the arrow under paste, select paste special, formats

Answer 4

Let me try again., 

I want to copy data from Sheet 1 Cell "A1" which contain data in missed formats (some information in bold, some in Italics and some with other colors) and paste it over to Sheet 2 Cell "A1".

I am using formula "=Sheet1!A1"

Above do copy the infomation in Sheet 2, however will not copy with the exact formatting used in Sheet1.

I will like to check if its possible to get data in Sheet 2 with the format we have in Sheet 1 Cell A1

Hope its clear now :)

Answer 5

Perhaps I am not able to understand your question, as I believe, when you copy and Paste Special and there If you paste using "All using Source Theme", it will copy formulas with source theme formatting and that is what you want.