excel training in uk - linking worksheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in uk - Linking worksheets

excel training in uk - Linking worksheets

resolvedResolved · Low Priority · Version Standard

Cristina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Linking worksheets

How do we copy data from a common column in two worksheets?

RE: linking worksheets

Hi Cristina

Please cold you give us some more information regarding what you want to achieve.

EG:
Do you want to copy data from two columns, located in different worksheets, at the same time.
Why do you need to do this?
Where are you placing the results?

Thanks

Richard

RE: linking worksheets

Hi Richard,
thank you for you reply.
on a quarterly basis, I update our course postage forecast taking into account the changes in the student numbers for each course. so every quarter, I extract the student number updates from the University's planning website. then I copy (encode manually) the student numbers one by one to the row and column corresponding to the different course codes (thousands of them) in my postage forecast worksheet. The format of the two worksheets are different which is why I cannot simply copy the whole student number column from the planning report to my forecast worksheet because the rows are not identical. but in both worksheets there are same columns for Course Codes and Student Numbers. Is there a formula I can use please for this purpose?

Cristina

RE: linking worksheets

Hi Christina

Please will you send a copy of your worksheet to info @ microsofttraining . net so that we can take a look at what you want to achieve.

Thanks

Richard


 

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips


Server loaded in 0.09 secs.