Forum Discussion
Skipping cells when copy and paste
I have an excel work book at my working place. On sheet 3 I have date, customer, qty, price and total amount (see pic 1) and in the sheet 4 I have summary for each day (see pic 2). I fill in the details as in Pic 1 for each day. Next I have to copy the summary on 01-01-2022 which is in page 1 to page 2 of sheet 4 (See Pic 2) to create summary for 02-02-2022. What happens when I paste is, the excel correctly picks the total amount of 55000 for 02-01-2022 from sheet 3. The only formula I can see in the cell B2 in sheet 4 is '=Sheet3!D8' and when I copy that it becomes=Sheet3!D16. How this happens? I cannot see any macros in the 'view code'.
Pic 1
Pic 2
1 Reply
With your permission, I may i recommend, add a file (without sensitive data) and use this file to describe your issue/problem/project step by step.
Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem:).
Don't forget that not every Excel user has a clue about every job and what you see he can't see.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
Thank you for your understanding and patience
I know I don't know anything (Socrates)
