• 100% Satisfaction Guarantee
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1948
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# PC guy - this isCustomer- when I change the date it says date

PC guy - this isCustomer- when I change the date it says date not found

The-PC-Guy :

The-PC-Guy :

hi

The-PC-Guy :

yes it would say that if the date is not on sheet 2

The-PC-Guy :

or not in the correct format

The-PC-Guy :

does that make any sense?

Customer:

i changed 8/4/2013 to 8/5/2013 and it said it could not find the date

Customer:

?

The-PC-Guy :

which date did you change

The-PC-Guy :

on sheet 1 or sheet 2

Customer:

sheet 2

The-PC-Guy :

ok

The-PC-Guy :

i think that is where the confusion is

The-PC-Guy :

sorrry if i did not explain it well

Customer:

no its my fault..

The-PC-Guy :

you enter dates on sheet 2

The-PC-Guy :

going across row 1

The-PC-Guy :

then on sheet 1

The-PC-Guy :

in cell

The-PC-Guy :

I2

The-PC-Guy :

you change that date

The-PC-Guy :

then click the button

The-PC-Guy :

if you enter a date that is not on sheet 2

The-PC-Guy :

you will get that error message

The-PC-Guy :

hopefully that will make sense now

Customer:

so if in cell B3 to do a cumulative sum

Customer:

i put = C2 + B3 correct?

The-PC-Guy :

no

The-PC-Guy :

B3

The-PC-Guy :

doesnt have a cumulative

The-PC-Guy :

becasue its the first one

The-PC-Guy :

nothing before it

Customer:

ok

The-PC-Guy :

but that is the general idea

The-PC-Guy :

it would be curent days score

The-PC-Guy :

plus

The-PC-Guy :

previous days total

The-PC-Guy :

then it would keep adding accross the row

The-PC-Guy :

as you copy the formula

Customer:

when i put that in it just says the plaintext of what i put

The-PC-Guy :

you did put the

The-PC-Guy :

=

The-PC-Guy :

sign

Customer:

in sheet 2 right?

The-PC-Guy :

yip

The-PC-Guy :

you would do all this in sheet 2

The-PC-Guy :

so for cell B3

The-PC-Guy :

formula is

The-PC-Guy :

=B2

The-PC-Guy :

for cell C3

The-PC-Guy :

= C2 + B3

The-PC-Guy :

then just copy and paste

The-PC-Guy :

C3 to however many cells need it

Customer:

I've turned the cell that had it correct into a red background

Customer:

not on purpose

The-PC-Guy :

ok, i don't know what you are doing now. But are we all set with the macros now?

Customer:

yes we are

The-PC-Guy :

ok greate

The-PC-Guy :

come back if you need me again

Customer:

how do i pay for this now because when i hit submit I think it should have taken me to a tip menu or something

The-PC-Guy :

as far as i know

The-PC-Guy :

you should see smileys at the bottom of your chat screen

The-PC-Guy :

you would click the excelent service just like before

Customer:

ok

The-PC-Guy :

that pays me

Customer:

roger that

The-PC-Guy :

thanks