Need to locate labeled cells and the corresponding values in one sheet and move them

**mmorris1965** · 07-13-2012, 10:58 AM

I need to locate a labeled cell in one worksheet and copy/sum the corresponding values within a different worksheet in a matching cell. Any assistance will be appreciated.

**dilipandey** · 07-13-2012, 11:13 AM

Hi mmorris1965,

welcome to the forum.
By labeled cell do you mean defined name?
You can use SumIF function but not sure .. try it and if no luck, upload the sample workbook. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Need to locate labeled cells and the corresponding values in one sheet and move them

LinkBack

Thread Tools

Rate This Thread

Display

Need to locate labeled cells and the corresponding values in one sheet and move them

Re: Need to locate labeled cells and the corresponding values in one sheet and move them

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions