excal vba

  1. Z

    Insert Total and Sum After Each group of data

    Please Help, I need help inserting Text that would say "Total" under each product group and Auto Sum for each group of data in the next column Thanks <COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY> Apple 3 Apple Apple 4 Apple Apple Total 7 Orange...
  2. T

    Excel Macros

    I am having excel sheet with huge data. I want the vb macros to take out the unique count of Column 'Computer Name' by filtering the column 'Location'. Like: <tbody> Row1 <colgroup><col width="125"></colgroup><tbody> Computer Name </tbody> <colgroup><col...
  3. C

    Range Select/Transpose Macro

    I want to make a macro/VBA script that will search a single column for separators (dashes), select the rows between the dashes and transpose that data into another worksheet. There are several hundred "records" laid out this way. Ideally, I'd like the macro to find/select the next range and...
  4. W

    Looping & Writing Through Variable Rows & Columns

    Hi Everyone, My first post here, but not the last - I've recently (through work) started getting involved in some excel VBA work, I've had some experience with VBA at uni but not much, more so with Fortran. So I understand generally how things work, but am struggling with syntax. Anyway, what...
  5. S

    Macro for checking if a value exists in a different workbook and adding it if it is missing

    Hi there. I would like to have a macro designed. I have 2 workbooks, one having latest information and the other having the information in database already. both workbooks have 26 columns each. I would like to check if a value that exists in Column A of the "latest-information" workbook also...
  6. J

    VBA Replace "-"

    I need to find a way to find and repalce using VBA so that 00904-0201-61 converts to 904020161 or 12345-6789-11 converts to to 12345678911 by removing the - between then numbers. ActiveSheet.Columns("C").NumberFormat = "@" or ActiveSheet.Columns("C").NumberFormat = "00000-0000-00"</SPAN> do...
  7. M

    Excel 2003 VBA no longer referencing

    I created a couple of functions in a separate module called "Functions" and one for Subprocedures named likewise, both located in the Personal workbook. I had a function called "ConvertCalDate" defined as a date. It worked perfectly fine and I was able to reference it in any of my workbooks...
  8. S

    Priting a certain cell out to the screen

    Thank you ahead of time if you can help me with this. I have information in column 12 that has conditional formatting that turns the text read if certain requirments are not met. I've been trying to write code that goes thru column 12 to see which are in red and then returns the information in...
  9. R

    How to call VBScript from excel macro's

    HI, I need some excel vba examples, where with in the VBA code(Excel Macro) i could call a VBScript and will get some values like filename and directory information from the vbscript and assign it to the variables in VBA code. The basic requirement here is, I need to assign dynamic...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top