excel workbooks

R

rrc52872

i am making a payroll sumary sheet for my company i am trying to get it to
communicate with my payroll data entry workbook. But the only way i can
update the formulas in the cells on summary is manually go in and change
location from where data is received. Is there a way where i can change the
date in the top colum and update all information automaticly
 
J

JLatham

It's difficult to give an absolute answer without knowing more about your
setup, but generally I would say that the answer is going to be yes.
Judicious use of the INDIRECT() and probably MATCH() and INDEX() functions
will probably achieve the results you want.

Describe the layout of your workbook(s) a bit more. First, is this all to
be in the same workbook (.xls file) or are you working across multiple files?
How is your payroll data kept up with in the book: all on one tab/sheet or
separate ones for different payroll periods? If across separate sheets, is
there a consistent naming convention for them?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel data collection 2
Links work in one workbook, not in another 6
Compiling data from many work sheets to one 1
Excel - Sliding decreasing scale (payroll tax calc) 2
One link breaks every time I open a workbook... 1
Macro Help?? Or maybe some other way to do t his 7
selecting different cell ranges across sheets, to display on summary page 4
Data aggregation with multiple workbooks 1

Top