Posts by Nagin

Hi,

I have got a macro to refresh all pivot tables and have this macro on several workbooks, however for some reason now, this macro works on some of the workbooks and for the others I get a 400 error message, I have attached the code below;

Dim xWs As WorksheetDim xTable As PivotTable
For Each xWs In Application.ActiveWorkbook.Worksheets
    For Each xTable In xWs.PivotTables
        xTable.RefreshTable
    Next
Next
End Sub

Thanks

Re: OFFSET formula to ignore cell with a blank formula

Hi,

That didnt seem to work, I have attached a sample worksheet, with the named range, the named range is selecting everything until the last formula and not just the first line.

Thanks

Re: OFFSET formula to ignore cell with a blank formula

Hi Ali,

This did not work, I am trying to create a dynamic named range, my first row of data is from B9:F9, I would like to select the range until there is a blank return on the formula in column B.

Hi,

I have the following formula =OFFSET(Input!$B$8,1,0,COUNTA(Input!$B:$B)-1,5), column B has a formula which returns a blank based on another cell. I am trying to offset the range so it does not include the blank formula rows.

Thanks

Re: User form with multiple row lines

Hi Roy,

I have attached my initial layout of the form, I have not yet coded any of the buttons yet. I wanted first see if it was possible to get data to export on multiple lines.

Thanks

Hi,

I am trying to develop a user-form that I can add and update to multiple row lines. On sheet 1, I have the following information; the user would enter the date and enter the patient details,

[TABLE="class: cms_table, width: 299"]

Date

[TD="align: right"]13/07/2017[/TD]

Patient 1

Outcome 1

Outcome 2

Reason 1

Patient 2

Outcome 1

Outcome 2

Reason 1

Patient 3

Outcome 1

Outcome 2

Reason 1

Patient 4

Outcome 1

Outcome 2

Reason 1

Patient 5

Outcome 1

Outcome 2

Reason 1

[/TABLE]

I would then like this to be entered onto sheet 2 on multiple lines;

[TABLE="class: cms_table, width: 394"]

13/07/2017

Patient1

Outcome1

Outcome2

Reason1

13/07/2017

Patient2

Outcome1

Outcome2

Reason1

13/07/2017

Patient3

Outcome1

Outcome2

Reason1

13/07/2017

Patient4

Outcome1

Outcome2

Reason1

13/07/2017

Patient5

Outcome1

Outcome2

Reason1

[/TABLE]

Any help on this would be much appreciated.

Thanks