excel beginner

I’m trying to link the square footage on the Taxes worksheet to the lot number (G8 on sheet1). That way, when I enter the lot number on G8 it automatically pulls the corresponding square footage into the calculation on the taxes sheet and puts the result in cell G41 on Sheet 1. Thanks!!!

I can't seem to figure out a formula for this. Please help! I want it to count business working days in numerical output for when I should Order the part based on the date I open the excel file compared to Due Date with Lead Time. <tbody> A B C Program Due Date <colgroup><col width="64"...

<tbody> A B C D E F G H I 1 Contract# Contract amount Already encumbered Invoices Paid Already Encumbered Balance Current Contract Amount Encumbered Unencumbered Balance 2 1234 100 50 40 40 10 </tbody> I made a small copy of my spreadsheet. I will try to explain what I want to do to...

Hi, I have a sheet containing duplicate employee ID in column B. So what I would like to do next is to delete those duplicate entries (by row) and will just retain the last entry in the sheet. Row Column A Column B Column C Column D 1 PHMBIA Maricel A. Chemical...

Hi, I'm sure similar payroll questions have been answered – I just can't find one to suit. I'm trying to help a friend by setting up a payslip / payroll tracker with excel. I have the payslips, and we'll use them to enter data on a weekly basis from the field. I just need to work out how to...

Hi friends, I am a beginner to VBA. I wrote a code to basically compare two sheets of data by their brand name in column A. When they match, I want to subtract the corresponding values of sheet 1 and sheet 2 for same brand. I am using this code. Please help , it is giving a Next without For...