Hello,

I have an excel workbook with 5 sheets. Each sheet is an issues log for different subjects. So the columns are (A) Month issue raised, (B) Raised By, (C) Head of Duty system, (D) Issue, (E) Updates, (F) Current position.

I also have an exact copy created in Google sheets which I can easily share with my team. (Hopefully this will no longer be necessary when our employer finally upgrades the office suite to Office 365)

I've created a HUB in excel which is just a number of boxes which you click on them and they provide you with information, open services etc.

All of the button_click macro's in the hub are relatively simple and open documents from a central server so everyone with permissions can see them when they click the button.

I want to know if it would be possible to import data from the tracker in GOOGLE SHEETS on the Google Drive.

All staff have access to Google Drive and it makes sharing documents extremely easy.

Is it possible to have a button_click macro for each of the 5 sheets in the workbook (Google Sheets workbook) and import the CURRENT Months data only, into a blank excel spreadsheet which would pop up when clicking the button?

If it's not possible to do this from the GOOGLE SHEETS workbook I assume it will be possible from the Excel one?

If it is possible to get the data from the GOOGLE sheets can anyone provide assistance in creating the macro?

Many Thanks in advance for the help and advice.