Excel Monthly and Daily sheets [Closed]

Question

Excel Monthly and Daily sheets [Closed]

Report

Waseem - Jun 19, 2017 at 03:13 PM
TrowaD

Posts: 2702
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: March 2, 2021

- Jun 20, 2017 at 11:51 AM

Hello,

Hi, I have an excel worksheet we use for daily retail business paperwork. It has 3 sheets with Daily Toatals, monthly Totals and Yearly Totals. I have to input data in Daily first, then copy and paste it into Monthly and yearly updates by simple formulas. I don't have extensive knowledge of excel, let alone Visual Basic. I would like for the Monthly sheet to update itself as it recognize the date on the daily sheet. Searched it a lot online but couldn't find anything other than some VB examples which went straight above my head. Can you help me. I appreciate that

Excel Monthly and Daily sheets
How to automatically update one excel worksheet from another sheet ✓ - Forum - Excel
Excel vba select last sheet - How-To - Excel
Excel transfer data between sheets - How-To - Excel
Excel vba create new sheet with name from cell - How-To - Excel
Automatically transfer data from one sheet to another ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2017-06-20T11:51:24-0400

Answer 1 / 1

TrowaD

Posts: 2702
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: March 2, 2021

457
Jun 20, 2017 at 11:51 AM

Hi Waseem,

Your question is very general. Care to share some specifics? How does it look now, how do you want it to look and what is the logic to get there?

You can type some sample data upload screenshots or more preferably upload your file using a free filesharing site like www.speedyshare.com.

Best regards,
Trowa

Excel Monthly and Daily sheets [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!