If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Quick Excel query

petes · 2009-05-07 08:30:13

Hi gents, Say I have two worksheets within Excel, one with a list of codes and another worksheet with data. On the data worksheet say I have one cell. Is there any way that if I hightlight a cell in the codes worksheet it will copy it over to the cell in the data worksheet and this would work for each code? I need it so if…

07-05-2009 8:30am

#1

petes

Registered Users, Registered Users 2 Posts: 8,382 ✭✭✭

Join Date: August 2002

Posts: 8127

Hi gents,

Say I have two worksheets within Excel, one with a list of codes and another worksheet with data. On the data worksheet say I have one cell. Is there any way that if I hightlight a cell in the codes worksheet it will copy it over to the cell in the data worksheet and this would work for each code? I need it so if a user selects a code it will copy to this one cell in the data worksheet to evade human error.

Think I explained that okay.

Cheers

0