Hello,
You can use INDIRECT function, something like
INDIRECT(CONCATENATE(A4;"!$A:$A"))
instead of
KESORAMIND!$A:$A
then name of sheet in formula will be used from cell in column A.
Best regards,
Martin Gasparovic
On Aug 18, 12:36 pm, Subu S wrote:
> Dear Members
>
> I have a spread sheet with
Hello,
in Excel 2007 you can define page header rows and page break after
subtotal
1. Page header rows
Page Layout->Print Titles->Page Setup dialog window tab "Sheet",
and select rows in field "Rows to repeat at top:
2. subtotal page break
its the dialog window for subtotals
Data->Subtotal and in
Hello,
can you attach/send your excel file ? (with anonymised data if
possible)
I had been trying your code and it's working.
Best regards,
Martin Gasparovic
On Aug 17, 11:05 pm, Dave wrote:
> I am trying to populate cells with a certain addresss from a
> spreadsheet called Let1 to another sp
Hello,
there is lot of lost/forgot cells around table, and lot of formatted
cells in column N .
Just select cells in the table and copy/paste them to another sheet
(by mouse).
Best regards,
Martin Gasparovic
On Aug 17, 1:35 pm, Aligahk06 wrote:
> Dear All,
>
> Attached file is for reference.
>