Moving updated data from one file to another

Cawley92

New Member
Joined
May 30, 2015
Messages
1
Hello All,

I have been having a brain issue to figure out how to achieve my goal. The goal is simple however I believe that the process is difficult.

At my job we have a staff schedule that is completely Macro'd out, I did not build this file. What I would like to do is make a smaller sheet to make it easier to call staff in because of our unions we have to follow protocol and its not only one person who calls staff in but a handful of us.

The seperate sheet (RPN Tracker) I would like to make would take the "over the schedule" hours that automatically updates from the Schedule file and it would be used in the Tracker to figure out who to call first.

I do not know if i should be using VBA or formulas. It should be noted that I do not know how to use VBA.

Let me know if you guys need more information, I suck at explaining.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
you'll need to provide more data about what you currently have, and then what rules you need to action
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,165
Members
417,128
Latest member
Xianter

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