Merging Data from Multiple Excel Forms to Master Form - Microsoft Community


hi, appreciate assistance on below:

i have excel form has questions in column , answers in column c. these forms saved individually , when saving, create macro pull answers in column c , transfer new master spreadsheet will store answers respective forms.

to more specific, answers in following cells: c16:c35, c37:c45, c48:c49. of answers may blank.

i transfer data master workbook, transposing data starting in cell a2, b2, etc.

then when run macro on second form, (same cells), transfer master workbook in cell a3, b3, etc.

is possible?

hi john,

microsoft programming related concerns best handled microsoft developer network community. answer query excel macros, recommend asking our developers appropriate assistance. visit site , click ask question. if don’t have profile yet, create 1 , accept legal terms checking “i agree”. once you’re done, click continue. after that, can start composing queries , question concern.

let know if have more questions.



Office / Excel / Microsoft Office Programming / Office 2010



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Activation Error 0x8004FE93 - Microsoft Community