Make data from a cell in one sheet appear in another sheet
I am using Google Drive and want data in one spreadsheet file to appear automatically in another document all together.
If column C of FileA, TabA contains the number 1 anyhere in the cell, then place the contents of that rows column F into column C of FileB, TabA.
Assistance is greatly appreciated.
If column C of FileA, TabA contains the number 1 anyhere in the cell, then place the contents of that rows column F into column C of FileB, TabA.
Assistance is greatly appreciated.
ASKER
Google docs Excel Files are named fileA and fileB and tabs are named respectively tabA and tabB and are online.
ASKER
It is a google drive "online" spreadsheet.
don't know much about google drive but if you build a macro on fileA can you save it there ? I mean when you run the file next time will it have the macro in it ?
The file name can't be FileA it should be something like http:.... how do you open the file ?
gowflow
The file name can't be FileA it should be something like http:.... how do you open the file ?
gowflow
ASKER
The question was about how to do it in Google Drive specifically.
Sorry my knowledge is limited in Google Drive !!!
gowflow
gowflow
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1) Is fileA and FileB preset and always the same positively this can be hardcoded in the macro and avoid more routines. Pls advise and positively provide full path of both.
2) Also TabA of fileA and TabA of fileB same and known provide name.
3) Presume FileA is the file that has the macro ?
Pls advise and based which will construct the macro
gowflow