+ Reply to Thread
Results 1 to 44 of 44

Copy Paste cells to next sheeet

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: Copy Paste cells to next sheeet

    Thanks Mr. Alan and also sorry for giving you response very late.

    The code provided by you worked perfect.
    4 issues were pending and i could not discuss with you and skip by me as this was mention in my earlier emails. (attached file)

    1). In Business Accounting T-Call Accounts are worked based
    on two columns Debit and Credit side and then Balance from the
    Debit and Credit Column. Becuase some Accounts Bal come on Debit
    side and some on Credit Side as i highlighted above for you.

    2). I need dash instead of 0. if zero come on debit and credit
    side and in the total Balance as below format style.



    3). is this possible aftet running the code ledger sheet update with
    paste link instead of values.

    4). Top Border on Balance Cell data + Border on total Debit , Total credit column data
    Attached Files Attached Files

  2. #2
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copy Paste cells to next sheeet

    Hi Imran
    . I do not understand


    File internet_imranAfter_3

    Sheet 1
    Marketing Fees Credit 300
    ____________ Credit 1100

    Marketing Fees 1.JPG


    ..........................................


    Sheet3
    Marketing Fees Credit 300
    ____________ Debit 1100 ????

    Marketing Fees 2.JPG
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  3. #3
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Copy Paste cells to next sheeet

    _ Hi Imran
    Quote Originally Posted by internet_imran View Post
    ...........
    1). In Business Accounting T-Call Accounts are worked based
    on two columns Debit and Credit side and then Balance from the
    Debit and Credit Column. Becuase some Accounts Bal come on Debit
    side and some on Credit Side as i highlighted above for you.
    _
    _ How do I know which Account should be on which side ??



    _ is this the answer:

    _1 Accounts Payable and Marketing Fees on Balance on Credit side ?

    _2 All others on debit side ?

    _ is 1 and 2 correct ?
    _ Alan
    Last edited by Doc.AElstein; 09-18-2015 at 08:39 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Open another excel file and copy data to sheet 2 while button upload is in sheeet 1
    By rflorentino in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2014, 08:47 PM
  2. copy maths equation from one sheeet to other sheet
    By newmake in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-28-2014, 09:46 AM
  3. Copy & paste in macro doesn't paste all cells
    By pltrapper in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-13-2013, 09:22 AM
  4. [SOLVED] VBA to Copy set data, paste into set cells, then copy more & set into cells related 2 date
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 99
    Last Post: 02-01-2013, 08:43 AM
  5. Replies: 1
    Last Post: 01-16-2013, 05:36 AM
  6. Problem with copy data from "sales" sheet to each customer sheeet
    By jimparker65 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2013, 04:46 AM
  7. Copy and paste non consecutive cells and paste consecutively in another workbook
    By macquhele in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2011, 02:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1