Hi. I have a fairy easy question but I cannot get my head around it how to do.
I want to get A column subtracted from B column and get the result in the same B column as well. I want this formula to applies in VBA code for the whole column in the table and ignore the blank cells in A column.
Artik
Please Login or Register to view this content.
Hi, thank you for reply. It looks like it is working in template. Couple function missing, select rows if "A" not empty and clear contents and copy and paste another page
Can you leave comments each line, more understand the VBA code.
Thank you
Last edited by Attila80; 09-02-2021 at 02:40 AM.
Good evening,
I try in original database, sorry but I got an error message
a little different the original database like I share, when I did ask I not think enough I well get formula like this. I need more explain about this VBA code .
Thank you.
Hi Attila80,
Try below code based on the sample file provided in post #1 ... It is missing the sorting as I am not sure which sheet to sort
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks