Warsop Web Community Forum

Warsop Web Homepage | Contact Us

RSS Feed

EXCEL

A place to discuss and post all about personal computing including new technlogy, reviews, technical support, networking and other home related technology issues.
Forum rules
Please READ: Forum Rules & Regulations

EXCEL

Postby moanersRus » Fri Aug 22, 2008 9:18 pm

Does anyone know how i can get some data off one worksheet to copy onto another worksheet?

eg

on one worksheet i have the staff rota

on 3 other worksheets i have the timesheets for them to ftill in BUT we put on there actual rota so we can see what they should work and what they did.

i require cells to copy but also reupdate when i write another rota.


at the mo we copy and paste each line onto the timesheets but this is time consuming
Of all the things i've lost, i miss my mind the most
moanersRus
Lifetime Registered User
 
Posts: 5018
Joined: Wed Aug 23, 2006 12:15 am
Location: My bed, Red's bed not anymore it's OUR bed

Postby moanersRus » Fri Aug 22, 2008 9:25 pm

SORTED, paste special!!!
Of all the things i've lost, i miss my mind the most
moanersRus
Lifetime Registered User
 
Posts: 5018
Joined: Wed Aug 23, 2006 12:15 am
Location: My bed, Red's bed not anymore it's OUR bed


Return to Tech' Zone

Who is online

Users browsing this forum: No registered users and 2 guests

cron