5 replies
by brian
I don't know what you mean by validation. There is an excel feature to only allow data if it meets a defined criteria (validation). I don't think this is what you mean. It sounds like you just want to repeat the data on another sheet. You can use a number of methods, perhaps the easiest is to create the new sheet, put the cursor in the first box you want to have the duplicate data from the other sheet appear in , hit +, navigate to the existing data and the first data cell, hit enter. The value should now be in the new sheet. You can copy by dragging and fillling the rest of the sheet to quickly coppy all values from the original sheet. These values will change as they are updated on the original.
If you want to take a snapshot use a macro to copy and paste and then assign it to a button you press. Macros can be recorded by starting the recorder, it will then watch what you do until you hit stop. Once run it will perform the same actions it recorded.
by daybreaker
This isn't really what I needed. I tried to clarify the problem in an updated comment. Thanks for trying on this one.
by daybreaker
by pubservant
by choppit
This discussion is closed to new replies.
Trending Software posts
Sort by Trending