You are an amazing genius!!!!! I've been working on something like this for over a day. The use of rng1 & rng2 with the "my_range" formula is EXACTLY what I was looking for!!!!!!!! THANK YOU SO MUCH!!!!
You don't understand how powerful that piece of vba is!!! With a few tweaks needed to make it utilize my information, I was able to make a "delete last entry" macro that works like a champ now! Keep up the amazing work. Had to subscribe for all that work!! Thank you again!!!!!!!!!
Can you help me with the code when I am trying to look for more than one value in the loop? I am looking for values Sheet 2 row E (rows 2-1082) in the entire row (A) from Sheet 1 and pasting all row values containing the values in sheet 2. I'm struggling with the loop
Sir, my data in A2 to h12 and it may increase. I want to copy paste one by one column like first A2:A12, then b2:b12, C2:c12 and next dynamic. Pl help..
@@ExcelDestination can you help me with that, what im trying to do is, i have Cheques Sheet and i want to copy the cheques in the registry to another sheet
How if i don't want to define the source value cell (Product ID) but have excel search for the column with "Product ID" header(no case match) and then use that column and its rows till end to lookup all the values and return results? And also do the same for the destination range (Find the column by "Jun" "Jul" etc...)
You can count total worksheets and then activate the last worksheets. Check this for help th-cam.com/video/AlC8a7KyJq0/w-d-xo.html you can take logic from this
Sir, if range of rows need to be selected instead of range of columns, then what is the formula? Forexample, instead of G10 to L10, I want to select C20 to C30, please help me in this regard. Thank you
Excellent Video, I have solved my problem by seeing this. Just awesome ❤❤❤
You are an amazing genius!!!!! I've been working on something like this for over a day. The use of rng1 & rng2 with the "my_range" formula is EXACTLY what I was looking for!!!!!!!! THANK YOU SO MUCH!!!!
Glad I could help!
for any excel vba task, you can contact me on exceldestination@gmail.com
You don't understand how powerful that piece of vba is!!! With a few tweaks needed to make it utilize my information, I was able to make a "delete last entry" macro that works like a champ now! Keep up the amazing work. Had to subscribe for all that work!! Thank you again!!!!!!!!!
Thank you so much!! I been working all day long trying to find something like this :)
Glad I could help!
Sir, what will happen if the product id is available in more than 2 rows ? Will all data copied to sheet 2? 24-07-2020
13:05 your row number is dynamic... your column is not. How can this be done with all data on the same row, but a dynamic column range?
Helpful. Thank you....
Welcome
Can you help me with the code when I am trying to look for more than one value in the loop? I am looking for values Sheet 2 row E (rows 2-1082) in the entire row (A) from Sheet 1 and pasting all row values containing the values in sheet 2. I'm struggling with the loop
Sir, my data in A2 to h12 and it may increase. I want to copy paste one by one column like first A2:A12, then b2:b12, C2:c12 and next dynamic. Pl help..
Great Video, but if i want to copy many rows with Product ID 1005 not only one how to do it please ?
you can use looping for that
@@ExcelDestination can you help me with that, what im trying to do is, i have Cheques Sheet and i want to copy the cheques in the registry to another sheet
How if i don't want to define the source value cell (Product ID) but have excel search for the column with "Product ID" header(no case match) and then use that column and its rows till end to lookup all the values and return results? And also do the same for the destination range (Find the column by "Jun" "Jul" etc...)
you can take help for searching column by name from one another tutorial. Link is :
th-cam.com/video/7n0BU4Dmo48/w-d-xo.html
far cry for parctical problem ?? where in earth you know your sheet size ??
not sure about your question
Thanks sir
sir how to select workbook last sheet activite
You can count total worksheets and then activate the last worksheets. Check this for help th-cam.com/video/AlC8a7KyJq0/w-d-xo.html you can take logic from this
Sir, if range of rows need to be selected instead of range of columns, then what is the formula? Forexample, instead of G10 to L10, I want to select C20 to C30, please help me in this regard.
Thank you
Plz give code in practice file
send me email at EXCELDESTINATION@GMAIL.COM, I will reply with file with code.
Merci
Bonjour!!!!!
Great work sir, will u give me ur mail id plz, I won't to send u a Excel file for such type of problem, Thank u.
EXCELDESTINATION@GMAIL.COM
@@ExcelDestination Thank u sir