VBA - consolidate data -- 2


I have a project to create a macro in Excel. I have attached a file with two sheets that contains examples of what I am after. In Sheet1 I have the dates, codes, descriptions and amounts of certain transactions. The data in Sheet1 contains multiple listings of the same code on the same day, with different amounts for each row. The macro needs to consolidate this data into Sheet2. The macro should consolidate the data if there is a repeat of the same code on the same day, and sum the debit and credit amounts for this code into a single row. This way Sheet2 contains a single row for each different transaction code on each day, but only one row for each different transaction code for each day. Can the macro please be done using a loop as the row lengths will get quite large and will be variable, thanks for your help!

Taidot: Excel, Visual Basic

Näytä lisää: cut paste data excel vba, select data excel vba form access, read data webpage vba, extract data web vba, creating xml file data excel vba, collect data url vba, as400 data excel vba, extract data email vba, extracting data html vba, adding data table vba access, create data report vba sql, extracting data outlook vba, data encoding vba excel, conversion excel data xml vba

Tietoa työnantajasta:
( 8 arvostelua ) Sydney, Australia

Projektin tunnus: #13224242

Myönnetty käyttäjälle:

$25 AUD 0 päivässä
(237 Arvostelua)

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

$40 AUD 1 päivässä
(112 arvostelua)
$55 AUD 1 päivässä
(2 arvostelua)
$80 AUD 1 päivässä
(1 arvostelu)