Specify a certian sheet with Transferspreadsheet action

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to build a macro to import from excel a certain sheet within an
excel file for a specific range

Under the filename if I reference :

S:\PMPC\ManpowerForecastingTracking\Labor Forecast Models\Project Hour
Dollar Tracking\Project Hour Tracking.xls

It will do the cells I want but will default to the first sheet in the file

I want it to pull those same cells, but for sheet named: MONTHLY

not sure of the formatting neccessary
 
Put the sheet name in the Range argument of the macro, followed by a !
or $ (I can never remember which), e.g.
MONTHLY!
 
Back
Top