I have a very large workbook with various worksheets. I need to data into a cell in one worksheet and have it update another worksheet. Would that be a formula?
I have a very large workbook with various worksheets. I need to data into a cell in one worksheet and have it update another worksheet. Would that be a formula?
short answer - yes, probably
edit: if you give more detail in your question, you will probably get more detail in your answer
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
One large spreadsheet (2000 rows) about 25 columns.
In those column's I enter dates, data etc. In another other worksheets within that spreadsheet I have to "tally" number of occurrences of a date or action.
Right now I'm tallying the occurrences by using COUNTIF then "typing" in the answer in the other worksheet. I'd rather it tally itself in the other worksheet without having to go and type it.
Hope this makes sense.
Suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks