Using formula to copy cells

J

J

I am trying to copy cells from one sheet to another and I would like to bring
the color of the cell over as well. It also always brings over a 0 if I
don't have any data in the cell. How can I just bring over the color of the
cell without the 0?

For example, on sheet 1, I would like to copy cell A1 from sheet 2. All
that is in cell A1 on sheet two is the cell is highlighted red. When I do
=Sheet2!A1, all it does is bring over a 0.

Thanks in advance for your help.
 
F

FSt1

hi
on the menu bar, click edit>paste special....
in the pastespecial dialog box. click formats then click ok.
this will just paste the formats of the copied cell without the data.

Regards
FSt1
 

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

VBA Coding Help for Beginner 0
Copy addition formula of non-consecutive horizontal cells 2
Transfer data between two tables 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Newbie Help - IF Yes No Function 0
Cumulative formula for word table 0
Change the colour of a neighbouring cell 6
Match Copy/Paste Macro almost there 0

Top