PDA

View Full Version : Populating sheets with data from another sheet



thunolir
08-05-2008, 03:53 AM
Hi All,
I had developed a model to work out the Rental Accrual and Prepaid on a monthly basis. This model is to be updated every month after Accounts Payable posts respective invoices, which may have around 4500 lines. Is there any VBA code that will allow me to enter those monthly DATA into the MODEL, instead of cut and paste which takes ages.

I have attached the Excel files as a sample. The sheet named DATA is what is to be added to the sheet named MODEL. The Model sheet should pick up the site details from Data sheet and add it to the one immediately below the respective site code and then copy the formula above it and update the total.

Please help.
thunolir@googlemail.com