Hi
Whay when code run result is wrong, but if i enter formula in cell my result is positive.
Please Login or Register to view this content.
Hi
Whay when code run result is wrong, but if i enter formula in cell my result is positive.
Please Login or Register to view this content.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Maybe:
Please Login or Register to view this content.
Hello marreco,
It would help to the results of the SUMPRODUCT results for both the formula and the macro. Can you post the workbook?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi.
look my file
>>>>>>>>>>>>>
My ultimate goal is:
compares two guides based on two criteria.
on "Remittances" tab if the cells in column C is equal to cells in column C in "Sales" tab and Date (céluals column I, is three days before, has to have both guais) then.
copying to another tab
Hello marreco,
VBA does not like columns or rows in formulas like ""C:C" or "2:2". It is better to assign the starting and ending points or use a dynamic named range. The attached workbook has 2 dynamic named ranges on the Sales sheet for columns "C" and "I".
Here is the macro that will copy the SUMPRODUCT formula into the cells of column "W" on "remittances".
Please Login or Register to view this content.
Hi Leith Ross
Very very good, i like, thank you very much!!!!!!!
Hello marreco,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks