Forum Discussion
How to insert a row in worksheet A and have it auto populate in worksheet B
Thank you, for the reply. This is what im working on.
Sheet A - Input all data.
Part of this data will be the chart ( Type Manufacturer etc. )
Depending on the size of the project we will be adding rows of data to the chart.
Sheet B - Output - We only want worksheet B to show the data in the chart. Because this data will be sent out to our team for the project. While the other information in A will be internal. This way our team can just print or save sheet B for external use.
I hope this helps with the why.
Jessica -- thanks for that explanation. I will admit to being still a bit confused. You speak of "our team" as receiving 'just the data" as it appears on Sheet B. But then refer to the information on Sheet A as "internal" ....leaving me wondering "isn't 'our team' on the same team as 'internal'?" But I do see something I hadn't noted before, that there is different info on A than on B, and more hidden columns on B (a LOT) ....which leads me to a different suggestion altogether.
I'm going to suggest that you familiarize yourself with Custom Views. And I've created some using your example sheet.
See the attached revised version of your original example. When you open it you'll see Sheet A pretty much as you original created it. You'll see (don't be alarmed) that I removed the bottom cell, the one that spanned the entire width, with what looked to be key "footnote' kind of info. I say "Don't be alarmed" because it still is available, as a custom footer that prints whenever you print this sheet.
So you'll open the sheet to see pretty much what Sheet A had to begin with. Go in the main menu to View.....and scroll down to Custom Views. Pick "Team B (orig)" and you'll see what you had in your Sheet B as you uploaded it.
Then--I noticed that you'd hidden a large number of columns in Sheet B, so I created another Custom View....."Team B (full)" which includes all of those columns.
Now, the thing to be aware of here is that these are all simply different views--predefined views--of one and the same spreadsheet. I even changed the column headings for the different (Team A vs Team B) views, by hiding and revealing different header rows.
Taking this as an example, I trust you can see how a single spreadsheet can be used as both input and output....and if your "our team" that uses B IS expected to enter data into all those hidden columns, that capability is also available. This obviates the need for any elaborate formulas or VBA macros to help keep Sheet B in sync with Sheet A. They are simply different (custom) views of the same sheet.
To add to all this, if there are things that you want the people in the field NOT to be able to change, you can use the Protection capability to lock cells such that only you (or some other authorized person) can change them.
If all this is NOT what you're actually trying to accomplish, then I apologize but I need a more complete description of what those out in the field will be doing, what the "internal" folks are doing....why different views of the one sheet wouldn't be viable for that business need.
Thank you, for the input.
Do you know what the VBA Macro code would be to have it perform the insert function i need.
Just a basic ( when i insert a row in worksheet A , then insert a row in worksheet B )
I'm sorry,jessica-tls1 , but I don't use VBA or macros. So if you're insistent on that, I'll have to defer to some of the other experts here who do use VBA.
Did the custom views just not make sense to you as a solution? In retrospect, I realize I neglected to mention in my last post that you'd still need to sort the single spreadsheet on your column containing those Type designations in order to have them sorted as desired, for A1 to go in ahead of AE...but again, that's all very easy to do. And once done, the Custom View for the other users would automatically display that same order.
Especially if you are expecting the people in the field (the users of Sheet B), to be entering and, potentially, changing entries under the columns also visible in Sheet A, having two separate sheets [as opposed to two different views of the same sheet] could lead to inconsistencies between the data on the two sheets. That kind of inconsistency is something to be avoided, in general, in designing a spreadsheet or workbook. So again it depends on how you and the other users are going to be maintaining your two sheets.
I'm going to defer to others for a VBA or macro-based solution, but I want to encourage you to be open to a solution that avoids the potential of data inconsistencies.