SUMIF from another workbook
Right here we go:
Get file to 'read' - (file = Application.GetOpenFilename) If the cell in the current book contains a formuls do nothing If not then do the equivelent of this formula: =IF($C8"",SUMIF([file]Sheet1!$D:$D, $C8, [file]Sheet1!$E:$E),"") move down one cell and repeat do until column end. when it goes down each row the SUMIF would need to increment C9 then C10 etc etc Any help will be much appriciated. Cheers Tom |
All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com