Hello all,
I would like the result line of each sheet to go in a summary sheet. I need my result line from J (RealGain) to column R (DE) to go in my summary sheet. Here is the example and what I want (example-corrected). Example on the picture's. I have 3 sheet : Summary;Sheet2 and Sheet 3 and i want to put the total of my sheet 2 and 3 in the sheet summary. I want to do what with more than 1000 sheet so i want a macro. Maybe to say at the macro "In each sheet, on the line where Result is written, copy me the results from column J to column R and put them in the summary sheet in column B to J" or say "On the last data line of each sheet (such as that of the result), copy me the column J to column R and put them in the summary sheet in column B to J".
Thanks for your help, it's precious
I would like the result line of each sheet to go in a summary sheet. I need my result line from J (RealGain) to column R (DE) to go in my summary sheet. Here is the example and what I want (example-corrected). Example on the picture's. I have 3 sheet : Summary;Sheet2 and Sheet 3 and i want to put the total of my sheet 2 and 3 in the sheet summary. I want to do what with more than 1000 sheet so i want a macro. Maybe to say at the macro "In each sheet, on the line where Result is written, copy me the results from column J to column R and put them in the summary sheet in column B to J" or say "On the last data line of each sheet (such as that of the result), copy me the column J to column R and put them in the summary sheet in column B to J".
Thanks for your help, it's precious