Posts by lopapa

lopapa · Feb 28th 2014

Hi can you help me to get the formula how to count the duplicate value: E.g.

[TABLE="width: 141"]

[tr]

[td]

Number

[/td]

[td]

count

[/td]

[/tr]

[tr]

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

[/tr]

[tr]

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

[/tr]

[tr]

[TD="align: right"]7738360[/TD]
[TD="align: right"]3[/TD]

[/tr]

[tr]

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

[/tr]

[tr]

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

[/tr]

[tr]

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

[/tr]

[tr]

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

[/tr]

[tr]

[TD="align: right"]43731[/TD]
[TD="align: right"]3[/TD]

[/tr]

[tr]

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

[/tr]

[tr]

[TD="align: right"]43731[/TD]
[TD="align: right"]5[/TD]

[/tr]

[tr]

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

[/tr]

[tr]

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

[/tr]

[tr]

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

[/tr]

[tr]

[TD="align: right"]38360[/TD]
[TD="align: right"]3[/TD]

[/tr]

[tr]

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

[/tr]

[tr]

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

[/tr]

[/TABLE]

lopapa · Oct 21st 2013

Hi Guys! Can you please modify my code below:

So I can get all the data and tranfer to a new workbook

For ex: Column: A, B, and C
Column Name - First name Last name Nickname
Row Value: Kevin, Durant, KD
Kobe, Bryant, Blackmamba
Michael, Jordan, Air Jordan : the out should be transfer all the value to anothe Workbook - My code only transfer the FIRST LINE which is Kobe bryan Black mamba Can you please help me

[TABLE="width: 215"]

[tr]

[td]

First name

[/td]

[td]

Last name

[/td]

[td]

Nickname

[/td]

[/tr]

[tr]

[td]

Kobe

[/td]

[td]

Bryan

[/td]

[td]

Black Mamba

[/td]

[/tr]

[tr]

[td]

Kevin

[/td]

[td]

Durant

[/td]

[td]

KD

[/td]

[/tr]

[tr]

[td]

Michael

[/td]

[td]

Jordan

[/td]

[td]

Air Jordan

[/td]

[/tr]

[/TABLE]

Code

Sub Button2_Click()


Dim fName As String
Dim lName As String
Dim mName As String




Worksheets("Sheet1").Select
fName = Range("A2")
Worksheets("Sheet1").Select
lName = Range("b2")
Worksheets("Sheet1").Select
mName = Range("c2")




Set myData = Workbooks.Open("C:\DATA\Output.xlsx")
Worksheets("Sheet1").Select
Worksheets("Sheet1").Range("a2").Select
RowCount = Worksheets("Sheet1").Range("A1").CurrentRegion.Rows.Count




With Worksheets("Sheet1").Range("a2")
.Offset(ColumnCount, 0) = fName
.Offset(ColumnCount, 1) = lName
.Offset(ColumnCount, 2) = mName




End With




myData.Save








End Sub

Display More

lopapa · Oct 18th 2013

Re: Transfer all value to one workbook to another woorkbook

What is code tag?

lopapa · Oct 18th 2013

Hi guys!

Please help.

I'm trying to transfer all of my value to new a woorkbook however the only value that transfer to is on the 2second column. Can you pls help me.

For ex: A B C
Column - First name Last name Nickname
Row: Kevin Durant KD
Kobe Bryant Blackmamba

Will transfer to another Workbook which I already figure it out.

#Sub Button2_Click()

Dim fName As String
Dim lName As String
Dim mName As String

Worksheets("Sheet1").Select
fName = Range("A2")
Worksheets("Sheet1").Select
lName = Range("b2")
Worksheets("Sheet1").Select
mName = Range("c2")

Set myData = Workbooks.Open("C:\DATA\Output.xlsx")
Worksheets("Sheet1").Select
Worksheets("Sheet1").Range("a2").Select
RowCount = Worksheets("Sheet1").Range("A1").CurrentRegion.Rows.Count

