0

I´m kind of basic Excel user, so perhaps mi question is stupid but I´m really lost. So, I´m looking the way of generate a report in Excel by simply pasting a CSV content in a page inside a SpreadSheet.

The graph uses certain columns to get data and I need a way to select the column, from the first cell after header to last cell with content. I know I can do this manually but the main need here is to automatise the task. Just by pasting the new CSV info, the rest of pages on report (graphs) update automatically.

The real use is for Social Media, Analytics and Email Marketing stats.

Hope somebody can help me.

A visual of what I need to accomplish

pnuts
  • 58,317
  • 11
  • 87
  • 139
DeryckOE
  • 95
  • 3
  • 19

1 Answers1

0

This question was answered extensively on this stack question: Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted) Hope one of the many approaches shown will fit your needs. Cheers,

Community
  • 1
  • 1
nbayly
  • 2,167
  • 2
  • 14
  • 23