Hi all. I'm new to the forums so I hope I'm posting this in the right place. (Sorry about the original Title. Hope this one's better...)
I am using a software that has a "dumbed down" version of Excel in it. I can enter formulas but no pivot tables.
Attached is an example of what I'm trying to do. Basically, I want the user to input a number and whatever column of data that number corresponds to in one part of the worksheet will be copied exactly to a different part. I want to do this and avoid a ton of "if" statements.
Thanks for any feedback.
Example.xls
Bookmarks