Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rewrite sheet with some saved values
I have a multi-sheet workbook that calls a routine to rewrite sheet4 based on values in sheet1 each time sheet4 becomes the active sheet. This script makes single line entries or double line entries in sheet4 depending on whether data appears in one or both of a two specific data cells (col:J,K) in sheet1. However I now need to manually input extra data items into blank cells (col:B,C,J) in sheet4 and retain those data items after input, but each time I make sheet4 the active one it clears the contents of all the cells including the data that I have entered into cols B,C,J. Is there a way of fixing cols B,C,J on sheet4 so that they are not cleared when sheet4 is activated/rewritten. Or is there a way of writing just the the additional lines added to sheet1 since sheet4 was previously activated rather than clearing all the data lines written previously into sheet4 and then rewriting them all from scratch each time the sheet4 becomes the active one. I think you will need to see the workbook that I am working on to see how the sheets link and a zipped blank version is attached. Any help would be much appreciated as amending the existing macro appropriately is a little beyond me. Hope the above explanation makes sense. +-------------------------------------------------------------------+ |Filename: Test_blank.zip | |Download: http://www.excelforum.com/attachment.php?postid=5176 | +-------------------------------------------------------------------+ -- madwoman ------------------------------------------------------------------------ madwoman's Profile: http://www.excelforum.com/member.php...o&userid=28221 View this thread: http://www.excelforum.com/showthread...hreadid=570503 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rewrite name in new format | Excel Discussion (Misc queries) | |||
Values In Links Not Being Saved | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
How to Rewrite these Code? | Excel Programming |