Xcel Macro
Closed
ravali.koganti
Posts
4
Registration date
Thursday June 19, 2014
Status
Member
Last seen
June 20, 2014
-
Jun 19, 2014 at 11:43 AM
ravali.koganti Posts 4 Registration date Thursday June 19, 2014 Status Member Last seen June 20, 2014 - Jun 20, 2014 at 09:32 AM
ravali.koganti Posts 4 Registration date Thursday June 19, 2014 Status Member Last seen June 20, 2014 - Jun 20, 2014 at 09:32 AM
Related:
- Xcel Macro
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Automatically run a macro when opening a worksheet - Guide
- Run macro when cell value changes - Guide
3 responses
OK, so I opened up Excel, and starting recording a macro.
I ended up with the following:
Rows("1:11").Select
Selection.Copy
Rows("1:1").Select
Selection.Insert Shift:=xlDown
I hope this helps.
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
I ended up with the following:
Rows("1:11").Select
Selection.Copy
Rows("1:1").Select
Selection.Insert Shift:=xlDown
I hope this helps.
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
ravali.koganti
Posts
4
Registration date
Thursday June 19, 2014
Status
Member
Last seen
June 20, 2014
Jun 20, 2014 at 12:12 AM
Jun 20, 2014 at 12:12 AM
Thankyou very much for the macro. It worked perfectly fine for me. I have few more requirements on this. Will you be able to help me further.
1) After I made the selection and copied the 11 rows on top by shifting the cells down, the first column is a date column. I want to change that date to the last day of the previous month on all the 11 rows.
2) TENOR LIBOR TREASURY PRIME LP WFC
1 0.15 0.0355 3.25 0.15 0.30337877
3 0.23 0.0355 3.25 0.15 0.38133851
This is how my data from column 2 looks like in my current excel.
The recent values are present in a other excel. From there I need to find tenor = 1 and update the rest of the values. Similarly find tenor = 2 and update the rest of the values
3) I need to have a formula in the last column to insert all these values into a table so that I can copy the insert and run the insert
I know this is a long request. But I am very basic to excel VBA. Please help.
1) After I made the selection and copied the 11 rows on top by shifting the cells down, the first column is a date column. I want to change that date to the last day of the previous month on all the 11 rows.
2) TENOR LIBOR TREASURY PRIME LP WFC
1 0.15 0.0355 3.25 0.15 0.30337877
3 0.23 0.0355 3.25 0.15 0.38133851
This is how my data from column 2 looks like in my current excel.
The recent values are present in a other excel. From there I need to find tenor = 1 and update the rest of the values. Similarly find tenor = 2 and update the rest of the values
3) I need to have a formula in the last column to insert all these values into a table so that I can copy the insert and run the insert
I know this is a long request. But I am very basic to excel VBA. Please help.
ravali.koganti
Posts
4
Registration date
Thursday June 19, 2014
Status
Member
Last seen
June 20, 2014
Jun 20, 2014 at 09:32 AM
Jun 20, 2014 at 09:32 AM
And you dont have to work on request 3). Its taken care of.
ravali.koganti
Posts
4
Registration date
Thursday June 19, 2014
Status
Member
Last seen
June 20, 2014
Jun 20, 2014 at 09:30 AM
Jun 20, 2014 at 09:30 AM
Last day of previous month date in cell A2-A12
