Reply to forum topic "Automate a keying in Job"

This is a reply to forum topic "Automate a keying in Job":

excelexperts.com/automate-keying-job

 

Download an example file to see the solution.

AttachmentSize
AutomateKeyingInJobExample_v2.1.xls227 KB

Attachment update v2.1

There was an annoying mistake, made from me.

Into Sheet4, the Date's formulas had reference to 'DailyBase-HorizontalExample' sheet instead to 'DailyBase-VerticalExample'.

It has already been corrected.

Attachment update

The attached file is updated.

You Superstar!!

Manny,
Thank you so very much.
I cannot express how much I appreciate you taking the time to fix this problem, but your solution is exactly what I was looking for.

I will populate this tomorrow with all the raw data for the last month, but I can already see that it works.

Since joining ExcelExperts, I have purchased 4 books on Excel mostly J Walkenbach, and I am working through these at the moment (still hitting brick walls from time to time).

If there are any good books you can recommend, I would be very grateful for these as well. (I know practise is even better).

You can rest assured i will direct people to this site as well, I am really really impressed.

Thank you once again.

NoeBol

Nick's picture

work your way through

work your way through these: