Excel help needed

[chandr]

main 2 rows ko kaise 1 row banao aur us main net amount bhi ajaye. samajne k liye picture attach ka raha hun.

[Tanveer99]

sorry... aap ki problem ki samaj nae aaye.

[kashifundlas]

main 2 rows ko kaise 1 row banao aur us main net amount bhi ajaye. samajne k liye picture attach ka raha hun.

visit plz.......

http://www.extendoffice.com/product/...umns-rows.html

[chandr]

sorry... aap ki problem ki samaj nae aaye.

matlab yeh k meri pic ki row 6 aur 7 combine ho jaye aur is ka sum 3500 aye

[imranjhang]

Agar ap ki sheet isi pattern ki hai matlab 3 columns by 2 rows then:

1. Press Alt+F11 to Open Visual Basic for Applications.
2. Insert-->Module
3. Paste this code into that Module

Sub Merge()
    Selection.Range("C1").Value = Selection.Range("C1").Value + Selection.Range("C2").Value
    Selection.Range("A2:C2").ClearContents
    Selection.Range("A2").Select
End Sub

4. Press Alt+Q to return to Excel Worksheet.
5. Press Alt+F8 to open Macro Dialog Box.
6. Click Options and set you hotkey like... Ctrl+m
7. Click OK and then Press [Esc].

ab jab bhi rows ko merge karna ho un cells ko select karain jaisay ap k screenshot main "B6 : D7" ki range hai. phir Ctrl+m press karain and you are done.

[chandr]

Agar ap ki sheet isi pattern ki hai matlab 3 columns by 2 rows then:

1. Press Alt+F11 to Open Visual Basic for Applications.
2. Insert-->Module
3. Paste this code into that Module

Sub Merge()
    Selection.Range("C1").Value = Selection.Range("C1").Value + Selection.Range("C2").Value
    Selection.Range("A2:C2").ClearContents
    Selection.Range("A2").Select
End Sub

4. Press Alt+Q to return to Excel Worksheet.
5. Press Alt+F8 to open Macro Dialog Box.
6. Click Options and set you hotkey like... Ctrl+m
7. Click OK and then Press [Esc].

ab jab bhi rows ko merge karna ho un cells ko select karain jaisay ap k screenshot main "B6 : D7" ki range hai. phir Ctrl+m press karain and you are done.

thank you problem solved.