hi! i'm creating a workbook to keep track of my utilities payments, one sheet for one utlity and so on. i like to copy two cells from each sheet to another one to keep me updated of the amount to pay and the date. an example: column A with text, if text "NEXT" appear in colum A, copy the value of two cells (at columns B & C) at the right of "NEXT" to another worksheet, if that possible? any help will be appreciated. thanks! below is a photo as an example:
Last edited by manteca; 04-11-2014 at 12:43 PM.
Try this:
Please Login or Register to view this content.
woohoo!!! worked perfectly! thank you very much!
just an issue, after running the macro, a blank new line appears below the copied data removing the formatting of the worksheet in that particular line, any way to avoid it? a photo is included below as reference. thanks!
exa.jpg
Maybe:
Please Login or Register to view this content.
that does it! thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks