ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy / Past problem. (https://www.excelbanter.com/excel-programming/411984-copy-past-problem.html)

[email protected]

Copy / Past problem.
 
Hi,
I prepared Inventory Report through some formulas.
the last column of my inventory report is "F" column for the closing
balance. there is a formula in F column, =C15+D15-E15 in entire
column. from F9 till F48.

(I know special past for the values.) ALT E+S+V

I want to convert all the amount into values in Column "K9"
I need a macro who convert all the F column values in to K column, and
when I run the same macro it will copy all the values in "L" column
and when I run the same macro it will copy into "M" column and so
on.......

Because I want to keep all these values in histry all the Closing
Balance for all Months to view it later on.

hope you understand...


column "F"
====================
Closing Balance (MAY 08)
====================
4,357.66
8,320.46
8,097.88
2,835.97
27,708.10
2,007.47
11,067.17
57,558.05
-
2,579.00
-
-
1,387.28
123,010.95
26,018.83
-
3,293.80

If this procedure is possible. pls send suggessions.

best Regards

Syed Shahzad
Madinah

Don Guillett

Copy / Past problem.
 
Assumes something in range("j1") to start with
Copies all of column F to col K, then col L, etc

Sub copytolastcolplus1()
lc = Cells(1, Columns.Count).End(xlToLeft).Column + 1
Columns(lc).Value = Columns("f").Value
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Hi,
I prepared Inventory Report through some formulas.
the last column of my inventory report is "F" column for the closing
balance. there is a formula in F column, =C15+D15-E15 in entire
column. from F9 till F48.

(I know special past for the values.) ALT E+S+V

I want to convert all the amount into values in Column "K9"
I need a macro who convert all the F column values in to K column, and
when I run the same macro it will copy all the values in "L" column
and when I run the same macro it will copy into "M" column and so
on.......

Because I want to keep all these values in histry all the Closing
Balance for all Months to view it later on.

hope you understand...


column "F"
====================
Closing Balance (MAY 08)
====================
4,357.66
8,320.46
8,097.88
2,835.97
27,708.10
2,007.47
11,067.17
57,558.05
-
2,579.00
-
-
1,387.28
123,010.95
26,018.83
-
3,293.80

If this procedure is possible. pls send suggessions.

best Regards

Syed Shahzad
Madinah



[email protected]

Copy / Past problem.
 
On Jun 3, 7:00*pm, "Don Guillett" wrote:
Assumes something in range("j1") to start with
Copies all of column F to col K, then col L, etc

Sub copytolastcolplus1()
lc = Cells(1, Columns.Count).End(xlToLeft).Column + 1
Columns(lc).Value = Columns("f").Value
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...



Hi,
I prepared Inventory Report through some formulas.
the last column of my inventory report is "F" column for the closing
balance. there is a formula in F column, * =C15+D15-E15 in entire
column. *from F9 till F48.


(I know special past for the values.) * ALT E+S+V


I want to convert all the amount into values in Column "K9"
I need a macro who convert all the F column values in to K column, and
when I run the same macro it will copy all the values in "L" column
and when I run the same macro it will copy into "M" column and so
on.......


Because I want to keep all these values in histry all the Closing
Balance for all Months to view it later on.


hope you understand...


* column "F"
====================
Closing Balance (MAY 08)
====================
4,357.66
8,320.46
8,097.88
2,835.97
27,708.10
2,007.47
11,067.17
57,558.05
-
2,579.00
-
-
1,387.28
123,010.95
26,018.83
-
3,293.80


If this procedure is possible. pls send suggessions.


best Regards


Syed Shahzad
Madinah- Hide quoted text -


- Show quoted text -


Hi,

I used the above code, but it is giving Error. "Variable is not
defined"

how to fix this.

regards

shahzad

Don Guillett

Copy / Past problem.
 
Sub copytolastcolplus1()
Dim lc As Long
lc = Cells(1, Columns.Count).End(xlToLeft).Column + 1
Columns(lc).Value = Columns("f").Value
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
On Jun 3, 7:00 pm, "Don Guillett" wrote:
Assumes something in range("j1") to start with
Copies all of column F to col K, then col L, etc

Sub copytolastcolplus1()
lc = Cells(1, Columns.Count).End(xlToLeft).Column + 1
Columns(lc).Value = Columns("f").Value
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...



Hi,
I prepared Inventory Report through some formulas.
the last column of my inventory report is "F" column for the closing
balance. there is a formula in F column, =C15+D15-E15 in entire
column. from F9 till F48.


(I know special past for the values.) ALT E+S+V


I want to convert all the amount into values in Column "K9"
I need a macro who convert all the F column values in to K column, and
when I run the same macro it will copy all the values in "L" column
and when I run the same macro it will copy into "M" column and so
on.......


Because I want to keep all these values in histry all the Closing
Balance for all Months to view it later on.


hope you understand...


column "F"
====================
Closing Balance (MAY 08)
====================
4,357.66
8,320.46
8,097.88
2,835.97
27,708.10
2,007.47
11,067.17
57,558.05
-
2,579.00
-
-
1,387.28
123,010.95
26,018.83
-
3,293.80


If this procedure is possible. pls send suggessions.


best Regards


Syed Shahzad
Madinah- Hide quoted text -


- Show quoted text -


Hi,

I used the above code, but it is giving Error. "Variable is not
defined"

how to fix this.

regards

shahzad


[email protected]

Copy / Past problem.
 
On Jun 4, 3:16*pm, "Don Guillett" wrote:
Sub copytolastcolplus1()
Dim lc As Long
lc = Cells(1, Columns.Count).End(xlToLeft).Column + 1
Columns(lc).Value = Columns("f").Value
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...
On Jun 3, 7:00 pm, "Don Guillett" wrote:





Assumes something in range("j1") to start with
Copies all of column F to col K, then col L, etc


Sub copytolastcolplus1()
lc = Cells(1, Columns.Count).End(xlToLeft).Column + 1
Columns(lc).Value = Columns("f").Value
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message


...


Hi,
I prepared Inventory Report through some formulas.
the last column of my inventory report is "F" column for the closing
balance. there is a formula in F column, =C15+D15-E15 in entire
column. from F9 till F48.


(I know special past for the values.) ALT E+S+V


I want to convert all the amount into values in Column "K9"
I need a macro who convert all the F column values in to K column, and
when I run the same macro it will copy all the values in "L" column
and when I run the same macro it will copy into "M" column and so
on.......


Because I want to keep all these values in histry all the Closing
Balance for all Months to view it later on.


hope you understand...


column "F"
====================
Closing Balance (MAY 08)
====================
4,357.66
8,320.46
8,097.88
2,835.97
27,708.10
2,007.47
11,067.17
57,558.05
-
2,579.00
-
-
1,387.28
123,010.95
26,018.83
-
3,293.80


If this procedure is possible. pls send suggessions.


best Regards


Syed Shahzad
Madinah- Hide quoted text -


- Show quoted text -


Hi,

I used the above code, but it is giving Error. *"Variable is not
defined"

how to fix this.

regards

shahzad- Hide quoted text -

- Show quoted text -


Hi Don,

I checked your code, it is working perfectly. Thank you for your
support.
Exactly I need the same code. thanks again.

Best Regards.

Syed Shahzad Zafar
Madinah

Don Guillett

Copy / Past problem.
 
Glad to help. Pls TOP post

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
On Jun 4, 3:16 pm, "Don Guillett" wrote:
Sub copytolastcolplus1()
Dim lc As Long
lc = Cells(1, Columns.Count).End(xlToLeft).Column + 1
Columns(lc).Value = Columns("f").Value
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...
On Jun 3, 7:00 pm, "Don Guillett" wrote:





Assumes something in range("j1") to start with
Copies all of column F to col K, then col L, etc


Sub copytolastcolplus1()
lc = Cells(1, Columns.Count).End(xlToLeft).Column + 1
Columns(lc).Value = Columns("f").Value
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message


...


Hi,
I prepared Inventory Report through some formulas.
the last column of my inventory report is "F" column for the closing
balance. there is a formula in F column, =C15+D15-E15 in entire
column. from F9 till F48.


(I know special past for the values.) ALT E+S+V


I want to convert all the amount into values in Column "K9"
I need a macro who convert all the F column values in to K column, and
when I run the same macro it will copy all the values in "L" column
and when I run the same macro it will copy into "M" column and so
on.......


Because I want to keep all these values in histry all the Closing
Balance for all Months to view it later on.


hope you understand...


column "F"
====================
Closing Balance (MAY 08)
====================
4,357.66
8,320.46
8,097.88
2,835.97
27,708.10
2,007.47
11,067.17
57,558.05
-
2,579.00
-
-
1,387.28
123,010.95
26,018.83
-
3,293.80


If this procedure is possible. pls send suggessions.


best Regards


Syed Shahzad
Madinah- Hide quoted text -


- Show quoted text -


Hi,

I used the above code, but it is giving Error. "Variable is not
defined"

how to fix this.

regards

shahzad- Hide quoted text -

- Show quoted text -


Hi Don,

I checked your code, it is working perfectly. Thank you for your
support.
Exactly I need the same code. thanks again.

Best Regards.

Syed Shahzad Zafar
Madinah



All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com