Posts by sarisri7

sarisri7 · Mar 15th 2018

Dear all,

In continue to the above post, let me put my request little more clear.

I need the VBA code, if I click the button i would like to select the rows containing the values 'APCW2' (not exactly but only containing/starting with APCW2) in the column 'Emp Code' and cut and paste in the new sheet of the same workbook. This is what I look at exactly.

Pls help me out.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 463"]

[tr]

[td][/td]

[/tr]

[tr]

[td]

Unit

[/td]

[td]

Emp Code

[/td]

[td][/td]

[TD="align: left"][Blocked Image: https://www.ozgrid.com/forum/core/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIYAAAAfCAMAAAAVzkUoAAAAAXNSR0ICQMB9xQAAAGNQTFRFAAAAAAAAAAA2AABgADaHAGCrNgAANgA2NgBgNjZgNofOYAAAYAA2YDYAaWlpYIeHYKvwhzYAh87wq4c2oKCgq86Hq/DOq/Dwzoc2zvDw8Ktg8M6H8PCr8PDO4+Pj8PDw////jVdazQAAAAF0Uk5TAEDm2GYAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAAZdEVYdFNvZnR3YXJlAE1pY3Jvc29mdCBPZmZpY2V/7TVxAAABBElEQVRYw+2U2w6CMAyGGUcVRZgoMEB4/6e03QEGV5qAW8gawroN0m/tv3qjBZZ53vg2biXHGEybw3AYDuOQGG1MSATDqYJHrvVFPm3zxXlrJwwWVBA1Wgb6O0aXYsA2oWYxMBkqHMbCEuUcg5HLAqNLCXzbnm+BdDfFCBsdA5MDA2Awn07SAQteQFaHTRsLyFr9twuGnPbFPaHLojxh7K4UyseXwN2xKLXCCB/RCgOz4lNVOOJviiEkCu9VNnJ1XD0bcvqDXr++sDUcCw7faNpIKJeoIFIYqA0p416427YvRvT2Nd8UbCarm+ILXQzCPWQzdxgOw2HYgVGaN8DIbDDPEvsAJIm/EnL3TJQAAAAASUVORK5CYII=] [TABLE="cellpadding: 0, cellspacing: 0"]

[tr]

[td][/td]

[/tr]

[/TABLE]
[/TD]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014484

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014485

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014486

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014487

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014488

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002306

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002312

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002313

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002314

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002316

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002319

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002323

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002325

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002392

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003215

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003216

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003218

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003220

[/td]

[td][/td]

[/tr]

[/TABLE]

sarisri7 · Mar 15th 2018

Dear all,

Attached and show below the xls sheet.

I need help from the forum, once I click the button shown below, a pivot table shown again at the bottom to be generated in a new sheet of the same workbook. I tried to do this by Macro recording, but many errors found while running and finally dropped the idea.

Table [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 591"]

[tr]

[td]

Unit

[/td]

[td]

Emp Code

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014484

[/td]

[td][/td]

[TD="colspan: 3"]
[TABLE="cellpadding: 0, cellspacing: 0"]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[td]

[IMG2=JSON]{"data-align":"none","data-size":"full","src":"https:\/\/www.ozgrid.com\/forum\/core\/image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIkAAAAcCAMAAABiUWwLAAAAAXNSR0ICQMB9xQAAAHtQTFRFAAAAAAA2AABgADaHAGCrNgAANgA2NgBgNjZgNjaHNoerNofOYAAAYAA2YABgYDYAZGRkYGBgYIeHYKvwhzYAhzY2h6uHh87wq2AAq2A2q4c2oKCgq86Hq\/DOq\/Dwzoc2zvCrzvDOzvDw8Ktg8M6H8PCr8PDO8PDw\/\/\/\/EjR04QAAAAlwSFlzAAAOxAAADsQBlSsOGwAAABl0RVh0U29mdHdhcmUATWljcm9zb2Z0IE9mZmljZX\/tNXEAAAGOSURBVFjD7ZXbUoMwEIaXAkWkKhoUtAqVU\/r+T+huDjSB4PSCCy6S6RS6p3zz7yaF605WDle+i3X2JJ7Ek2xC0scAET6SGj\/KNhZs8lcQtnyeABCU\/Ba\/dJPfLOWKnZF0hxqjIzvUIBmeyvlWIrIL3Pb5tneTDCcK7I\/lGsmyhLSYsm1CQpLobIombZlI7yBTWjP8omY8vIjgiaRPvpNavJB\/OE0dUaoBtX0sXgErkQkjDvU6iR4CSUIS4QOra\/WVEYn7mJn7oCH5QeI+vSi\/rYnICsqxCFt8lUV5Y87cvyTq51i8HUtLKxyXXpnMiW0i3mTav+wOWkV3quhW5s7uNJok\/IomO+GJZtT2PpSS\/r6XM7+OIOJAkjSCJDaO1NrESvlMTZimNzRxkPDPj7R1a0ISTppk1iXhPsUNUlIvjTk5inQFZcyJi4TmWvt1Q2UEqV3JOcEJU3Ni0cxvNjniy7NDl4yqqs6Oi2R4rrnyjwUwgwR\/wmPB7LNjXUL+f8eTeBJPsiXJeR8rh3wv6w\/gXAXeQlPodAAAAABJRU5ErkJggg=="}[/IMG2]

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[/TABLE]

[/TD]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014485

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014486

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014487

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014488

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002306

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002312

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002313

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002314

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002316

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002319

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002323

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002325

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002392

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003215

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003216

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003218

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003220

[/td]

[td][/td]

[/tr]

[/TABLE]
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 399"]

[tr]

[td]

PivotTable

[/td]

[td][/td]

[/tr]

[tr]

[TD="colspan: 2"] Count of Emp Code
[/TD]

[td]

Gender

[/td]

[td][/td]

[/tr]

[tr]

[td]

Unit

[/td]

[td]

Section

[/td]

[td]

F

[/td]

[td]

M

[/td]

[td]

Grand Total

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

CCL

[/td]

[TD="align: right"] 1
[/TD]
[TD="align: right"] 1
[/TD]
[TD="align: right"] 2
[/TD]

[/tr]

[tr]

[td][/td]

[td]

UPE

[/td]

[td][/td]

[TD="align: right"] 2
[/TD]
[TD="align: right"] 2
[/TD]

[/tr]

[tr]

[td]

A Total

[/td]

[td][/td]

[TD="align: right"] 1
[/TD]
[TD="align: right"] 3
[/TD]
[TD="align: right"] 4
[/TD]

[/tr]

[tr]

[td]

B

[/td]

[td]

CCL

[/td]

[TD="align: right"] 3
[/TD]
[TD="align: right"] 1
[/TD]
[TD="align: right"] 4
[/TD]

[/tr]

[tr]

[td][/td]

[td]

CPL

[/td]

[TD="align: right"] 2
[/TD]

[td][/td]

[TD="align: right"] 2
[/TD]

[/tr]

[tr]

[td]

B Total

[/td]

[td][/td]

[TD="align: right"] 5
[/TD]
[TD="align: right"] 1
[/TD]
[TD="align: right"] 6
[/TD]

[/tr]

[tr]

[td]

C

[/td]

[td]

CPL

[/td]

[td][/td]

[TD="align: right"] 2
[/TD]
[TD="align: right"] 2
[/TD]

[/tr]

[tr]

[td][/td]

[td]

MCM

[/td]

[td][/td]

[TD="align: right"] 4
[/TD]
[TD="align: right"] 4
[/TD]

[/tr]

[tr]

[td]

C Total

[/td]

[td][/td]

[TD="align: right"] 6
[/TD]
[TD="align: right"] 6
[/TD]

[/tr]

[tr]

[td]

D

[/td]

[td]

EUT

[/td]

[td][/td]

[TD="align: right"] 1
[/TD]
[TD="align: right"] 1
[/TD]

[/tr]

[tr]

[td][/td]

[td]

MUT

[/td]

[td][/td]

[TD="align: right"] 1
[/TD]
[TD="align: right"] 1
[/TD]

[/tr]

[tr]

[td]

D Total

[/td]

[td][/td]

[TD="align: right"] 2
[/TD]
[TD="align: right"] 2
[/TD]

[/tr]

[tr]

[td]

Grand Total

[/td]

[td][/td]

[TD="align: right"] 6
[/TD]
[TD="align: right"] 12
[/TD]
[TD="align: right"] 18
[/TD]

[/tr]

[tr]

[td][/td]

[/tr]

[/TABLE]

sarisri7 · Mar 15th 2018

Dear all,

Attached and shown below the xl sheet having two columns - Unit and Emp code.

I need VBA code where in column of Emp Code the values containing/starting with 'APCW2' (not exactly APCW2 but only containing) rows will be selected, cut and pasted in the new sheet of the same workbook.

Pls help me out.

[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 212"]

[tr]

[td]

Unit

[/td]

[td]

Emp Code

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014484

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014485

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014486

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014487

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW1940014488

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002306

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002312

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002313

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002314

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002316

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002319

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002323

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002325

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940002392

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003215

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003216

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003218

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

APCW2940003220

[/td]

[/tr]

[/TABLE]

sarisri7 · Mar 14th 2018

if my understanding is correct from your recent post.

you want to check duplicate POs first in column F, and those duplicate POs against Revenue cells in column V to be calculated with addition formula, and finally highlight those are equal or more than 40 k.

----------

but in the data sheet that you attached having format problems. in column F, row 3 & 4 cells highlighted in red color below having spaces in between numbers which cant be recognised by the computer. pls clear those format related issues.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 939"]

[tr]

[td]

Ord

[/td]

[td]

Nbr

[/td]

[td]

Account

[/td]

[td]

Bilt

[/td]

[td]

Bilt Name

[/td]

[td]

Po

[/td]

[td][/td]

[td]

Revn

[/td]

[td][/td]

[/tr]

[tr]

[td]

123455

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

2568069

[/td]

[td]

Cust X

[/td]

[td]

FR256806

[/td]

[td][/td]

[td]

3555.615

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123456

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

3115133

[/td]

[td]

Cust X

[/td]

[td]

2018 03 07

[/td]

[td][/td]

[td]

3566

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123457

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

3115133

[/td]

[td]

Cust X

[/td]

[td]

2018 03 07

[/td]

[td][/td]

[td]

4986

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123458

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

5175186

[/td]

[td]

Cust X

[/td]

[td]

NVBY98S

[/td]

[td][/td]

[td]

1125.668

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123459

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

3590413

[/td]

[td]

Cust X

[/td]

[td]

2018-BAT-01

[/td]

[td][/td]

[td]

185.162

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123460

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

4898780

[/td]

[td]

Cust X

[/td]

[td]

TASK0096028

[/td]

[td][/td]

[td]

176.776

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123461

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

5350076

[/td]

[td]

Cust X

[/td]

[td]

FR2005-7922-64233

[/td]

[td][/td]

[td]

1362.232

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123462

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

810653

[/td]

[td]

Cust X

[/td]

[td]

18-002-007

[/td]

[td][/td]

[td]

271.218

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123463

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

5996507

[/td]

[td]

Cust X

[/td]

[td]

1803020002

[/td]

[td][/td]

[td]

1095.011

[/td]

[TD="align: right"]1803021097[/TD]

[/tr]

[tr]

[td]

123464

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

6210799

[/td]

[td]

Cust X

[/td]

[td]

FR0135-6702-96457

[/td]

[td][/td]

[td]

143.792

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123465

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

4577224

[/td]

[td]

Cust X

[/td]

[td]

34934093

[/td]

[td][/td]

[td]

85.996

[/td]

[TD="align: right"]34934179[/TD]

[/tr]

[tr]

[td]

123466

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

3046773

[/td]

[td]

Cust X

[/td]

[td]

2286071,VPN:P4317Q

[/td]

[td][/td]

[td]

3555.615

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123467

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

3046773

[/td]

[td]

Cust X

[/td]

[td]

2286072,VPN:593-10294

[/td]

[td][/td]

[td]

235.1

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123468

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

3046773

[/td]

[td]

Cust X

[/td]

[td]

2286073,VPN:593-10295

[/td]

[td][/td]

[td]

117.55

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123469

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

3046773

[/td]

[td]

Cust X

[/td]

[td]

2286074,VPN:593-11145

[/td]

[td][/td]

[td]

52.042

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123470

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

2994754

[/td]

[td]

Cust X

[/td]

[td]

4502596934SAP3034834

[/td]

[td][/td]

[td]

563.124

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[tr]

[td]

123471

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

2003147

[/td]

[td]

Cust X

[/td]

[td]

2100563077

[/td]

[td][/td]

[td]

3870.016

[/td]

[TD="align: right"]2100566947[/TD]

[/tr]

[tr]

[td]

123472

[/td]

[td]

23456

[/td]

[td]

34656

[/td]

[td]

2995777

[/td]

[td]

Cust X

[/td]

[td]

PO65857

[/td]

[td][/td]

[td]

2020.12

[/td]

[TD="align: center"]#VALUE![/TD]

[/tr]

[/TABLE]

sarisri7 · Mar 14th 2018

The question is not clear.

Below question has many doubts. F is not pure numeric column hence greater than function cant be applicable.

And how come V column calculates by F column ? V is Numeric and F is text cum numeric based.

calculate sum of Revn column V by PO column F and copy single PO with sum greater than or equal 40K to new sheet.

sarisri7 · Mar 14th 2018

[FONT="Helvetica"]Thank you again for taking your time in replying me.

Here below my clarifications of your queries:

[FONT="Helvetica"]Query: Ok ... on row 17 of your attached file .. you have a punch in of 13:00:00 and a punch out of 13:08:00 with no date in the timestamp how am I supposed to know that it's 12+ hours or 8 minutes?[/FONT]
Ans: Regarding the Punch in 13.00:00 and Punch out 13:38:08, your assumption is correct. However, if you could observe the column named 'Worked Hours' in the sheet you can easily come to conclusion that the above is calculated 16 hours. As the 'Worked hours' column is auto-generated within the software which is available and there is no chance of mentioning the dates, So I would request you pl rely on [FONT="Helvetica"]Worked Hours column [/FONT]as the basis of hours worked for designing the VBA code to fill the Shifts.

[FONT="Helvetica"]Query: In row 3 you say simply A[/FONT]
[FONT="Helvetica"]in row 13 you give A+B[/FONT]
Ans: With regard to both the rows, 3 & 13, the 'Worked hours' column is again the base to fill/give the shifts. For example Row 3, In punch is 5.51 & out punch is 14.13 and the 'Worked Hours' automatically came as 8, hence it is A shift. And the Row 13, the in punch is 5.58 and out punch is 14.09 and the Worked hours came as 16, but it should have been 8 hours. It was a wrong calculation given under Worked hours by the system. As you send it is also A Shift. I agree with you.

Regarding the Shift Timings, I would like to mention again below for your kind reference.

Generally, Shift timings are as follows:
1) A shit: 6.00 am - 14.00, B shift: 14.00 - 22.00, C shift: 22.00 - 6.00 am, G shift: 8.30 am - 17.30 (before and after 1 Hr of shift timings will be considered in the relevant Shifts )
2) If anyone works more than 8 hrs but less than 12 hours as like 6.00 am - 16.00 (10 hrs), those will fall under the category of as: A+ B or B + C or G + extra hours Shifts
3) If anyone works more than 12 hours like 8.30 am - 23.00 (13 hrs) will be considered as 8 to 8 hours Shift.

With the revised Worked hours and timings, attached the sheet for your reference.

I would be happy to answer if any further queries.
[/FONT]

sarisri7 · Mar 13th 2018

Thank you for the reply.

Here I would like to make it more clear with regard to Shifts.

Generally, Shift timings are as follows:
1) A shits: 6.00 am - 14.00, B shift: 14.00 - 22.00, C shift: 22.00 - 6.00 am, G shift: 8.30 am - 17.30.
2) If any one works more than 8 hrs but less than 12 hours as like 6.00 am - 20.00, those will fall under the category of Overtime shift, example: A+ extra hours or B +extra hours or G + extra hours etc.,
3) If any one works close to 12 hours like 8.30 am - 22.30 will be considered as 8 to 8 hours.

There may be chances as some may work lesser than 6 hours (Example: 8.30 am - 10.30 am) in that case, it is considered as No shift.

Hope It is clear. If required more, pl let me know to provide you further details.

sarisri7 · Mar 12th 2018

attached excel file has modified sheet. you could see the column named "shift" which is having filled with A,B, C etc., shifts names in the sheet.

I need your help of creating VBA program where the "shift" column should automatically be filled with type of shifts (A,B,C etc.) based on "Inpunch and outpunch" columns and 'worked hours' columns presented in the sheet. The moment I click the button named "click for auto shit entry" which is appeared in the sheet modified the entire program of the above need to run by filling Shift column with A,B, C, G, etc., without human involvement.

sarisri7 · Mar 12th 2018

Dear Ms.Magdoulin,

to get away from all these problems, I would suggest you pls upload the xl file in this forum to get perfect solution.

sarisri7

Posts by sarisri7

VBA code to cut and paste rows from one sheet to anothersheet based on condition

VBA code to create Pivot Table - Attached xl

VBA code to cut and paste rows from one sheet to anothersheet based on condition

Macro to filter data

Macro to filter data

Help me - VBA code to produce results based on the criteria

Help me - VBA code to produce results based on the criteria

Help me - VBA code to produce results based on the criteria

VBA to Call Drop Down List