Search:

Type: Posts; User: Woofy_McWoof_Woof; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    108

    Overwrite data

    Hi there

    I am trying to create a macro/code that will overwrite data each day when a new file arrives

    I have a spreadsheet that has a daily forecast for the next month where each day has 48...
  2. Re: VBA code taking too long to process

    Thank you both for your help, i will take a look at the thread and include the switching off the calculation etc.
  3. Re: Code to move data from one spreadsheet to another

    Perfect, it works. I'll replicate it for the other tabs and hopefully it will reduce the memory size of the file. Thanks very much for your help :)
  4. Re: Code to move data from one spreadsheet to another

    I get a run time error 9 "subscript out of range"
  5. Re: Code to move data from one spreadsheet to another

    Thanks for this, but I'm still getting the run time error. I'm assuming that it could be that the macro is saved in "Book2" rather than "Book1", apologies for not mentioning that. I need to pull the...
  6. Code to move data from one spreadsheet to another

    Hi, I'm trying to move data from one spreadsheet to another (instead of using a copy and paste code which uses too much memory). I'm trying to reduce a 70MB file down to something more manageable and...
  7. VBA code taking too long to process

    Hi, I have a macro that copies data into a separate sheet (after converting a matrix to string for three columns - date, time and value). It works fine apart from the fact it takes too long...
  8. Re: Splitting daily figure into 48 periods

    My word that is impressive, it works a treat.

    PS: sorry for the late reply, I was on my jolly holibobs
  9. Splitting daily figure into 48 periods

    Hi, I have thecode below which splits 24 hourly prices into 48 half hourly periods. Iwould like to do something similar whereby I take a daily figure and split thisinto 48 half hourly periods. I have...
  10. Replies
    2
    Views
    209

    Re: Correlation using lookups

    Thanks a lot, it worked :)
  11. Replies
    2
    Views
    209

    Correlation using lookups

    <tbody>
    A - Month

    B - Date

    C - Period

    D - Price A

    E -Price b
  12. Re: VBA / macro to copy value into two cells

    Sorry for that, it worked though.
  13. Re: VBA / macro to copy value into two cells

    Peter, I have just noticed that the period numbers continue on. These would need to be reset to 1 - 48 for each day. Is that possible?
  14. Re: VBA / macro to copy value into two cells

    Thank you Peter, that worked a treat. Apologies for reposting without reading the rules and guidelines, I shall endeavour to do this in future. :)
  15. VBA / macro to copy value into two cells

    Hi

    I thought I would resubmit this as unfortunately I had no responses. I hope someone maybe able to help as its driving me nuts :)

    I currently have a dataset which displays an hourly price...
  16. VBA code to copy an hourly value into two half hourly values

    Hi

    I currently have a dataset which displays an hourly price each day over multiple years, I then have an index match formula that splits the hourly price into two half hourly prices (same value)....
  17. Re: Macro to replace missing data from adjoining column

    It worked a treat, thanks Fluff :)
  18. Macro to replace missing data from adjoining column

    Hi, I'm working on a spread sheet that has 6 columns - Date, Half Hour, Actual Data and Date Half Hour and Estimated Data. There are occasions when the actual data is missing (blank cell), if this...
  19. Re: Macro for multiplying two matrices

    Hmm, doesn't look like the picture uploaded. Failed straight away :)
  20. Macro for multiplying two matrices

    Hi, first time user long time admirer.

    I'm trying to create some code which will multiply a cell in one matrix by a cell in another matrix. In the example below I would like to create a code...
Results 1 to 20 of 20