Excel & Sharepoint

[samunders]

Hello All,

I wonder if someone can help me with an Issue with macros on Sharepoint.

before being migrated to share point we had a shared Excel sheet where there were macro buttons that copies text from one cell and pasted it on the the sheets where the button one in the active cell.

i understand that macros don't work in Excel online but there is the Power Automate ability.

The old macro was:

Sub APR6TH()
'
' Macro1 Macro
'
    Sheets("data").Select
    Range("f1").Select
    Selection.Copy
    Sheets("APR").Select
     ActiveSheet.Paste

End Sub

I want to write several scripts that do the same job but I can't seem to get them to paste in the "active cell" they see to always default to the same cell.

function main(workbook: ExcelScript.Workbook) {
  let selectedSheet = workbook.getActiveWorksheet();
  let data = workbook.getWorksheet("Data");
  selectedSheet.getRange("c5").copyFrom(data.getRange("A1"), ExcelScript.RangeCopyType.values, false, false);
}

the issues is with the selectedsheets.getrange("c5")

what do I replace that with?

I'm very new to this sharepoint business so any help is great