hi
i need to be able to keep formuas in t2:t50 (sheet3) when items are posted from sheet3 by sheet(frmissued),i enter a date in sheet3 h2:h50 which gives me a due date (7 days later ) in t2:t50, but when i save sheet and delete entries it also deletes the formula in t2:t50,how can i make t2:t50 reset to =h2:h50+7
any help would be good please
cheers colin
Last edited by cfinch100; 04-06-2015 at 01:51 AM.
hi
forgot to add only some rows will be posted at a time and others maybe later so say first 3 rows posted today and maybe next 4 rows tomorrow if that makes sense and if it makes a difference to code
cheers colin
hi
still having problems with this have tried various things but it deletes formuls ,problem is as it only posts or saves some and not all at once it deletes all not just the ones saved
cheers colin
hi after a long time have finally done it ,made a macro,here it is if it helps anyone else
Please Login or Register to view this content.
cheers colin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks