Hi, I have Office 2010. My question is, is it possible to use Excel to create a data base along the following lines.
Say I have data in a couple of columns, lets say column A and B. Can each of that data (two cells side by side) be transported into another spreadsheet (or I guess another page). And each subsequent time I add more data into those two columns it keeps adding onto that transported data in that other spreadsheet.
Then if all this is possible if there was multiple pages of similar data all set up with similar columns A and B, can that also be transported into that other spreadsheet.
This could lead to more questions, but I'll take things one step at a time, not even sure if the above can be done,
Regards, Paul
Say I have data in a couple of columns, lets say column A and B. Can each of that data (two cells side by side) be transported into another spreadsheet (or I guess another page). And each subsequent time I add more data into those two columns it keeps adding onto that transported data in that other spreadsheet.
Then if all this is possible if there was multiple pages of similar data all set up with similar columns A and B, can that also be transported into that other spreadsheet.
This could lead to more questions, but I'll take things one step at a time, not even sure if the above can be done,
Regards, Paul
