Good afternoon. I need this to be displayed in a list viewer. When I press the 'Clients' button, I want it to call the information from sheetname and display it in the viewer. When I press 'Suppliers', the viewer should display the information from **sheetname1.
All of this is on the same screen, which is why I use 'call sheet' when initializing that screen. There are three sheets on the same spreadsheet.
I'm here, and the idea is to have a List Viewer so that when I press the Clients button it calls one sheet, and when I press the Suppliers button it calls the other.
I'll do some guessing, until some one who can read the blocks comes along.
LeerColumna is what, read column?
But I see you are doing it for just column A of three separate sheets.
That makes me worry about how you are keeping your data on the sheets.
Could you list the columns in each sheet, and how they relate to one another?
This tutorial gives examples of how multiple sheets can be set up with cross-references.
Do not fall into the trap of setting up your back end data storage to fit into a shredder (parallel ListViews)
When you use spreadsheets you must be familiar with the concept of tables, where each table (sheet) has one row per item, with the columns of each row holding attributes of that item.