CODEWITHSUNDEEP
google-sheets
南無藥師琉璃光如來
南無藥師琉璃光如來

Reputation: 1

How do I get data from differeent sheet / using sheet's name or link(GOOGLE SHEET)

What I knew

is how to link data by

  1. ="SheetName!A2:B2" (same file, Differet Sheets) or
  2. =importrange("Url","sheetName!A2)(Different file)

all these require manual edditing

My Question:

If i have a list of these sheet name, or even it's Url, How can i get dates from other sheets by using these SheetName or Url?

BTW：

i am trying to build a Table Menu for my Inovice system automatically i had a file with 100+ sheet, every sheet has the same form, and i had looked up how to generate Sheetname list with url, but when i try to link (Using SheetNAme or Url as clue) to get the total sell amount/ client name / time, i counld't.

SAMPLE https://docs.google.com/spreadsheets/d/1R67knSxkHD8v6ICIYJtb24pMwV_76HoKLDb-S79lzP4/edit#gid=0

thanks for reading and helping, my english expressing may not be precise ,sorry for that.

Upvotes: 0

Views: 64

Answers (1)

Mike Steelson
Mike Steelson

Reputation: 15308

In G8, try

=indirect(C8&"!C6")

be sure that the layout of each tab is similar (not the case in your spreadsheet) to expand the formula

Upvotes: 0

Related Questions