Menu

LeedMe

Member
Registration date
March 28, 2017
Last seen
April 12, 2018
Contributions
6
Gender
Male
Location
Hamden, UNITED STATES OF AMERICA

Table Values used to auto calculate and return val

Is there a way in a formula to have Excel continually look in a table, and insert a value in a cell , so that the value in another cell will never be below a value of 20? Once that is met, could it insert the P/N in a specified cell automatically? Please see attached, and thank you in advance... Read more

This is the sheet

Copy rows to other sheets based on value in column [Solved]

All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a macro, to run upon opening the Excel document, and look in column "G" of Sheet1 for the values "MACH" and "FAB. If "MACH" is found in "G" then it copies the row into the sheet named "MACH" ... Read more

Yes, that is I. Sorry about the confusion I was not logged in when I replied. That works prefect. I will study the results to try and better understand how the code works.. I do appreciate it!!