Take "strives for the great god help me to guide the vba programming, general budget earmarks" table of municipal document number, project name, the higher amount of Jeremy levin, department of four field data, strips inserted into a "special fund reconciliation table" to the corresponding accounting subjects, and summarize the subject amount calculation, I simplified the "general budget earmarks" table, only listed the "2010699 other fiscal affairs spending" a subject data, thank humbly!

CodePudding user response:

See the description of the along while you I really don't understand what you need to get the numerical

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

1/f, the great god, I am trying to figure 1. The data in the table one at a insert to figure 2 table corresponding accounting subjects, and summarize the subject amount, such as table 1 now 3, 2010699 subjects in the data, to insert to the table 2 below the line 9 of 2010699 subjects, and then inserted in line 9 summary of all the amount,

CodePudding user response:

The second floor, I tried, I can't, thank you!

CodePudding user response:

reference 4 floor weixin_41850893 response:

2 floor, I tried, I can't, thank you!

The building Lord, please simple write the content of the corresponding grid to the specified location, after that, on this basis, try to automatically determine should be written in that case, the start program written by "stupid", have no relation, somehow have to bold to write ah, there besides the cell assignment, there is no other operation, don't be afraid, bold to write,

CodePudding user response:

reference 4 floor weixin_41850893 response:

2 floor, I tried, I can't, thank you!

I don't know the building Lord have a certain level of programming?
If you have, to say you want to do with "", the current code is what the code (posted), there is what kind of problem (Bug),
So good to give you the "guidance",
If can't write, pay it for you, QQ search [email protected], clear requirements, provide some sample data, must give you a complete,
You just click of a mouse, open the "data source document", and then wait for the "the decision" to go...

If you are interested, you can see one of my statements processing software "screen video" :
https://pan.baidu.com/s/14nwKRCz9nEBXP3nfHLp0nw
This is written 10 years ago, written in VBA "software" (write in XLS document, open the document, under the condition of "allow macro run" automatic start running),
Need to load the two data source document, with the configuration file is written to relevant information,
If the specified documents already open, then read data directly from the corresponding document;
If customer haven't open the related document, will automatically open the document, read the data you need (specify the date range), after reading will automatically close the document,

CodePudding user response:

Really boring of the financial statements, will not be able to have a clean, without any summary without any format of the data sources, generating the two tables to breath

CodePudding user response:

The biggest problem is lazy and not rich second generation,

CodePudding user response:

Shouldn't be hard to implement in vba, write most of yourself, and then let others help you write a small,