VBA for Dynamic Range by Row and Column

Подписаться 45 тыс.

Просмотров 36 тыс.

50% 1

This Excel VBA Tutorial explains, how to select, copy and paste
range by using row and column numbers. It explains how to search
value in large data on different sheet and if it is found then
copy vba range with row and column numbers and paste to another sheet. Sometimes, we don't want to copy entire row for matching value and we want to copy only specific range then this example explains easy vba code for selecting range using row and column number.

Опубликовано:

22 ноя 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 30

@md.saifulislam860 8 месяцев назад

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

@nsanerydah 4 года назад

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 4 года назад

Glad I could help!

@ExcelDestination 4 года назад

for any excel vba task, you can contact me on exceldestination@gmail.com

@nsanerydah 4 года назад

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 3 года назад

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

@ExcelDestination 3 года назад

Glad I could help!

@arifulhoque4547 4 года назад

Thanks sir

@shareef207 Год назад

Helpful. Thank you....

@ExcelDestination Год назад

Welcome

@karunanithir1510 4 года назад

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

@jennaadams4680 3 года назад

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

@bikramsingh2014 4 года назад

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 4 года назад

you can take help for searching column by name from one another tutorial. Link is : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7n0BU4Dmo48.html

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

@Ramzyar 3 года назад

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

@ExcelDestination 3 года назад

you can use looping for that

@Ramzyar 3 года назад

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

@bharatgupta8766 3 года назад

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

@ExcelDestination 3 года назад

not sure about your question

@bassisessaidexcel 4 года назад

Merci

@ExcelDestination 4 года назад

Bonjour!!!!!

@sureshjogi9626 4 года назад

sir how to select workbook last sheet activite

@ExcelDestination 4 года назад

You can count total worksheets and then activate the last worksheets. Check this for help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AlC8a7KyJq0.html 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