Previous Topic Next Topic

Selecting the different Range of cells based on values

Closed
AKILSYED Posts 1 Registration date Thursday August 11, 2016 Status Member Last seen August 11, 2016 - Aug 11, 2016 at 07:49 AM
 Blocked Profile - Aug 11, 2016 at 05:12 PM
Hi all,
consider the Excel sheet
A B C D
1 NAME CITY AGE CLASS
2 ALEX NEWYORK 20 D
3 JOHN DURBAN 20 A
4 PRINCE DELHI 20 V
5 AMY TOKYO 20 C
6 LUCY MOSCOW 20 W
7 CARA LONDON 20 E

here I need the VBA logic based on the following scenario

IF city = Newyork, i have to copy and paste
DURBAN 20 A
DELHI 20 V

IF city = Tokyo, i have to copy and paste
MOSCOW 20 W
LONDON 20 E

please give me VBA logic how to copy that cells dynamically based on values in cell and paste in another excel sheet

Thanks in Advance
@akilsyed
Related:

1 response

Answer 1 / 1
Blocked Profile
Aug 11, 2016 at 05:12 PM
The if statement is as follows:

=IF(logictest,true,false)

You can nest IF as in:

=if(a2="newyork",B2 & "-" & b3 & "-" & b4,if(a2="tokyo",c2 & "-"c3 & "-" & c4,"NEITHER ONE!")

Try some of your own!

It's kind of fun to do the impossible! -Walter Elias Disney

Similar discussions

Excel Macro - Set and autofill a range?
KT -
excel987 -

Hello,
I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column with another value.

My biggest problem is that I cannot specify the range and then auto-fill it with a value. I need the range to start at F1 and go to the last populated cell.

Here's what I've tried (part of it is from the recorded macro - I am new to this.). I would really appreciate anyone's advice! Thanks.

This is a snippet of the "recorded" macro that works. I basically need to replace the range "F1:F226" with a range that is F1 to the last populated cell.

Range("F1").Select...

28 responses
help me to add particular cells
mathewmunna -
mathew munna -

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

2 responses
Nfs most wanted 2005 shows "please insert the correct CD
Prabal -
ac3mark -

Hello, in nfs most wanted 2005 using ws 10 pro
I wana ask that why if I click on the application it a shows "please insert the correct CD room,select OK and restart application" please help me

1 response
Can you rename the inputs on LG Smart TV (WebOS)?
sjdunning -
dhh1 -

Is there a way to rename the TV inputs so you don't have to remember what input is connected to what? This would be a nice feature to have.

4 responses