Re: Vba that get data from sheet that precede the active sheet
There is something else going on with your VBA ... send me your file with either script installed so that I can see what you are missing.
FYI ... both scripts are activated when you create a new tab using the icon to the right of the tabs at the bottom of the worksheet.
P.S. I like jindon's code line ... it is more efficient and reduces my script by a line or two