VBA or Formula on IF function to copy data to another Workbook

[Vitrublue]

Hi,

I am reasonably proficient in excel but VBA is not something I have invested time in and am therefore seeking help for the problem I have.

I have 10 workbook trackers hosted on google drive that my team all enter in to for capacity management purposes.

I would like to introduce a tick box option for each line and should that be 'ticked' then that line of data is copied to another workbook within google drive. Does VBA work when the files are hosted on google drive?

Can this request be done via formual also, I am scratching my head on this one.

Each new line selected would then need to occupy the next available line in the new sheet.

I would appreciate any help provided

GREG

 

[Special-K99]

Formulas cannot change the values of other cells... in any workbook anywhere.
You'll need VBA for this.