Misc. Leonardo1234 rider@1234 vixer. Highlighting. Simple Early stuff. Avinash Introduction
Avinash Singh
https://excelfox.com/forum/showthrea...ll=1#post14092
This is all just a few rough notes, mainly for my later referrence, about the World Record Holder in repeated multiple duplicated cross posting similar questions and blatant lying , ignoring, and total disrespect of all forum members helping him.
Maybe a bot? Maybe organised by excelforum owner? Maybe just a total Psycho? Or just an Autistic like character: a total 100% idiot coupled with 100% motivation/ persistence and inability to stop on a totally futile and pointless quest??
Very far from complete listing, and changing daily…
Eileen’s Lounge.
First Leonardo1234 post was at end of July 2018
http://www.eileenslounge.com/viewtopic.php?f=30&t=30447
Hans got fed up around May/June 2019
http://www.eileenslounge.com/viewtop...252759#p252759
http://www.eileenslounge.com/viewtop...252961#p252961
roger@/umpsbug/leonardo1234/c@1234
zyxw123 started 22 April 2020
excelguru.ca
leonardo1234
https://www.excelguru.ca/forums/show...h-complete-row
VBForums
kinjals
http://www.vbforums.com/showthread.p...75#post5413075
Ozgrid
jhas56788
https://www.ozgrid.com/forum/index.p...38#post1234138
https://www.ozgrid.com/forum/index.p...38#post1234938
TeachExcel
Avinash
https://www.teachexcel.com/talk/3794...te-csv-to-xlsx
MrExcel
hdgfss
https://www.mrexcel.com/board/thread.../#post-5358172
VBAExpress
KAJAL1234
http://www.vbaexpress.com/forum/show...ht=#post402805
kynga
excelforum
dumdumbum
* MoldyBread ( using someone elses’s original account )
sumanjjj
https://www.excelforum.com/excel-pro...ml#post5346727
* Zaeguzah ( original registered 2009, Avinash using only since .. 7th Aug 2020-08-17 https://www.excelforum.com/excel-pro...ml#post5376352
* quirkybox ( using someone elses’s original account )
https://www.excelforum.com/excel-pro...ml#post5381409
kynga
* At excelforum “it” appears to have temporary access to lots of existing acccounts, almost all!! Possibly this “thing” is well “at home there”…. posting poor quality similar questions over and over again… and getting answers… from the “best” people there…
Chandroo
r@1234 Leonardo1234 ANJUS rottenrogue
https://chandoo.org/forum/threads/co...4/#post-253302
https://chandoo.org/forum/threads/vb...-2#post-264459
https://chandoo.org/forum/threads/co...a-macro.44815/
kynga
ExpertsExchange
Sachin Singh
avinash singh
Avinash Singh
https://www.experts-exchange.com/que...-the-file.html
https://www.experts-exchange.com/mem...h-Singh-1.html
https://www.experts-exchange.com/mem...ash-singh.html
https://www.experts-exchange.com/mem...n-Singh-2.html
myonlinetraininghub.com
https://www.myonlinetraininghub.com/...bers-in-series
vbforums
mail2tradesmart
https://www.vbforums.com/showthread....)-by-vba-macro
Some of the known usernames. There are very likely a lot more. Both at English speaking forums and at other language speaking forums, such as Hindi
Sachin Singh
avinash singh
Avinash Singh
zyxw123
jhas56788
rider
roger
anjus
shinshan
sumanjjj
Leonardo1234
umpsbug
Kinjals
Tinamishra
kinjal124
sumanjjj123
KAJAL1234
rider1234
r@1234
ANJUS
andy124
rider@1234
fixer
c@1234
vixer
roger@
Leonard
dumdumbum
Ava453644
MoldyBread
Zaeguzah
kynga
quirkybox
Ava453644 awatesunil95@gmail.com 77.111.246.17 June 12 2020 register
103.216.212.90 14 June 2020 looking at fixer stuff after 3rd fixer ban
shiv1823@gmail.com 49.36.49.130 June 14
103.216.212.90
3 oct 2019, 07:40 PM #1
fixer The IP Address is: 103.216.212.92
The host name is: 103.216.212.92
PM: ( http://www.excelfox.com/forum/privat...=newpm&u=12517 )
07-28-2018, 07:22 PM #1
Leonardo1234 singhavinash.201351@gmail.com User: Leonardo1234 (id: 11895)
The IP Address is: 103.216.212.154
The host name is: 103.216.212.154
Fixer suryabhoir121@gmail.com User: fixer (id: 12517)
Sonntag 6 oct 103.216.212.92
The host name is: 103.216.212.92
The IP Address is: 103.216.212.93
The host name is: 103.216.212.93
Mumbai
maharashtra
Bro Subodh is no longer to help me bcoz expertsexchange has started the plans to login and ask question
HansV is not ready to help me
now u r the only hope for me just be with me for 10 question and believe me and my work will be completed bro…….
Most recent acive as dumdumbum quirkybox Zaeguzah at excelforum , zyxw123 at Eileen's Lounge and under "own" name at Experts Exchange
:
Avinash Singh
Mumbai
Hauptstadt des Bundesstaates Maharashtra in Indien
2 Attachment(s)
Copy Cell Based On Column Position Of Highlighted Cell In Matched Row
all files are located in a same place
vba code will be placed in a macro.xlsm
my first file name is 1.xlsx
my second file name is 2.xlsx
open both the files
in 1.xlsx column A consist of stock name and 1.xlsx has headers in the first row
In 2.xlsx column B consist of stock name and 2.xlsx has headers in the first row
see the pic which i attached
now what i need match column A stock name of 1.xlsx with column B of 2. xlsx and if it matches then copy the yellow highlighted colured cell data in that row of 1.xlsx and paste it to column L OF 2.xlsx
save and close both the file after doing the process
So plz help me sir in solving this problem sir
Copy and paste by highlighted colour Paste Highlighted Cells From Matched Column Rows
Hi
Your explanation is ambiguous. It could be interpreted in different ways.
So I will interpret it as I choose. It will be luck if it gives you what you want......
Looking for highlighted cells requires interaction to the spreadsheet, since no format information is held in Excel values, that is to say using the .Value Property for the complete range will only distinguish Values, Formulas, Dates and Empty cells
But some worksheet functions are efficient, for example Range.Find , SpecilaCells, Copy, Offsett.
The solution that I have chosen to do will involve an initial adjustment so that I can detect the highlighted cells in a different way. Rem 2 makes the cell values formulas: http://www.excelfox.com/forum/showth...ll=1#post12570
Here is the macro, also in macro.xlsm
Code:
Sub PasteHighlightedCellsFromMatchedColumnRows() ' http://www.excelfox.com/forum/showthread.php/2425-Copy-and-paste-by-highlighted-colour
Rem 1 Worksheets info
Dim Ws1 As Worksheet, Ws2 As Worksheet
Set Ws1 = Workbooks("1.xlsx").Worksheets.Item(1): Set Ws2 = Workbooks("2.xlsx").Worksheets.Item(1)
Rem 2 .... initial adjustment so that I can detect the highlighted cells in a different way
Dim Rng As Range
For Each Rng In Ws1.UsedRange.Offset(0, 2).Resize(, Ws1.UsedRange.Columns.Count - 2) ' We are intersted in the range offset 2 columns to the left of size 2 columns less than the main used range
If Rng.Interior.Color = 65535 Then
Let Rng.Value = "=" & """" & Rng.Value & """"
Else
End If
Next Rng
Rem 3 match column A stock name of 1.xlsx with column B of 2.xlsx and if it matches then copy the yellow highlighted colured cell data in that row of 1.xlsx and paste it to column L OF 2.xlsx
Dim Lr1 As Long: Let Lr1 = Ws1.UsedRange.Rows.Count
For Each Rng In Ws1.Range("A2:A" & Lr1 & "") ' Ws1 column A
Dim Lr2 As Long: Let Lr2 = Ws2.UsedRange.Rows.Count
Dim SrchRng As Range: Set SrchRng = Ws2.Range("B2:B" & Lr2 & "")
Dim RngMtch As Range
Set RngMtch = SrchRng.Find(what:=Rng.Value, After:=Ws2.Range("B2"), LookAt:=xlWhole, searchorder:=xlNext, MatchCase:=True) '
If RngMtch Is Nothing Then
Else ' a cell from column a 1.xlsx is matched to a cell from column B 2.xlsx
' copy the yellow highlighted colured cell data in that row of 1.xlsx
Rng.Offset(0, 1).Resize(, Ws1.UsedRange.Columns.Count - 1).SpecialCells(xlCellTypeFormulas, xlNumbers + xlTextValues).Copy
' paste it to column L OF 2.xlsx
Ws2.Range("L" & RngMtch.Row & "").PasteSpecial Paste:=xlPasteValues
End If
Next Rng ' Ws1 column A
Rem 4 save and close both the file after doing the process
Workbooks("1.xlsx").Close savechanges:=False
Workbooks("2.xlsx").Close savechanges:=True
End Sub
See also here: http://www.excelfox.com/forum/showth...ll=1#post12570
Alan
1.xlsx : https://app.box.com/s/dgufdfvw3lm3knkvwvp0xgiqpwarqf69
2.xlsx : https://app.box.com/s/51cykk4zd6ldan8puz70o3zyj0e17rwf
macro.xlsm : https://app.box.com/s/tbis0g4n6l6386df6xjwh4cirbtgphzl