Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
Sheet 1
In sheet 2 & 3 I want below fields to be updated from sheet 1 when I run the first code
Sheet2
Client Name = From sheet1
Code = From sheet1
Date = Current Date
Start = Current Time
Sheet3
Date = Current Date
Client = From sheet1
Start time = Start from sheet 2
With 2nd code I want below fields updated
Sheet1
Remark = If possible I want a popup userform to enter remark
Sheet2
End = Current Time
Total = End - Start
Comment = Remark from sheet1
Sheet3
End Time = End from Sheet2
Description = Remark from sheet1
Book11 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Client Name | Code | Company | tax Return | Remark | Status | Sent to | ||
2 | Abc | 123 | Xyz | 1099 | Working | Mr A | |||
3 | |||||||||
4 | |||||||||
5 | |||||||||
6 | |||||||||
7 | |||||||||
8 | |||||||||
Sheet1 |
In sheet 2 & 3 I want below fields to be updated from sheet 1 when I run the first code
Sheet2
Client Name = From sheet1
Code = From sheet1
Date = Current Date
Start = Current Time
Book11 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Client Name | Code | Date | Billing code | Start | End | Total | Comment | |||
2 | |||||||||||
3 | |||||||||||
4 | |||||||||||
Sheet2 |
Sheet3
Date = Current Date
Client = From sheet1
Start time = Start from sheet 2
Book11 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Date | Client | Start time | End Time | Type of work | Description | |||
2 | |||||||||
3 | |||||||||
4 | |||||||||
5 | |||||||||
Sheet3 |
With 2nd code I want below fields updated
Sheet1
Remark = If possible I want a popup userform to enter remark
Sheet2
End = Current Time
Total = End - Start
Comment = Remark from sheet1
Sheet3
End Time = End from Sheet2
Description = Remark from sheet1