There are two sheets (Sheet X, Sheet Y) which have SOME identical headers in their respective tables. As I type in 'Sheet X', I would like the data which has identical headers to automatically go into into new rows for 'Sheet Y'. (So, if I choose to type in row 1, 3, 7, 14 in 'Sheet X', there will be 4 NEW rows in 'Sheet Y' that have automatically filled with data in all the places with similar headers)
Hey there, wanted to help you out with an answer but I sadly can't grasp that question.
You're writing: "As I type in 'Sheet X', I would like the data which has identical headers". Then you follow up with: "I choose to type in row 1, 3, 7, 14 in 'Sheet X', there will be 4 NEW rows in 'Sheet Y' that have automatically filled with data in all the places with similar headers)".
Are those columns? Rows?
It'd be much easier if you could embed a workbook with a example of what we're after? Thanks!
If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
Bishonen: Thanks for writing back. I don't have an easy example to provide, because it is so particular to this example. And unfortunately, the work is someone else's, and we work with a government agency,so it's difficult to share that information.
It's still really important for me to know, so I would still be grateful for the help.
Your Question: I would like for there to be a new ROW created (in Sheet Y), with all the COLUMN information from a particular cell ROW (which I'm typing in from Sheet X).
I'll try to develop an example.
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks