I created a thread yesterday https://www.mrexcel.com/forum/excel-questions/1102769-how-set-range-vba-active-cell.html
and this is the continue of my macro which I believe has to change what I had help with yesterday .
Sorry for not thinking the whole thing through before posting
Here is what I...
Hello All,
good day. I have excel file in the below format.
Sheet Name :- Sheet1
<tbody>
QTY
Data
Value
Solution
QTY
Data
Value
1
TSK
desc1
1
TSK
desc1
2
ASD
DESC201
1
ASD
DESC201
1
ASDF
des30
1
ASD
DESC201...
I want to copy multiple lines from one sheet that have the same reference number into another sheet, any ideas how? e.g. all the rows that have the ref: 123
<tbody>
Ref
Info1
Info2
Info3
123
wer
asd
uio
456
ert
dfg
wer
123
xxy
bbg
yyhj
123
wer
asd
ffg
456
erg
wer
asd
</tbody>
Hi All
Please could help be provided with the following.
I am trying search for a value in the Name Column - in this instance ABCD and at each occurrence return the entire row associated with ABCD
Sample data
<colgroup><col><col span="6"></colgroup><tbody>
Name
Thing 1
Thing 2
Thing 3...
Hi Guys,
I will describe you my problem as far as I can. I need help with a macro which fill search for duplicates based on column D and IF THERE IS duplicated row, he will be always in next following row. Then all what we need to do is delete the duplicated rows, but add values from columns...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.