updating cell values in one excel sheet with cell values of survey sheet in excel online

[sohaib85]

Well i have created an excel online form .. The users are entering the information in it and it is being saved in excel sheet named as survey1.... Now i want this information to be populated in a master sheet named July 2014 which has many columns including the columns of the survey sheet ...

I am using reference formula to update the columns data like:-

in coulmn E5 in sheet July 2014 i type =survey1!A2 and then copies the formula down below. It works for the information that is already there in survey1 sheet but when the survey1 sheet is updated i.e new information is filled in by the users through the survey form ... the data is not updated in sheet July 2014 instead the formula in the corresponding field where the data was supposed to go is incremented by one at its own.

Like for eg this time the data has to be updated in E6 and the formula written in E6 is =survey1!A3 (i.e with the contents of A3 cell in sheet survey1) but when the user enters data through survey form and the data is filled, in Cell A3 in survey1 sheet ... the formula does not update the Cell E6 in sheet July 2014 with the contents of Cell A3 of Sheet survey1 but the formula is itself incremented as =survey1!A4 ...

How to solve this issue .. any body who can help

[mehmetcik]

Why don't you write a macro to enter the formula into E whenever it is activated?

Then your formula cannot be corrupted.

Your macro needs to be sheet specific. so rright click on the sheet name at the bottom of excel and paste your macro there.

Please Login or Register  to view this content.

[sohaib85]

Because macros cannot be run in excel online and i am trying to shift the data while the spread sheet is shared with users online ...

[sohaib85]

MOreover .. i have also used a macro but it works only offline i.e. with full functionality of excel ...not excel online... .

the macro below copies two cells into two desired cells in another sheet ... can you guide me on the syntax of this macro ?? .. problem is i have to add a new line of code for each cell to copy ..can u tell me the syntax by which i can copy a range of cells using a single line code ???

Sub Button1_Click()
Worksheets("July 2014").Range("E29").Value = Worksheets("survey1").Range("A11")
Worksheets("July 2014").Range("E30").Value = Worksheets("survey1").Range("A12")
End Sub

and also please guide me on the solution... how to copy cells in excel online from survey sheet to July 2014 when the data is filled