Match or Vlookup

[nasser]

Hi there .. I attached here a sheet that i want to work in ...
i'm not sure if i have to use the Match or Vlookup or which function to make it work as i want !!!
i attached the sheet it self
thank you all and best regards

[VBA Noob]

Hi,

Does this help

Please turn off your right to left view

VBA Noob

[nasser]

it's looks working ...but what in case of i want to add more data (names, telephones, limits....) and i don't want to edit the formula
i attached the file + another pic. that if i want to add more icons for the macros can this be???

thank you

[VBA Noob]

Hi,

This link should help with adding new buttons.

http://office.microsoft.com/en-us/ex...548161033.aspx

To turn off the brush unclick it on the toolbar. Should be just below the Data dropdown menu

Will have a look at the file in a minute

VBA Noob

[VBA Noob]

Yes

Take a look at the macro link while I take a look at your attachment

VBA Noob

[nasser]

Thank you i think it's what i want exactlly ...
and i will be waiting for ur reply about the sheet

[VBA Noob]

Hi,

Try using a dynamic range (For more on dynamic range see the attached link)
and Named Ranges

http://www.contextures.com/xlPivot01.html

VBA Noob

[nasser]

thank you VBA so much i think it's what i want for that part i did finished that part of course with ur fully helping to me

thanks alot

best regards

[VBA Noob]

No Problem

Glad it helped

VBA Noob

[nasser]

hey VBA ..how r u doing ???
wish everythings going great
i'm back with the same Sheet but after some edits and i think it will be it's final look
some good ppl here as u helped me geting it this way ,, but i still have some problems in it , i wrote why i try to make this file and what;s for , that may help u to help me get it in some good way ,,
i attached it hope u plz take a look at it