Clues to Entering Repeating Data in Excel by Date

Someone else will probably help with an example. Here are a few quick suggestions.

1) Google various combinations of "Excel", "macro", "VBA", and "copy cells". You will probably find something useful pretty quickly. As I recall copying from sheet to sheet does not usually show up in the first few Google hits. Keep searching and you will find them.

2) Excel has a feature called "Macro Recorder". It will "write" or "record" for you the VBA (Visual Basic for Applications) code that matches what you do with your mouse. You can both learn a lot and create useful macros with it.

I can't tell if you are asking for a way to automatically have the code run at a specified time each day. If you are then that requirement is above me in Windows. Linux has "cron" and it is an easy way to automatically run things. In Windows I think you have "services" and I never learned how to set them up.

Re: timed operations, in XP "Control Panel -> Scheduled Tasks" does the job. No idea about Vista or 7.

Re: the Excel problem - I'm not clear about what's needed.

I've sent you a PM with my email... if you want to send a sample of your sheet, I'll write you a macro... I'm using Excel 2003... but it should still work with newer versions.

Chris

I'll clarify what's going on. This company I'm working for, there is an Excel spreadsheet which is used, among many. There are 2 specific values I need to collect each day. One is a dollar amount, one a quantity. These two numbers are in one cell each, lets say row 1, column 1 for the $s and row 1, column 2 for the quantity.

These values update each day. So for Sept 1, we might have $1000 and 5, and then tomorrow, this could be $1500 and 15.

So, I need to collect these each day. I need to, for example catch Sept 1 info in row 1, columns 1 and 2 in my spreadsheet, Sept 2 in row 2, columns 1 and 2, and so on.

Because I have a lot of other numbers to deal with, and other numbers to calculate based in part on these 2 numbers, and many other, I would like to automate this colection of numbers. I have most of my other collection worked out. Since these two are updated in the same cells each day, this makes it a little harder.

Chris, I'll reply when I get caught up with some things. I thank all of you for your responses. C.C.

what you are describing is not difficult in vba... and I can and have done many of that type of thing... but it is important to know the full context in order to give a full answer, and provide full value for you.. so that is why I asked for the sample sheets...

cheers,

Chris