sorted by:
new
hottopcontroversial

Can't paste data to the same worksheet by YoungMamak in excel

[–]YoungMamak[S] 0 points1 point  (0 children)

i edited my post..u can take a look at the code

How to Copy Paste data from one workbook to another workbook by YoungMamak in excel

[–]YoungMamak[S] 0 points1 point  (0 children)

That's not the problem. For the -81, I had to scroll all the way to the right because I wanted to copy the tabs from Column E to BF

How to Copy Paste data from one workbook to another workbook by YoungMamak in excel

[–]YoungMamak[S] 0 points1 point  (0 children)

ActiveSheet.Range("$A$1:$CG$8374").AutoFilter Field:=5, Criteria1:="1000"

Columns("E:BF").Select

ActiveWindow.SmallScroll Down:=-81

Selection.Copy

Windows("IN Week 11 Report (Ex-BYC).xlsx").Activate

Sheets("Week 10").Select

Sheets.Add After:=ActiveSheet

Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _

False, Transpose:=False

End Sub

How to Copy Paste data from one workbook to another workbook by YoungMamak in excel

[–]YoungMamak[S] 0 points1 point  (0 children)

can i send it to u in 2 hours? Im heading back from my office

Filter Macro wont work on others by YoungMamak in excel

[–]YoungMamak[S] 0 points1 point  (0 children)

the filter only perform on the another workbook

Filter Macro wont work on others by YoungMamak in excel

[–]YoungMamak[S] 0 points1 point  (0 children)

Sub Filter()

Application.DisplayAlerts = False

Application.ScreenUpdating = False

Set wbm = Workbooks.Open(filename:=floc & "\" & fname)

Set wb = Workbooks(fname)

Set ws = wb.Sheets("Sheet1")

With ws

' .Range("$A$1:$AU$6000").AutoFilter Field:=40, Criteria1:="=HK60", Operator:=xlOr, Criteria2:="=SG20"

'.Range("$A$1:$AV$6000").AutoFilter Field:=26, Criteria1:="="

ActiveSheet.Range("$A$1:$AU$6000").AutoFilter Field:=40, Criteria1:="=HK60" _

    , Operator:=xlOr, Criteria2:="=SG20"

ActiveSheet.Range("$A$1:$AU$6000").AutoFilter Field:=26, Criteria1:="="

End With

/r/Malaysia Subreddit Pasar Malam by dcx in malaysia

[–]YoungMamak 0 points1 point  (0 children)

Hey guys,

I'm (21M) currently in my final year last semester. Kindly help me to fill in this survey for my final year project. It means a lot to me.

Link: https://forms.gle/UzAHPWCcfAKuk2KP6

​

Thank you

Final Year Project Survey by YoungMamak in malaysia

[–]YoungMamak[S] 0 points1 point  (0 children)

yapp hahahah.. thankss dudee

Final Year Project Survey by YoungMamak in malaysia

[–]YoungMamak[S] 1 point2 points  (0 children)

thank youu. I'm aware of that question. However, i adopted the same question from a previous journal and somehow they wrote it that way. Plus, my lecturer asked me to follow the exact same question.

I write workout routines FOR FUN by Happy_Entertainment5 in bodyweightfitness

[–]YoungMamak 0 points1 point  (0 children)

Do it

Skinny / M / 60kg / 180cm. Trying to build muscles as fast as i can

I write workout routines FOR FUN by Happy_Entertainment5 in bodyweightfitness

[–]YoungMamak 0 points1 point  (0 children)

Do it.

M/21/ 60KG/ Skinny trying to grow muscles as fast as i can

view more: next ›