how to select cells above active cell and do a sum product with other row in VBA

**Raja10** · 06-11-2020, 12:45 PM

Excel forum_1.PNG

Please see the image above. The formula needs to be dynamic as the valies in data 2 might be moving from column f to column aa and also changing the rows from 4 to 150. but the values of DATA 1 will be in the same column e but same rows as data 2.

Waiting for advice and feel free to ask any questions. Appreciate your effort in advance!

**Eastw00d** · 06-11-2020, 02:19 PM

Hi, this should do the trick:

Please Login or Register  to view this content.

Cheers
Erwin

**Raja10** · 06-12-2020, 10:01 AM

It worked

Thank you Erwin!

**Raja10** · 06-12-2020, 10:04 AM

Hello Erwin, a small doubt, what is the purpose of "&" in Dim?

Dim rn&, cn&, rn1&

**Eastw00d** · 06-12-2020, 10:21 AM

You don't have to have doubt

, it is another way of writing:

Please Login or Register  to view this content.

,etc.

If the provided solution takes care of the original question, please mark the thread as 'SOLVED' from the Thread Tools menu at top of the page & consider adding reputation(s) to those who have helped by clicking the star under their usernames

Cheers
Erwin

**Raja10** · 06-12-2020, 10:03 PM

lol, that was simple. Thank you!

how to select cells above active cell and do a sum product with other row in VBA

LinkBack

Thread Tools

Rate This Thread

Display

how to select cells above active cell and do a sum product with other row in VBA

Re: how to select cells above active cell and do a sum product with other row in VBA

Re: how to select cells above active cell and do a sum product with other row in VBA

Re: how to select cells above active cell and do a sum product with other row in VBA

Re: how to select cells above active cell and do a sum product with other row in VBA

Re: how to select cells above active cell and do a sum product with other row in VBA

Thread Information

Users Browsing this Thread

Similar Threads

Select cells below active row

Using offset function to select a range of cells based on active cell location

[SOLVED] Using code to select cells that are two cells to the left of the currently active cell

Excel 2007 : Select cells below active cell that are equal in value to active cell

[SOLVED] VBA - Can I select a new active cell based on the value of the current active cell?

[SOLVED] How do I select a cell 5 cells from the active cell?

[SOLVED] how to select specific cells to product a chart

Bookmarks

Bookmarks

Posting Permissions