Excel using date range and formula on separate sheetsClosed

Question

I'm creating a bank register with the dates in column A.
Values are in columns C and D.
The title of my first page is 'Register'

What I'm trying to do is get just the data in the January dates to be used on the second sheet of my workbook, and February for the third and so on. 
I'd like to just pull the dates automatically without having to manually put the range of those dates in (ie: A2:A45) 

How do I start the formulas on the other pages of my workbook using specifically the date ranges in Column A of the first sheet?

Thank you all in advance!

vcoolio · Answer

Hello Action,

There is a recent thread further down which may interest you:-

https://ccm.net/forum/affich-784056-need-to-write-a-macro-to-copy-a-row-of-information-if-true

There is a link in the thread to a test workbook that I used for the Poster which you may like to test for yourself just to see if its similar to what you may need. That exercise was based on transferring data based on dates from a master sheet to various other sheets. 

See what you think and let us know. I'm sure that we could adjust it to suit your scenario.

Kind regards,
vcoolio.

Excel using date range and formula on separate sheets

1 reply

Subscribe To Our Newsletter!