Accounting Software Import

[cardan]

Hello,

I have a problem that I am finding complex. Basically, I import
numbers from an accounting program that has accounting codes, budget
totals and amount spent, and remaining cash flows for each accounting
code. these numbers arranged in columns with the smallest code at the
top.

When it is imported into Excel for the first time, monthly headers are
added and then the remaining cash flow for each code is spread out
manually under the appropriate month.

Each month, the latest numbers and codes are imported and the monthly
numbers are tweeked to equal the new remaining cash flow.
Essentially, the code, code description, budget, amount spent,
remaing cash flow, and the remaining cash flow in the appropriate
month column are all on the same row.

The issue surfaces, when the latest numbers are imported into excel
and an additional code has been added, therefore the new numbers and
the previous numbers that were manually put in do not line up
anymore.

Is there a way to add a new row, in its seqential order when the new
code comes in while still keeping the manual inputs and their codes in
the respective place?

Any advice would be greatly appreciated. Thank you for your time.

 

[Guest]

You are not specifying how you are import the data. Is it a macro or some
other method like cut and paste or usingg the Excel Import function.

One thing you can do easily is to add the missing row before importing the
data. this will depend on the way you are importing the data.

Need more details before I can can tell you the right way of fixing the
problem. I believe the the problem can be solved with a litttle bit of code.

 

[cardan]

You are not specifying how you are import the data. Is it a macro or some
other method like cut and paste or usingg the Excel Import function.

One thing you can do easily is to add the missing row before importing the
data. this will depend on the way you are importing the data.

Need more details before I can can tell you the right way of fixing the
problem. I believe the the problem can be solved with a litttle bit of code.











- Show quoted text -

Thank you for the response Joel. Importing is done by cut and paste at
this time. Over the past day, I think I figured out a way work-
around of my major issue listed above. I made a template sheet (cash
flow sheet) and listed every code on another sheet (hard coded) and
then a VLOOKUP will align the remaining cost number from the imported
page (Import Page) to the appropriate code. However, I have now ran
into other issues. The list of codes is over 900. This makes for way
too much scrolling. A project may use 100 of these codes. Since a
project has only 100 codes and the new cash flow template sheet has
900, I wrote a formula that will return "XXXX" in the remaining cash
flow line if the new cash flow template cannot find the code on the
Imported page. What I would like to do is have a macro that will hide
all the rows with XXXX in them as well as unhide rows if it changes
from XXXX if it picks up a value from the Import Page. Is this
possible? Thanks again for your response. I am very appreciative!