Leaving certaincells blank

[Johnegee]

Hello, all,

Attached is StartOver02.xlsx. I'd like to convert the appearance of column D to the appearance of column E, the one with reversed colors in the column's title. More specifically, I want only the total number of sales per day to appear, with the previous cells for that day in that column being blank.

I'm pretty sure I'm missing something easy, but I've given up trying in the hope one of you experts can figure it out.

AARgh! How do I attach a file? Under "Posting Permission" is the sentence, "You may not post attachments."

 

[Fluff]

You cannot upload files to the site, however there are add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html that enable you to include sample data in the post

 

[DanteAmor]

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.