Reference Change Recurring Entries

[LewisJ]

Hello,

Can the code for RecurringEntries be altered to refer to the 'Recurring'! worksheet instead of the range J to S columns on the 'Entries'! sheet? I should have thought of them being on a separate sheet originally.

Thank you very much for your help,
Joe

[p24leclerc]

As your RecurringEntries is a named range referring to a range in the Entries tab (column J to S),
you just have to change this to reference your Recurring tab instead.
You'll have to change this line of code

Please Login or Register  to view this content.

by this one.

Please Login or Register  to view this content.

[LewisJ]

That's all ? Aren't there any references to the 'Entries' sheet that have to be changed to 'Recurring' sheet?

[LewisJ]

Shouldn't it change to :

Please Login or Register  to view this content.

[p24leclerc]

No. Named ranges are not sheet dependant.
I didn't go through all the code but it seems to be all you have to change.
A test with expected results will give the answer.

[LewisJ]

No. Named ranges are not sheet dependant.
I didn't go through all the code but it seems to be all you have to change.
A test with expected results will give the answer.

I made a few entries due tomorrow and will see thank you.

[LewisJ]

The code is changing the dates on the Recurring table instead of posting the row that's due to the Entries. Any ideas on why ?

[p24leclerc]

isn't it the place you want it to be up to date?
The entry is transfered to the Entries tab, isn't it?
I don't understand why you have the Recurring Expense or Income table at 2 places.
You should maintain this table at one place only and I think it should be in the Recurring tab.

[LewisJ]

The entries are updated on recurring when today's date comes into play. But the entry is not being made on the Entries sheet. Sorry the place on the Entries sheet for recurring will be deleted.

[LewisJ]

Thank you for helping me I figured out another way.

[p24leclerc]

in fact, the entry is being made on the Entries sheet but lower in your table.
Look at the bottom of your table and you will see it.

I don't know why exactly but your line of code that locate the last row in the Entries sheet is not working properly.
It seems like you have something in row 51 and the code stops there.
I think it might be because this is TABLE.

Please Login or Register  to view this content.

I doubled the End(xlUp) and it works.

Please Login or Register  to view this content.

[LewisJ]

Thank you again for the help. It is working great!