VBA for Dynamic Range by Row and Column

[@md.saifulislam860]

Excellent Video, I have solved my problem by seeing this. Just awesome ❤❤❤

[@nsanerydah]

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!!!!

[@ExcelDestination]

Glad I could help!

[@ExcelDestination]

for any excel vba task, you can contact me on [e-mail]

[@nsanerydah]

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!!!!!!!!!

[@russo6770]

Thank you so much!! I been working all day long trying to find something like this :)

[@ExcelDestination]

Glad I could help!

[@karunanithir1510]

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

[@shareef207]

Helpful. Thank you....

[@ExcelDestination]

Welcome

[@sahebraophalke6986]

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..

[@jennaadams4680]

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

[@Ramzyar]

Great Video, but if i want to copy many rows with Product ID 1005 not only one how to do it please ?

[@ExcelDestination]

you can use looping for that

[@Ramzyar]

@@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

[@bikramsingh2014]

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...)

[@ExcelDestination]

you can take help for searching column by name from one another tutorial. Link is : kzbin.info/www/bejne/bZ-Tc4hqedKiapo

[@arifulhoque4547]

Thanks sir

[@mohamadmagic3815]

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?

[@bharatgupta8766]

far cry for parctical problem ?? where in earth you know your sheet size ??

[@ExcelDestination]

not sure about your question

[@sureshjogi9626]

sir how to select workbook last sheet activite

[@ExcelDestination]

You can count total worksheets and then activate the last worksheets. Check this for help kzbin.info/www/bejne/d52maZRtgN59p5I you can take logic from this

[@shareef207]

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

[@bassisessaidexcel]

Merci

[@ExcelDestination]

Bonjour!!!!!

[@kaanapadhiyar1143]

Plz give code in practice file

[@ExcelDestination]

send me email at [e-mail], I will reply with file with code.

[@nileshgosavi]

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]

[e-mail]

[@nileshgosavi]

@@ExcelDestination Thank u sir