excel automation

  1. P

    Automatic Lo Shu Grid Generator

    Hi All, Can you please help me to create an automated Loshu grid in XL using Date of birth ? . Looking forward to your help. Thanks PP
  2. V

    Deleting Records that match certain values

    I have a worksheet that gets over 80,000 rows daily, must of it needs to be filtered and ends with around 100 to 300 rows only. Sorting the unwanted values and deleting rows manually is a pain and it takes me from 2 to 3 hours so I started doing with VBA using a code I found on this forum which...
  3. D

    Office Script to open new worksheet and name with current date

    I have tried to use the following script from an old message on this board in Office 365 to open a new worksheet and name it with the current date. This code only opens a new sheet with the name "Sheetx" (x is increasing numbers). I would also like to be able to open the new sheet from a...
  4. S

    Comparison between two data tables

    Hi I need a vba code which could compare 2 worksheets which has data in different sort order The data tables have no primary key and I need help in identifying how this can be compared to identify differences by reducing manual effort Once the data is compared between 2 worksheets, the code...
  5. S

    List all Open Workbooks in Combobox

    Hi I am trying to create a userform in a MASTER workbook where I want help in listing all Open workbooks including CSV files listed in a Userform combo box. This combobox should include all open workbooks including the ones which are not saved in the local drive. The master WB should be...
  6. K

    All Excel sheets combine into one sheet

    Hi Mate, I have 10 individual excel sheets with data & I need all the 10 different sheets data into one excel sheet and need to trigger the mail
  7. Y

    Excel - Word automation - Print out

    We at work have quite unique problem. We have 12 word docs out of which few ( basis requirements)need to be printed for every job. Can anyone help to create excel sheet / or guide so that those word documents can be printed from excel itself and each having unique sequential number and date...
  8. B

    Script to email specific workbooks to corresponding email addresses

    Hi all, I have multiple workbooks that are created weekly which needs to be sent out to the corresponding parties. This is very time consuming and sometimes workbooks are missed in the process. There are about 100 workbooks. The workbook contains the name of the supplier and then a date is...
  9. T

    Macros for Copying Data of Cell even after increasing Number of rows and applying filter

    Hey,I have a sheet of Engineers Name with allocated complaint numbers and their mobile number. i want to create a Macros script so that every time i apply filter on a particular engineer and press a Macros Created Keyboard short cut it copies engineer mobile number. Engineer Mobile Number...
  10. A

    for text to column conversion using vbs code needed

    Hi All, Need vba code to convert 'Mod' sheet from text to column in 'Row Data' sheet by click of 'Text to Column' button. The data selected in 'Mod' sheet should be converted to column done manually by clicking 'Text to Column' -> 'Delimited' -> 'Space' Sheet attached...
  11. S

    Excel Automation weird behavior while launching under diffrent account...

    Hi, I wonder if there are any Excel automation Experts who can help explain and solve the following: we've been using Excel 2010 on a workstation and a Server ok. It's being run under some superuser domain account. (\\mydomain\mylovelySyperUser) DCom Security and Launching User Tab is also...
  12. A

    Validation for data mismatch

    Guys i have cross-posted in other forums, please go through the links to find replies to my posts - http://www.excelforum.com/excel-prog...ml#post3617163 http://www.excelguru.ca/forums/showthread.php?2769-Validation-for-data-mismatch&p=11910#post11910 Hi All, I used to copy row data from...
  13. S

    Forming Delete Queries Using Excel data

    Hi All, Greetings.! I have excel sheet with 1 Lakh data. I need to form delete queries by using 2 columns. For example, <tbody> Column1 Column2 100 A 200 B1 100 A2 300 C1 200 B2 300 C2 </tbody> Sample Query I formed manually is, delete from table1 where...

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