richblake74
Active Member
- Joined
- Dec 30, 2006
- Messages
- 284
- Office Version
- 365
- Platform
- MacOS
Hi all.
A col has Dates in them this sheet is called "Log"
Col A Col B Col C
Wed, 19 Jun 19 5:30 6:40
Fri, 21 Jun 19 1:49 1:23
Fri, 21 Jun 19 1:11
Fri, 21 Jun 19 1:33 3:12
I have another sheet that has dates for JUNE sheet name "Monthly".
On the row that has Date on the Monthly sheet I would like it to insert and merge the same date on different rows totaling them.
A20 on Monthly Sheet has the date of "Wed, 19 Jun 19" I want it to grab the col b from the Log sheet and insert inCol B onto col B on the Log sheet on same row that Wed 19 june is on.
Then A22 on Monthly sheet has the date of 21 June I want that row and col be to total all in COL b on log sheet and insert '4:33" in B22 on.
I wish I could do a screen shot an show it more clearly but I know someone might understand my weak explanation.
Cheers
A col has Dates in them this sheet is called "Log"
Col A Col B Col C
Wed, 19 Jun 19 5:30 6:40
Fri, 21 Jun 19 1:49 1:23
Fri, 21 Jun 19 1:11
Fri, 21 Jun 19 1:33 3:12
I have another sheet that has dates for JUNE sheet name "Monthly".
On the row that has Date on the Monthly sheet I would like it to insert and merge the same date on different rows totaling them.
A20 on Monthly Sheet has the date of "Wed, 19 Jun 19" I want it to grab the col b from the Log sheet and insert inCol B onto col B on the Log sheet on same row that Wed 19 june is on.
Then A22 on Monthly sheet has the date of 21 June I want that row and col be to total all in COL b on log sheet and insert '4:33" in B22 on.
I wish I could do a screen shot an show it more clearly but I know someone might understand my weak explanation.
Cheers