Need Help with Macro - copy and paste

[fcorp]

Hello and thank you in advance
I need help with getting columns F and G copy pasted to col A and C to get a new starting point
Attached are my displaced cols

Thanks
Fcorp

[rvasquez]

Hello fcorp,

Are you trying to copy the values of column F & G from Sheet1 and paste them into the first empty row in sheet2 columns A & C? Or are you pasting them into sheet1 columns A & C

Thanks

Rvasquez

[fcorp]

Hello Rvasquez

I am trying to paste into Sheet 1 Columns A & C

Thank you in advance for your help

Fcorp

[galvinpaddy]

Hi, are you simply trying to paste what is in F&G over what is in A&C?
Or will you be continually adding information?
galvinpaddy

[fcorp]

Hi Galvinpaddy
I am trying to copy F&G into A&C. Then create a new F&G by putting information into D&E. This will continue numerous times each time I have a new D&E to add

Thanks in advance for the help

Fcorp

[galvinpaddy]

Ok, thanks for that.
Next question - Will there only ever be 1 line of info to copy & paste at one time?
And, will the info you copy from F&G be replaced each time, or will you keep a record of the info? eg - first time its done, info is pasted into A3&C3, the next time, is the info to be pasted into A3&C3 again, or A4&C4?

[rvasquez]

Hello fcorp,

Couldn't you just set the 2nd row in column A = the previous row column F and 2nd row in column C = the previous row column G?

For Example:

F1 = A1+D1
G1 = C1+E1
A2 = F1
C2= G1

Sorry if I'm not understanding your question correctly.

Thanks!

RVASQUEZ

[fcorp]

Hi RVASQUEZ

I will think about your solution. my actual file is 80 rows of similar type and numerous iterations of D & E is required

I hope I explained it

[fcorp]

Hi Galvinpaddy

There are 80 rows of such data and calculations
I will need to record each time F&G is changed.

Appreciate the help

[galvinpaddy]

ok, in order for anyone to give you an accurate result, you may need to load a sample sheet, showing what cells contain info and where you want the record of data copied to be stored etc.
Its very difficult to guess your project, obviously if you load a sheet please substitute all sensitive info with made up stuff
Either way, try the attached, this is working with one line of info only until i have more details.
It will copy info from the cells in yellow, paste it first (values only) into the record tab, insert a new line (to keep most recent change on top) then go back to Data tab and paste values into A,B,C4.
Is this what you are after? (to start with at least)
galvinpaddy.

[fcorp]

Galvinpaddy

The macro you sent works but as you rightly said its best to load a sheet much similar to what I have. I am attaching the same.
What I currently do is that each time I make a change in K & L I save it as a different file. The changes to K & L each time feed from a different file.
I manually copy data from M & N and put it into I and J and then relink k & L to get my new M & N totals.
If I can run a macro to
1. M & N into a Record area to the right depending on the Data in N2. So the right columns with be
Original Hours Original Dollars Mod 1 Hours Mod 1 Dollars Mod 2 Hours Mod 2 Dollars
and so on
2. Copy M & N into I & J before I start work on my new K & L

I hope I explained it Ok.
Please ask questions if still unclear.
Appreciate all your help

[galvinpaddy]

Hi, thanks for that, now if you could explain a little more for me.
The sheet you have loaded shows what you work with, can you reload it with what you want the results to be? (obviously manually entered info) and i will work on the code for you today.
galvinpaddy

[fcorp]

Hi Galvinpaddy
Thank you!

[fcorp]

Still looking for help on this one, anyone, please!