Linking vs Connection

Simont485

New Member
Joined
May 19, 2018
Messages
48
Hi all

Just a bit of a general info required really.

At work I have read only access to 2 work books. Both of these are staff rotas. There are a myirad of shifts, shift lengths, shift times etc etc… Both these workbooks are just filled in manually with no useful information extracted...ie when shift cover is required there is no facility to show what shift needs to be covered and which member of staff can cover it.

Anyway I have been asked to create a 3rd wookbook to bring the two together and then to manipulate the data to be more useful to our staff.

So I have linked the 2 into one by using =(location of workbook A1) etc. This works fine but only brings in the data and none of the formatting. ( Fill colours are used a lot to show staff availability or absence for example)

I have been looking for another approach and just found connections...….what does this do? I have never used it but it sounds useful.

Any advice would be helpful.....

Many thanks


Simon
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,130,281
Messages
5,641,303
Members
417,203
Latest member
cheesegeneman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top