Hello,
I encountered the following difficulty:
in order to make a table (as in deb.xls) I need to copy data from bal.xls based on certain criterias. I tried to make a process a litttle automatic, but I managed to do it with formula-based equations, which sometimes broke down.
what i need is to have a macro which would add to column H row 3(dispatch) of the workbook deb.xls data based on the number of the contract from the workbook bal.xls the following - "if date of dispatch equals or exceeds 01/03/2011 then total dispatch value reaches column H row 3 of deb.xls" and "if in workbook bal.xls appears another contract like A-30 then it is added to the table in workbook deb.xls repectively".
I really appreciate your help.
(column A in workbook bal.xls is just for reference)
Here are xls files - http://www.2shared.com/document/6S6MaL2p/deb.html
http://www.2shared.com/document/VyGJBYLM/bal.html
I encountered the following difficulty:
in order to make a table (as in deb.xls) I need to copy data from bal.xls based on certain criterias. I tried to make a process a litttle automatic, but I managed to do it with formula-based equations, which sometimes broke down.
what i need is to have a macro which would add to column H row 3(dispatch) of the workbook deb.xls data based on the number of the contract from the workbook bal.xls the following - "if date of dispatch equals or exceeds 01/03/2011 then total dispatch value reaches column H row 3 of deb.xls" and "if in workbook bal.xls appears another contract like A-30 then it is added to the table in workbook deb.xls repectively".
I really appreciate your help.
(column A in workbook bal.xls is just for reference)
Here are xls files - http://www.2shared.com/document/6S6MaL2p/deb.html
http://www.2shared.com/document/VyGJBYLM/bal.html
