• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help me to cut down on having to copy & paste so much...

MysticProphet66

MysticProphet66

New Member
I have created a worksheet that has data from 10 tabs. The data from the tabs is "canned", meaning, once I type it in, it remains the same...I have one Master Worksheet and multiple copies, as I am a Psychic and provide readings to others. I have many formulas and calculations in my worksheets. I need to be able to update the data on my Master Worksheet and automatically update the other worksheets that need the same canned information.

The worksheet is a Living Document, as it updates certain information daily, monthly & yearly. I have already programmed the formulas to complete this, however I need to complete the "canned" information portions.

Can anyone help me with this situation?

Thank You and i await any responses...
 
Hi ,

Your question is quite general ; so the answer can also only be general , and is Yes. It is possible the solution may involve VBA.

If you can upload your workbook after removing all proprietary and confidential data / formulae , so that your data layout is available , and you can explain , in detail , what you wish to do , a solution is certainly possible.

Narayan
 
Hi ,

Sure. All that is needed is to know which rows and columns , from which tabs , need to be copied and pasted where.

Narayan
 
Sheet 1 is my 'Control Sheet'. It has all of the data that I need to display. The data from sheets 2-9 are the ones that need to be updated, on every identical worksheet/workbook...

I have attached the Master Blend Name Sheet Worksheet, for your review. On Sheet 1, Cells E7, F7, G7 & H7 are cells that you enter names in, cells E11, F11 & G11 are the cells that your birth information is entered in. Once information has been entered into any of these cells, "CANNED INFORMATION" returns to cells on sheet 1. Sheet 1 updates every time it is opened and every has information that changes every day, 365 days a year. I need to complete the Master Workbook and update the remaining Copies when I am completely finished with populating the Master. I currently have approximately 200+ client spreadsheets that all need to be updated, once I have finished updating the Master.

Please delete this sheet once you have used it for your purpose, ok? I have locked the sheet with a password, also.
 
Hi ,

Thanks for uploading your workbook. Can you check back after half an hour or so ? In case I have any doubts about your requirement , I'll post them. When everything is clear , then resolving your problem should be quite simple.

Narayan
 
You must log in or register to reply here.
Back
Top