With Worksheets("Sheet1").Range("a2")
.Offset(ColumnCount, 0) = fName
.Offset(ColumnCount, 1) = lName
.Offset(ColumnCount, 2) = mName

End With

myData.Save

End Sub

#

lopapa · Aug 26th 2013

Re: Getting the top 3 value within different sheet using a button in Macro

haha i need to use macro..

What if i have 100 column. do i need to check each one of the sheet? that the reason why i need to user macro..

lopapa · Aug 26th 2013

Re: Getting the top 3 value within different sheet using a button in Macro

I just need to get the logic. Actually that is not my assignment, that is only the concept.! Thank you for your help..

lopapa · Aug 26th 2013

Hi All.

I need your help.

Here is the concept of my assignment.

I need to use a Macro..

The problem is

There are 3 sheet.

sheet1 -

[TABLE="width: 147"]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[/TABLE]

sheet2
[TABLE="width: 147"]

[tr]

[td]

Department

[/td]

[td]

Score

[/td]

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[/TABLE]

sheet3 - The output

I need to use a button here:
so the out will be:
[TABLE="width: 96"]

[tr]

[TD="width: 64, bgcolor: transparent"]Sam2[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]99[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam2[/TD]
[TD="bgcolor: transparent, align: right"]96[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam2[/TD]
[TD="bgcolor: transparent, align: right"]95[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam3[/TD]
[TD="bgcolor: transparent, align: right"]98[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam3[/TD]
[TD="bgcolor: transparent, align: right"]95[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam3[/TD]
[TD="bgcolor: transparent, align: right"]95[/TD]

[/tr]

[/TABLE]

Any suggention guys? please help me.

lopapa · Aug 26th 2013

Hi new here.

I'm currently creating my Macro. Can you please help me!

Here is the scenario: I need to get the Top 3 for each departement.

Sheet 1:

[TABLE="width: 147"]

[tr]

[td]

Department

[/td]

[td]

Score

[/td]

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam3

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[tr]

[td]

Sam2

[/td]

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

[/tr]

[/TABLE]

The output will be in the sheet 2.

[TABLE="width: 96"]

[tr]

[TD="width: 64, bgcolor: transparent"]Department[/TD]
[TD="width: 64, bgcolor: transparent"] Score[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam3[/TD]
[TD="bgcolor: transparent, align: right"]98[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam3[/TD]
[TD="bgcolor: transparent, align: right"]95[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam3[/TD]
[TD="bgcolor: transparent, align: right"]95[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam2[/TD]
[TD="bgcolor: transparent, align: right"]99[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam2[/TD]
[TD="bgcolor: transparent, align: right"]96[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"]Sam2[/TD]
[TD="bgcolor: transparent, align: right"]95[/TD]

[/tr]

[/TABLE]

lopapa · Aug 24th 2013

Re: Top 10

Hi.

I want to use VBA.

For example.

Sheet1 Column A The value are

6
7
20
34
54
65
76
345
65
34
56
5345

and then I will add a button in sheet2 so when I click the button the output will be in the column a sheet2 is

[TABLE="width: 48"]

[tr]

[TD="class: xl63, width: 64, bgcolor: transparent, align: right"]5345[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]345[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]76[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]65[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]65[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]56[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]54[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]34[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]34[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent, align: right"]20
Thanks !![/TD]

[/tr]

[/TABLE]

lopapa · Aug 24th 2013

Hi Guys,

I need you help.

Can you help me getting the top 10:

For example

Column A

I have

11
10
9
8
7
6
7
5
5
3
2

and i need to get the top10 and transfer it to sheet2
so the output should be

11
10
9
8
7
6
7
5
5
3
2

Thanks for your help

Posts by lopapa

Count the Duplicate value

transfer of value from workbook to a new workbook

Transfer all value to one workbook to another woorkbook

Transfer all value to one workbook to another woorkbook

Getting the top 3 value within different sheet using a button in Macro

Getting the top 3 value within different sheet using a button in Macro

Getting the top 3 value within different sheet using a button in Macro

Please help me!!! Im new in Macro

Top 10

Top 10