Help with VBA code
Hey
I need to copy data from sheet E-1 and past it on sheet Overdue.
The data that i need to copy shows have a value between -1 and -1500 and is in column Z. it needs to copy that entire row to sheet Overdue.
I want to create a button so that everyday i can update that data.
The other problem is that i am going to add remarks net to each overdue item and when i update the data everyday the remarks will not correspond to the origanal row. The reason why i am saying this is because items will be added and removed on the overdue schedule on a daily bases
i somehow need a vba code to copy the data to a sheet. and then when i put remarks next to it, it needs to stick to that row so if i delete items or copy the new data of the next day it should still correspond to the previous rows
I hope the one that replies that everything is clear and understanable
Thanks
WesleyM101
- WesleyM101's blog
- Login or register to post comments
- 4280 reads
not hugely clear... best is
not hugely clear... best is to add an example sheet clearly showing what you're after.
- login and edit your post
Help
Hi check the blog page i have uploaded an example there
Solution
vba HELP
Hey
i copied the code you send me into the excel workbook and the it gives the following error when i want to run it
Compile Error
Only Comments May appear after End Sub, end function or end properties
Please help me sort this out
you must have copied it
you must have copied it incorrectly... try again
hELP
I have done everything from the beginning again. i copied everything that was in the box above.
Now the macro does not want to run anymore
Copy it in a general module.
Copy it in a general module. The code copies only those rows which are not there in overdue sheet and value is <0. In the file that you have attached there is no such record.