I am looking for a little help. I am new to all of this and would appreciate any feedback. Thank you in advance. Here is what I am trying to accomplish:
I have multiple companies that I need to bill on a monthly basis.
The billing details are broken up into 4 categories, each with sub sections.
The sub section details come from another excel source at the end of each month.
What I would like to do is have one master workbook that has the ability to import this information (link???) without my intervention (except to hit ok to update). I would like this workbook to imput information based on the MONTH that I type in a cell (say A1).
What I have created is a workbook with 5 sheets. 1 for each client and 1 as a summary. I would like to pull the information into the individual worksheets. The rest, based on my limited skills in linking, will flow to the summary.
noob,
JWo5173
[/list]
I have multiple companies that I need to bill on a monthly basis.
The billing details are broken up into 4 categories, each with sub sections.
The sub section details come from another excel source at the end of each month.
What I would like to do is have one master workbook that has the ability to import this information (link???) without my intervention (except to hit ok to update). I would like this workbook to imput information based on the MONTH that I type in a cell (say A1).
What I have created is a workbook with 5 sheets. 1 for each client and 1 as a summary. I would like to pull the information into the individual worksheets. The rest, based on my limited skills in linking, will flow to the summary.
noob,
JWo5173
[/list]
