Getting Excel to Pick and Choose Data based on whether or not a value exists in the cell.

[xxsweetwinexx]

Hey Guys, -- New to the forum, please forgive me if I do anything wrong. -- I need help getting excel to move data from one worksheet to another. The basis of this project is that a Schedule/Worksheet 1 (and I mean a real work/time schedule with just shifts [ie: 9-6p, 10-2p] placed in cells) will then be placed on a separate sheet that shows just one day at a glance. -- I need excel to recognize whether or not there is a shift on worksheet one, and then if there is, place the data into another worksheet, based on where the data is within the original worksheet. [IMG

---

][/IMG] This would be worksheet one, where the schedule is built. All information is hand keyed and would change each week. -- I need excel to recognize where there is a value (in this example B10 & B13)

[/URL][/IMG] And then, import that data on the second worksheet in the appropriate column. -- I'd also need the name to populate with the corresponding values... -- If that doesn't make sense, please feel free to yell at me and simultaneously forgive me for incorrect excel jargon.

 

[NeonRedSharpie]

So I don't get to yell at you yet. Do you want a formula or a visual basic solution? It sounds like a visual basic macro.

 

[xxsweetwinexx]

Would it be possible to do with a formula? Or does it have to be macro... I'm worried about how well it will then work across the board, as there may be different versions of excel being used.

 

[NeonRedSharpie]

In order to auto populate names it probably needs to be a macro. Unless you want to manually populate the names. VBA is pretty robust and should work across the 4 most recent versions (13, 10, 07, 03) pretty well. There might be nuances, but coding it with that in mind should solve them. It just depends how you want it all to work.

 

[xxsweetwinexx]

Alright. THEN, can you point me to the right direction on how to make that happen. I don't expect to get an answer for how to do it, as much as I'd just like reading material to help me get there. -- What I've found most frustrating during this, is the fact that I don't know the appropriate jargon to get me to the materials necessary. So, what would you call this to get to the correct reference material on google? Haha. So blonde right now, it hurts.

 

[NeonRedSharpie]

Well, I don't much know where to point. Usually I would recommend pressing "record macro" and then doing whatever it is you want to do. Then, after that, going into the code to understand how it works. I can help you write the code as it seems a pretty straight forward loop. I'm just not entirely sure of your final layout. Is B:B it's own sheet? Or is it it's own column? Where does D:D go or do we not care about that?