chemical

Hi everyone, I need help on VBA code to copy and merge data from 2 pivot tables into a single data set to be display in another sheet. Below is data Sheet 1 in excel. <tbody> Pivot A Shipto Soldto LV1 LV2 LV3 001 A Local NE Manufacturer 002 B Local NE Manufacturer 003 C Global CE...

Hi, I need help on VBA code to copy and merge data from 2 pivot tables into a single data set to be display in another sheet. Below is data Sheet 1 in excel. <colgroup><col span="2"><col><col><col></colgroup><tbody> Pivot A Shipto Soldto LV1 LV2 LV3 001 A Local NE Manufacturer...

All - good evening Having some issues getting vba to work that specifically points two different data query table connections in one file to a specific separate source file. The specific source file is located in c:\Crop Chemical Database\Crop Chemical Database.xlsm I want the receiving...

Good morning Everyone, I have a master list of Chemicals that require a consignment inventory done each month. The master list is kept in a Tab1. From there, I have tabs for each month Jan-Dec. At the start of each month, I copy the Chemical Master list into each month and format according. Is...

I have a list of chemicals and ingredients in a chart and want to pull in a list of ingredients needed if I enter a the name of a chemical in column A into a cell. <colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col...

I do a lot of spreadsheets where I type certainl chemical formulas over and over (CO2, H2O, CH4, N2O). When I finalize the report I am having to go into each instance and manually subscripting the number which takes forever. I am aware of a way to use autocorrect where I can type in something...