Results 1 to 3 of 3

Apply the heading like "Amount" for every dataset through VBA code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Apply the heading like "Amount" for every dataset through VBA code

    In the attached file there is VBA code this VBA code working very fine i want just little change in that , that task i
    currently doing manualy , first we understand what this VBA code doing for us, it means what task this code
    perform for us, that is you can see before after sheet in before sheet there is no data in F column, through
    this VBA code we multiply D column with E column and which is result that appear in F column and sum of that appear
    below that , i just want that apply heading "Amount" for every sum which i do manually in after sheet in cell
    F3 and F27 but in cell F56 and F82 there is no heading that cell is blank so apply remaining heading
    in remaining cells which is blank through the VBA code, make it bold , font size 12 , background yellow, thanks
    Attached Files Attached Files
    Last edited by keshavtale; 02-13-2021 at 02:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Conditional Formatting - Apply Cell Style if a column cell is "string1" or "string2"
    By Tunnel_Snakes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2018, 01:27 PM
  3. [SOLVED] VBA Code for the "Amount" to react from "Debit/Credit"
    By dezspert22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2017, 03:42 PM
  4. Macro to "Group" (hide/show toggle) each dataset & marked columns.
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2016, 01:14 PM
  5. Need to apply filter by contain all text as "mathew" in column "D"
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2014, 08:47 AM
  6. Applying a "Left" formula to an entire column with heading "ValueCol"
    By aad401 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2012, 04:14 PM
  7. Sending macro based e-mail with built-in "Heading" and "Text"
    By Prabha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2005, 11:06 AM

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