copying data from other worksheet including entire format

B

Bud

Hello

I am using the following formula in hopes of copying the data over including
the format into another worksheet called Early.

In the worksheet called Early I have placed the following formula in A5.
=Schedule!A5

A5 in the Schedule worksheet has this fields format as Custom mm/dd/yyy.

The data in the Early worksheet is a number and the format is just GENERAL.

How does one use a formula to bring over the formatting as well?

I have this in other cells as well in the worksheet Early where I am
expecting the formatting and the color to be copied over but it isn't doing
that.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How does one use a formula to bring over the formatting as well 1
How do I copy cell attributes between worksheets 1
Date formatting from user form to worksheet 6
Automation of copy/pasting data and retrieving results 0
Copy all formats and objects 5
copy data from one worksheet and disregard blank cells 6
Graphing data from multiple worksheets in same workbook 1
Copying Data from One Worksheet to Another 2

Top