wanabekiwi
New Member
- Joined
- Jul 19, 2010
- Messages
- 2
Hi'
i'm new to this macro stuff and have been slowly working through some of the Mr excel lesons i have a problem / question i have a price list which i want to make an updater for. I need some help on find and referncing a cell?
So i want to write a macro to find the product code i enter into say cell "A2" on "Sheet 1" in colum A on "Sheet 2" and then take the new price from say "B2" on "Sheet 1" and paste it into the 4 colum cell which relates to the find in "sheet 1"
i am sure that is very bad english i hope you understand.
the actual problem is a bit more complex but once i understand the basics i will sort the rest outr my self
cheers for any help
i'm new to this macro stuff and have been slowly working through some of the Mr excel lesons i have a problem / question i have a price list which i want to make an updater for. I need some help on find and referncing a cell?
So i want to write a macro to find the product code i enter into say cell "A2" on "Sheet 1" in colum A on "Sheet 2" and then take the new price from say "B2" on "Sheet 1" and paste it into the 4 colum cell which relates to the find in "sheet 1"
i am sure that is very bad english i hope you understand.
the actual problem is a bit more complex but once i understand the basics i will sort the rest outr my self
cheers for any help