Thread: Copy and Paste by VBA

Originally Posted by watersev

hi, dumbago, how do you check if it's working?

Hi, i have opened the file you sent to me and i've created a button and i'v assigned the macro test, but it doesn't work!
I have also copy the text of the macro, and I pasted it in a new macro for my file, but it doesn't work.
I you see the example i gave you, the last one, you have 8 sheets...every sheet is a step..you start with the first one in which i have nothing in the column TODAY (Sheet 0a) and nothing in the last column of the sheet 0b. Then i upload the file and in the sheet 1a there is the column date that is fulled by numbers and in the sheet 1b you have the last column filled (the yellow one). then the last fuor columns of the sheet 1b (excluyded the last one i've just filled in) has to be copied in the little table in the sheet 1a. then do it for every time i upload the file. but i want to have it in 2 sheets, not in sheets like in the file I sent you!

However I have another idea. Let's invert the process:
FIRST copy the last four columns oh the sheet Historical Trend (the 4 columns before the blank one)
SECOND paste the columns copied before in the sheet Summary&Data in the little table, (the 4 columns that are already filled by numbers) excluded the column TODAY
THIRD copy the column TODAY of the sheet Summary&Data
FOURTH paste the column copied before (sheet Summary&Data) in the first blank column of the sheet Historical Trend.


I hope i was able to tell you what i really need.

Many thanks

please check attachment, run code "test"

Please note date in B23 has been changed to a static date without formula for testing purpose.

Originally Posted by watersev

please check attachment, run code "test"

Please note date in B23 has been changed to a static date without formula for testing purpose.

HI watersev..it works: I've changed some cells in the Macro due to my needs, and now it works.
Thank you so much, I really appreciate your help.