Excel VBA Query to Copy, paste and calculate

Hi,

This is my first post! I have been searching these forums for hours without any success, I was wondering if someone could help me with the following query. Basically I have an excel file with a load of data on it (powerstation running profiles broken down by half hourly granuality) I want to produce a summary page:

1. Pull the data from the first tab
2. Calculate the daily values by adding the half hourly values
3. put it on the summary page
4. make it dynamic so it works with any date range.

I appreciate all your help and efforts.

Thanks
Kirpal

Hi Kirpal and welcome to the forum!! :)

Please be sure to read the posting guidelines (http://www.xtremevbtalk.com/faq.php?faq=evbf_faq#faq_evbf_rules).

We don't write entire projects on request but we will be happy to answer any specific questions you have.

Which part of your project are you having difficulty with?

Colin

Hi Colin,

Thanks for the prompt reply. I would like to know how to use a calculate function for a range of cells.

Thanks
Kirpal

Hi Colin,

Thanks for the prompt reply. I would like to know how to use a calculate function for a range of cells.

Thanks
Kirpal

Hi Kirpal,

Okay - I must confess I'm not entirely clear on what you mean....!

Do you mean like how to sum a range of cells with the SUM function?

Please be as specific as possible and we'll try to help! :)

Colin

Hi,

Sorry for the confusion. I want need to produce a macro to complete some tasks, how would I calculate a dynamic range in one worksheet and produce a sum value in a cell in another spreadsheet

Thanks for all your help.

Kirpal

Hi Kirpal,

Determining dynamic ranges with VBA is a very popular question on here.

What criteria do you need to use to determine where the range starts and ends? Looking down a column to the first blank cell? The used range on the worksheet?
Or perhaps your question is leading more towards, "How do I conditionally sum a range of data?"

Maybe you should give us an actual example - something brief and simple, but which will give us the information we need to give you some pointers?

Hi Colin,

Ok I think I may have got it working. I have another question for you not sure if I should ask it here or in another post?

How do I convert a CSV file to XML file?

Thanks,