read column row by row and reference to different sheet

I am trying to write a code that looks down a column on one sheet and uses the cell value to reference a different sheet. Then take the adjacent cell value on the new sheet and place in power point. here is some of the code I have worked on. I have also attatched the workbook that it will be running in. Andrew coding practicemacro.xlsm

Please Login or Register  to view this content.

an example would be using the code com1 from the responses sheet and then finding it on the questions sheet. Once found taking the cell from column g of the same row and placing it in powerpoint. is that more clear?

what variable are you using as the question string?

everything is perfect but i cant get it to grab the question information. I get a output of either the cell location or the cell value like def2 com3. how do i take that piece of information and get it to grab the whole question. it is in sheet question-all column G.

i just get the same output when it runs. looks like it runs through all the questions and doesnt pick just one and then step through the next ones. it always puts out the same answer.

could this becaused by the fact that i am pulling graphs at the same time?

Please Login or Register  to view this content.

Thank you for your patience.

the macro is used to calculate survey data. the question is asked and the responses are given (1-5)

on the first sheet the responses are imputed.

the macro then takes the data creates graphs and moves those graphs and the original question to a powerpoint for presentation purposes. so the question and the graph is on the same slide of the powerpoint.

so the first sheet has the info of what question was asked and the responses each "person" gave.

Qest = Qest & C.Offset(, 4).Value & vbcr is close now it takes all the quesitons in sheet1 column 1

all of the questions will have a question number eventually. so question 1-33 will have a question number. but the number of questions will change.

i think you are right if i have one loop this will be easier. ill post back what i come up with