find & copy value in different sheets

i have two sheets where i need to take in values in sheet2 to display in sheet1. instead of copy pasting, i want to create a macro since its easier.

Sheet1:

A B C
1 KPI Card Paper
2 Income
3 Losses


Sheet2:

A B C
1 KPI Card Paper
2 Income 12 13
3 Losses 9 5

i need to display the numbers in Sheet1 but based on the following:

if i click on the third cell in column B to get the value for income, the macro is supposed to read the value in col B row 1, find a match in sheet2's range
A1:C1, go back to sheet1 and read value in A3, find a match in sheet2's range A1:A3. if it satisfies both conditions, the value displayed in sheet1 will be retrieved from B2 in sheet2.

any idea?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories