Over 1 million tech questions and answers.

YTD column for payroll Sheet

Q: YTD column for payroll Sheet

I am manually creating a payroll spreadsheet for our company (excel template). I want to add a column that tracks YTD so at the end of the year I can look at how much we spend on payroll. Example I would like cell "I5" to add what is in cell ($60) plus the new week total in cell "H5" ($150) to show a total of $210 in I5....I also want to keep a running total same type deal for the taxes.

I have googled and saw maybe a macro is needed but have not idea how to create this.

Preferred Solution: YTD column for payroll Sheet

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: YTD column for payroll Sheet

Read other 8 answers


I have this Tracking workbook and I need to sum the number of days from worksheet A to worksheet B, column B for sum and count the number oy days in column C. I tried to record a macro but it's not working if there's new data in worksheet A. I add data in worksheet A quarterly and need to sum and count only the new ones. PLease assist.

Thanks in advance.

Read other answers

This may have been asked/answered Previously but I didnt see an answer, I know its possible to Hide/unide column's But I need to do it based on if there is a null Value. IE there are 9 columns only 1 has manditory Value, Name. In my query that pulls the data (a search Box) it pull records that dont have data in the Location field. so in my Subform frmSearchdata I want the location column hidden. Ive tried several ways of coding it in VBA and I dont get errors but it doesnt hide the columns either. Any tips?

A:Hiding a Column In a data Sheet

I see this is not your first post and of course we can all make assumptions but you know what the assume stands for.

it makes an a s s out of u and me

Leaving that for what it is, I could assume you're talking about Excel but ... further more no version of the (unknown) application mentioned which is also quite relevant due to added functionality

Maybe Excel but if could also be Access . . .

Read other 3 answers


Please see the attachment which will hopefully make this easier to explain.

What I need to do is;

* In the 'All Orders' Sheet if Column E (Supplier) Matches the text in 'Wolds' A2, then copy that row of data from 'All Orders' to the 'Wolds Sheet'

* I need to make sure that the data from previous runs that has been copied across does not get duplicate (But sill remains in the list)

* I need the headings in 'Wolds' to remain (So data to start in row 3)

* Also in column P in 'Wolds' (Code) I need that column to remain untouched, and numbered as it is (W1 W2 W3 etc)
Thank you
(I've also asked this question here; http://www.ozgrid.com/forum/showthread.php?t=189975&goto=newpost**


here; http://www.mrexcel.com/forum/excel-...-row-data-if-two-cells-match.html#post3885898)

A:Copy cells from 1 sheet to another is column equals certain text

Already seems to be taken care of on both other forums

Read other 2 answers

Sort a sheet by column, work on it, then put it back...

Does it make sense?, I want to put (sort) my price list in alphabetical order temporarily
work on my number's, then put it back to the original order when i am done.

How could I do this?

A:Solved: Sort a sheet by column, work on it, then put it back!

Read other 6 answers

tried looking for this in many different places but can't find an exact match and i tried to edit some macros but still would not work.

i need a macro that will allow an entire row from one sheet be copied into a new sheet.

so basically here is what needs to be done:

1. from my active sheet, look in Column 'D', select all rows in in column D if it has the word "Confirmed" in it

2. create a new sheet and paste all those selected rows to this sheet

3. delete this transfered data from sheet 1

4. in the new sheet, i need to add in titles as follows in columns A - O:

Event Status
Project Type
Project Status
Start Date
End Date
Project Name
Project Fund
Project WBS
Project Cost Center

So column A Row 1 = Ticket, B Row 1 = OrgCode, etc...

5. I already have a macro which changes the current sheet column names, so i need to add the above into this code.

Sub recordd()
' recordd Macro
ActiveCell.FormulaR1C1 = "Ticket"
ActiveCell.FormulaR1C1 = "OrgCode"
ActiveCell.FormulaR1C1 = "Event Type"
ActiveCell.FormulaR1C1 = "Event Status"
ActiveCell.FormulaR1C1 = "Project Type"
ActiveCell.FormulaR1C1 = "Project Status"
... Read more

A:Solved: copy entire row to new sheet if column data is matched

Read other 13 answers

I wish to know if it is possible to update a field on one sheet with the last entry of another sheets column?

as info is added to one sheets column the data on the other sheet is automaticall altered to show the last entry in the first sheets column where i entered the data in the first place

A:Solved: EXCEL: update field on one sheet with the last entry of another sheets column

Read other 16 answers

i am uploading excel work book with 4 sheets, sheet no1 contains the record to be verifed/matched with the records in sheet no.2. we will match BTC_Name, BTC_Fname, Deg_RegNO of sheet1 with student name, father name, reg.no. of sheet no.2, if records of sheet no.1 are matched/presented in sheet no.2 then the whole row of sheet no.1 should be copied in to sheet no.3 (if matched display here) else other wise mismatched/ not presented records of sheet no.1 in sheet2 should be displayed (whole row) in sheet no.4 (not matched display here). i have shown sample values in sheet 3 and in sheet 4 taken from sheet 1.

A:compare/match multiple column values in multiple excel sheet

Read other 11 answers

QuickBooks Pro Support :-Technical experts at QuickBooks Pro Support help to resolve the technical errors with the software through
QuickBooks Phone number.

QuickBooks Premier Support :-QuickBooks Premier is designed to accomplish all expanding needs of your small scale business to
keep track of the financial transactions and compile reports with minimum efforts. If you need to help in understanding any feature of the software, you can call at QuickBooks Premier Phone number to discuss with the experts and find a solution to your issues.

QuickBooks enterprise support :-QuickBooks enterprise software is considered ideal for the large businesses with over thousands
of vendors and customers. It has advanced inventory and payment features which can create problems for the users. Experts at QuickBooks Enterprise Support will help to understand the features.

QuickBooks Payroll Support :-Understanding Payroll support is subject to big problem in the beginning. For new users, it can lead
to a big dilemma. Instead of it, the users can get in touch with experts at QuickBooks Payroll Support and the expert help.

Read other answers


I am trying to classify and code my inventory items in excel.
My classification sheet contains data in columns which I would like to copy to rows in another excel sheet.
Here is the sample data in ACMOTORS-ATTRIBUTES sheet:

The above sheet has to be converted to columns as in Item_Classificatios_Form sheet :

Can anybody assist me in writing a macro for the same.


A:Solved: Excel Macro to convert Rows from one sheet to columns in another sheet

Read other 8 answers

I need to copy n number of rows from a sheet in my local machine to a sheet in fileserver.
My requirement is - if I select last 2 rows in the sheet in my local machine I need the rows to be copied after the first blank cell in the sheet in fileserver.
Also it would be helpful if the macro code is only in the local sheet and not in the fileserver sheet.

I am a newbie to macros pls help....

Read other answers

Hi All,
I found an old post (http://forums.techguy.org/business-applications/632779-selecting-previously-active-sheet.html) which is exactly the same issue I'm having...
...however the thread starter said that they managed to sort but didn't explain how! A little frustrating...I've search for similar issue but couldn't find one so sorry if this has been covered elsewhere.
Anyway in short, I have an interactive dashboard whereby it only shows one worksheet at a time both for aesthetic and functionality reasons. A user moves through the workbook via buttons. A number of worksheets may lead to one worksheet or visa-versa. Because of this I'd like a macro that when the user clicks the 'Back' button they are returned to the last active page they were on but hides the page they have just come from, so still keeping the one worksheet format.
Currently I'm writing a separate code for going back to a particular sheet, laborious considering I have 60+ sheets (and counting). Plus I intend to use this dashboard format for other uses in the future so having a catch-all macro to go back would be very useful.
Help much appreciated.

A:Solved: VBA: Select previously active sheet and hide current sheet

Read other 15 answers

I sincerely hope that the description below is fairly comprehendible.

I am constructing a table in excel of movies with the actors, actresses, director, etc. On the first sheet (named Movie Info), column 4 is an ever growing list of movies. Across row 8 is a list of actors, actresses, directors, etc. Across the row of the title and under the appropriate person who is in that movie I place a check mark (this check mark will eventually become a hyperlink to something like Wikipedia or IMDb). What I would like to do is manually enter the new title. To do this, I am inserting a new row at row 9, just below the people row. Then from something like IMDb, copy and paste a list of the important people on another sheet (sheet 4, named Dummy). At this point I have been trying to write a macro to "read" the person on the Dummy sheet, jump to the Movie Info sheet, find the appropriate person and place a check mark under that name, and when finished insert a new blank line in row 9, preparing for a new entry. This macro would also have to realize that if the person isn't found that it would have to be added at the end of the "people row". At this point I have 163 movies. That's not the problem. The problem is the people list is at column TZ and to scroll manually to find the appropriate person is tedious to say the least.

Can anyone help? I appreciate your thoughts.

A:Solved: Read a name from a list on one sheet, then find a match on another sheet

Read other 10 answers


I need to paste data from one worksheet that is unfiltered (not hidden) onto a worksheet that is filtered. I need to paste onto visable cells only, ignoring the hidden rows. Currently, my data is being pasted onto both visible and hidden rows.

I know its possible to paste only visable data, ignoring hidden cells, but I need to do the reverse of this. Pasting non hidden data onto only visible cells. And I hope I am explaining this well.

Please do not suggest a vlookup because this would take entirely too long due to the nature of my data and this project. Also, I am not skilled enough to do code, so keep it simple...

Suggestions please?

A:Solved: Pasting in excel from unfiltered sheet to filtered sheet

Read other 6 answers

I have several costumer info sheets i like to combine into one work sheet list. each sheet layout are the same. they each have a customer name, address, etc. field. I like to take each field and make a list on one sheet

A:making list on one sheet from info from several sheet in same work book

What version of Excel are you using?
Do you know how to record a macro?
Have you any experience with VBA for applications?
Alls you need to to is record a macro that and carry out the actions you want to do and after you stopr the macro recording you can take a look at the cade, what it did en edit it to make it more efficient.

Read other 1 answers


I am looking for help on VBA to unhide a specific sheet to enable the macro to run, then once complete to rehide the sheet.

Code I have so far is as follows:

Application.ScreenUpdating = False

ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[3]-'W2-1'!R[9]C[4]"
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[1]"
ActiveCell.FormulaR1C1 = "=""W2-1 - Jnl No.""&'W2-1'!R[9]C[-2]"
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[3]-'W2-1'!R[9]C[4]"
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[1]"
ActiveCell.FormulaR1C1 = _
"=IF('W2-1'!R[9]C[-2]="""",IRIS_JNL_W2.1!R[-1]C,""W2.1 - Jnl No.""&'W2-1'!R[9]C[-2])"
Selection.AutoFill Destination:=Range("A2:C500"), Type:=xlFillDefault
Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 1 Step -1
If (Cells(i, "A").Value) = "0" Then
Cells(i, "A").EntireRow.Delete
End If
Next i
Selection.PasteSpecia... Read more

A:Solved: Unhide sheet, to run macro, then hide sheet

to hide
worksheets ("IRIS_JNL_W2.1").Visible=False

to show
worksheets ("IRIS_JNL_W2.1").Visible=True

Peace be upon you

Read other 1 answers


I need to write a macro which has to automatically fill the data written in sheet1 to sheet3.This should happen row wise.

For example if the data entered in A3 of sheet1 then this data should automatically get entered in A7 of sheet 3 upon a button press.

Advance thanks for your replies.
Sandesh K R

A:Macro to insert data entered in one sheet to another sheet

Isn't this just a copy and paste?
You could record a macro and then edit it

Read other 1 answers

hi guys...i posted regarding this file a few times...and is still coming back to haunt me!

i need some help here....especially now that the ppl at the office need the information to be drawn out differently.

ok. here's the scenario:

i have an excel file with 8 sheets

"Questionnaire" sheet is to be filled out by a rep and has some drop down lists to populate the "POtemp_NY" sheet.

ampaper, edmar, sterling, stoneglo, strauss and uneeda are all venders with lists of their products...with their prices.

"POtemp_NY" is the master sheet where all the information must show on

The problem is, i need to have the "POtemp_NY" sheet populate the description, units, and price when someone enters a value in the "Units" column on a vendors sheet. Also, i would need the "POtemp_NY" sheet to continue to list the products on the next lines if there are multiple products with values in their "Units" cell.

Any help would be GREAT!!!!

Thanks in advance!

the file is attached for reference! thanks!!!

- mark

A:Solved: excel: populate sheet from list (fr another sheet)

Read other 16 answers


First of all, I am trying to concatenate fields in several records. Currently, I have a query that pulls out the specific account, appending to a table called "Control Log" and it looks like this:

Client Form
------- -------
Lesand 1040
Lesand 1099
Lesand G-45

I want to get to look like this:

Client Form
------- ------
Lesand 1040,1099, G-45

where I will append to another table called Control Log1 where an automatic number will be assigned to just that one record. I then want to populate a form with the autonumber and client info, and the remaining information relating to that client will also populate (address, etc.) from the query that pulled their info from the beginning.

I am fairly new to the new features to Access 2007-2010, but am eager to learn. Thank you for taking the time.


Read other answers

Hi Everyone,

I have a date column in my spreadsheet and there are several actions that I would like to apply to it -

1). Auto populate the date column with the current date only when the column to the left has data entered into it (please see below)

2). Make the date column read only so that it cannot be modified by other parties.

Any help will be greatly appreciated.

Kind Regards,


A:Solved: Automatically enter date into a column and make that column read only

Read other 6 answers

I have a list of 39525 emails in column A and a list of 19909 emails in column B. If an email exists in column B that also is in column A I want it removed from column B. PLEASE HELP! THANK YOU!!!!!!

A:Solved: Excel 2010 - Remove duplicates from column B that exist in column A

Read other 9 answers

Hi Rollin_Again and everyone in this forum,

Hoping someone could help me in my problem.
I have a workbook in Microsoft Excel 2010 (Windows) of about 60.000 rows of words in different languages.

Some words have 5 different languages and some are only 4 or 3, all are written in Column A of the workbook.

Column A
English -------(in color Orange)
Spanish -------(in color Red)
Italian ------- (in color Blue)
German ------ (in color Black)
Papiamento ---(in color Green)

What I want is a Macros Program that can put all Spanish words (red color) in Column B, all Italian words (blue color) in Column C, all German words (black color) in Column D, and all Papiamento words (green color) in Column E.

Like for example:

Column A --- Column B ---Column C --- Column D ---Column E
English -----Spanish ----Italian ----- German --- Papiamento

Thank you very much in advance and I'll appreciate all the helps you could give me.

A:Transfer texts from Column A to Another Column, Excel 2010 (Windows)

Read other 9 answers

Hi Everyone,

Seriously need your help ><"
I am using MS Office 2010 and Windows 7

I have a data like this (The number of Products and Shops are much more)

I want the result to be like this

This is the attached file for you to download the data or you can simply download from the attachment in this post

I would really appreciate the help of the community
Kudos to everyone!!!!

A:Excel Macro - Merging multiple column into single column

in a new cell, create the following formula.
=A1&" "&B1&" "&C1

Or isn't this what you want?
(the cell-numbers are those which you want to combine).
You can copy the formula for all cells (haven't seen your file, find the link a bit tricky, maybe attach the file in a post here)

Read other 3 answers

hello all,

in excel 2003, i need to add a whole column of numbers but i need to exclude any rows, and so it's corresponding cell in the column i'm adding, which may contain a particular string of text.

for example,

say there are 3 columns,

"date", "description", "amount"

i want a total for the amount column, "=sum(c:c)" but i don't want to include any cells which have a DESCRIPTION of "gratuity, thank you".

i hope this makes sense and any help is much appreciated.
many thanks.


A:Solved: ignore rows with certain text in one column when adding another whole column

Hi there, welcome to the board!

I would do one of two things.

1) Take a look at pivot tables
2) Take a look at SUMIF()

Both will get you where you want to go, although the first option is more powerful and robust, it has a much higher learning curve, whereas the second one is more succinct and easy yet less flexible.

Edit: This will get you started with the second item...
=SUMIF(B2:B10,"<>"&"gratuity, thank you",C2:C10)


Read other 2 answers

I need some help. I am trying to come up with a formula that counts the times that a "string" occurs based on a value in another column.....
Everytime column a = "Jones", check if column e = "tom".....if so count it.

A:Counting strings in one column based on Condition in another column in Excel

The EASY way to do this is to concatenate columns A and E using (for instance) this formula:



=A1&" "&E1 (puts a space between two words)

Then count the individual field. Make sense? Will it work for you?

Brainbench MVP for Microsoft Word

Read other 3 answers


I have an application called BT Billing Analyst. This application has an option to open a report in Excel.

When I used Excel 2007 the report data opened in sheet 1 of an Excel workbook and some information on the report was put on sheet 2.

I recently upgraded to Excel 2013 and now when I open the report in Excel the report data is populated on sheet one but after that the first 25 lines get overwritten by the information that should go to sheet 2.

Is there any way I can fix this?


A:Excel - Sheet 2 data getting written to sheet 1

You may have to go to the BT Billing vendor to resolve this. Perhaps an updated version is available. 2007 is xml based like 2013 so I am surprised there is a conflict. But I don't think there is anything in Excel you can do to resolve.

Read other 2 answers

This is OpenOffice, but maybe Excel formul? are similar...

Anyway, I have my main spreadsheet on sheet 1, but there is a cell on sheet 2 I want to have display on sheet 1 as well. The cell on sheet 2 will change over time, so I cant just copy the value. I know if its on the same sheet, I could put =C5 or whatever the case may be, but I dont know how to format it to get data from another sheet.

Can anyone help? Thanks

A:OpenOffice: How to display cell from sheet 2 on sheet 1?

Exactly the same way as Excel
Start your formula in sheet 1 and then link it to sheet 2

Read other 7 answers


I want to copy the original sheet into another sheet.

I have sheet1 tab.

if I use this code:
ActiveWorkbook.Sheets("Sheet1").Copy after:=ActiveWorkbook.Sheets("Sheet1")

it created sheet1(2). but I want to specify my tab name.

if I chnage it and run:
ActiveWorkbook.Sheets("Sheet1").Copy after:=ActiveWorkbook.Sheets("helloworld")

It fails.. error comes up.

How do I make it work?

Thank you

A:Solved: EXCEL: copy sheet to another sheet

Hi sk0101,

rename it after copying:-

ActiveWorkbook.Sheets("sheet1 (2)").Name = "helloworld"


Read other 2 answers

hello, i am very rusty o ms excel, please help...

I have two worksheets A+B, I need to pull in data from sheet A to sheet B, sheet A+B both have matching records, company name for example that can link the sheets.
so i need to pull in data from column C in sheet A, to say column L in sheet B.
what would be formula?

Read other answers

I'm trying to delete the first 5 rows of every sheet except Sheet 1, and delete the last row of every sheet except sheet 1 (sheets are different lengths).
Can anyone steer me in the right direction? I've tried google searching for scripts that might work but when I piece them together I get errors everywhere.

Frankenstein code I pieced together:


Sub DelRows()

Dim Wks As Worksheet

For Each Wks In Worksheets
If LCase(Wks.Name) <> "Sheet1" Then
End If
Next Wks

End Sub

A:Solved: Delete top 5 rows from every sheet except for Sheet 1

Try this.

Sub Delete_5Rows()
Dim wsheet As Worksheet
Dim wb As Workbook
Set wb = ActiveWorkbook
For Each wsheet In wb.Worksheets
With wsheet
If wsheet.Name <> "Sheet1" Then
With ActiveSheet
End With
End If
End With

End Sub

Read other 3 answers


My question relates to a list I have created that shows our team who our internal stakeholders are. We select thier name from a person/group column and then add in using Lookup columns, which division and department they are from.

So I don't have to worry about updating the look up lists whenever a team changes it's name or if a person leaves to go to another team, I thought I would add 2 more person/group columns in place of the lookup columns.

So now, a user has to enter the stakeholders name 3 times in the 3 person/group columns and they are set to display the Name (Person Column 1), Division (Person2) and Department (Person3).

Now the problem; I'm looking for a way in SharePoint Designer (SPD) so when the user is on the new item form, they only need to enter the stakeholders name (Person Column) once.
Then, using SPD, I would like to adjust the display list so the Stakeholders information is showing in the three Person columns. The 2 news columns show the stakeholders division and department. The other 2 columns will have automatically copied the source date from the original name column and are now displaying (the same source data) as division and department.

Is this possible?? I appreciate any help you can offer.

A:Solved: SharePoint - Replicate Column Information in another column

Solved in another forum. Used a workflow.

Read other 1 answers


Hi there, I need help creating a formula that adds Column A, only if Column B = 'A'.
I then need to multiply that counted value by another cell.

Can someone please help me? I think I'm over-thinking this.

A:Excel: Count Values In One Column On Basis Of Other Column Value


Where B1:B4 is where your A and B values are, and A1:A4 is where your numbers to sum are located.


Read other 1 answers

I have an Excel 2003 spreadsheet that has three columns that are populated by dropdown lists. I have attached a sample based on my real problem for you to see. Depending on the selection in Column A there could be a required entry in column B or a required entry in column C or it may require that an entry be made into either B or C. If an entry is made in column A and none made in B or C then I need a message box to pop up to remind them to make the additional selection. Thanks in advance for your assistance.

Read other answers

I have a spreadsheet that I would like to give to both English and Spanish speaking workers. Is there a way to convert the English text in column A to Spanish in column B? I will be changing the text in column A on a weekly basis and will need to translate then distribute to all workers.

Thanks in advance.

A:Excel - Translate English in Column A to Spanish in Column B

Read other 8 answers

I have a very large spreadsheet of data, 365 columns and 290 rows. I would like to convert the data into 1 very long column, with all of the data consecutively listed. Is there a function that allows me to tell the formula to look to the first line of the next row of data, and copy down from there, and then go to the next column, etc? Right now, I'm just referencing the first cell in each column, dragging down to fill the 290 following cells, and then referencing the next column. It's really time consuming because I have 48 of these spreadsheets. Any suggestions would be greatly appreciated!

A:Solved: How to move data in a series of column into one column


if you name the range of 365x290 cells as, for example, 'MyRange', then the following (downwards extendable) formula should work:



Read other 2 answers

Windows 7 - Excel 2010
I am trying to write a macro with that will start at the bottom (an unknown line number) and loop up through the rows, then stop at row1. It will need to loop from column C thru F to see if the value is a 0. If all 4 columns = 0 then delete the row and go up one row and start checking C thru F again. If at any time there is a number value in one of those columns it needs to move up 1 row and start checking again until all rows except row 1 have been checked.
I know I have to start from the bottom and move up to delete rows without skipping any. I've been looking and looking, but I can seem to find the right code for this. I know I'm missing something. I could use any help I can get. Thanks.
This is what I've written and the first Lastrow = Range("A " & Rows.Count).End(xlUp).Row - 1 is getting runtime error 1004 Method Range of object Global failed

Sub Delete0valueRows()
'Open LTC Individual-2020
Workbooks.Open FileName:="C:\Users\Diedre.N.Collins\Desktop\LOB CY2020 Macro Worksheets\LTC\LTC Individual-2020.xlsx"
WorkSheets("LTC Individual-WIP").Select
Dim i, Lastrow
Lastrow = Range("A " & Rows.Count).End(xlUp).Row - 1
For i = Lastrow To 2 Step -1
If Cells(i, "C").Value = 0 Then
Cells(i, "C").Offset(1).Select
Lastrow = Range("A " & Rows.Count).End(xlUp).Row - 1
If Cells(i, "D").Value = 0 Then
Cells(i, "D").Application.Goto (&qu... Read more

A:Solved: Column to column loop with bottom to top looping

Read other 7 answers

Excel 2010

In my workbook, the data on Sheet 2 is:
column A - customer #
column B - service tech name
column C - service performed
column D - service performed
column E - service performed
column F - service performed

I need to count how many times a service tech performed each service.

Since each customer may have more than 1 service performed, the 1st service performed is listed in column C. Then, the next service is in column D and the next in column E, then F.

For example:
Customer # 123456
Service tech: Jim
Service performed: tire rotation
Service performed: oil change

Customer # 456789
Service tech: Jim
Service performed: tire balance
Service performed: tire rotation

I need to know how many tire rotations Jim performed, no matter what column the service is listed in.

The data will go into Sheet1. Column A has all of the services listed. The service tech names are across line #1, starting at column B. Therefore, if Jim is listed first and tire rotation is listed first, I need the count to appear in B2.

Here are 2 different formulas I have tried and neither one works properly (should the first formula be "OR" instead of "+"?):


=COUNTIFS('SHEET2'!$B:$B,B$1,'SHEET2'!$C:$C,$A2)+COUNTIFS('SHEET2'!$B:$B,B$1,'SHEET2'!$D:$D,$A2)+COUNTIFS('SHEET2'!$B:$B,B$1,'SHEET2'!$E:$E,... Read more

Read other answers

I have a very large spreadsheet with thousands of rows and about 20 columns
Col A has either of 4 values North, South, East, West
The other Cols have numbers
I want to get a total for North, South, East, West for Col B, C etc
Is there a formula I can use something like (if Col A = North , total ColB is )
Don't want to keep resorting by Cola and putting in Subtotals
Hope I have explained it well enough


Dublin, Ireland

A:Excel Total in a column based upon value in another Column

yes you can use

SUMIF(A:A, "north", B:B)

OR if you put the values North, South etc into a new column - Say Z2,Z3,Z4,Z5

and copy down

if not - please upload a sample
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

Read other 3 answers

I hid all but three columns and if I right-click on column A to insert a column, it becomes column B and no column is to the left.

A:In Excel 2007, how do I add a column to the left of a column when there is only 3?

I have Excel 2007
I put the cursor in column A, right click, and then insert.
Insert entire column. It appears to the left. Is this what you are doing

Read other 4 answers

Not sure exactly how to word what I am trying to accomplish. for each matching cell in Column A, evaluate the values in Column B for matching rows. In the example spreadsheet, I have highlighted the ones I want vba to evaluate. The column can also be as large as 5000 rows at times. So for Dayton, at least one % is 0 and one is more than 1%. In that case I want the 0% highlighted. Same for Los Angeles and Annapolis which has 4 matching rows. However, I don't want Sacramento and Mobile 0% value highlighted because the value(s) are all below 1% each. I don't even know where to start on coding this. Any help is greatly appreciated.

A:For each matching cell in column A, evaluate Column B value

Read other 6 answers

Hi everyone,
I'm looking to automate deleting duplicates column by column within each row. For example, in the attached example, on row 590, I'd want to delete duplicates of '1225 Whthrs Mrcvl Rd Ste 206,Hamilton,NJ,08619'. In addition, I'd want this automation to process the entire worksheet.
Considering that there is over 8,000 rows, I'm praying that this is possible.
Thank you!

A:Solved: delete duplicates within a row; column by column

Here is a possible solution but without a clearer view of your data it is strongly advised that you try it in a copy of your file.


Sub DelDup()
Dim lRow As Integer
Dim lCol As Integer
Dim i As Integer
Dim c As Integer
lRow = Cells(Rows.Count, 1).End(xlUp).Row 'Find the last row used in column A
For i = 1 To lRow 'loop through each row
lCol = Cells(i, Columns.Count).End(xlToLeft).Column 'Find the last used column in the row
For c = lCol To 2 Step -1 'loop backwards from the nth column to the 2nd column in the row
If Cells(i, c) = Cells(i, c - 1) Then 'compare column c with the previous column
Cells(i, c).ClearContents 'if they are equal then clear column c
End If
Next c 'go to the next column(which is the previous column)
Next i 'go to the next row
End Sub

Let me know if you need help inserting the macro into your workbook.

Read other 2 answers


I have a query but I'm not sure if it's even possible to do.

If I enter a name into cell J1 I want to check for this name in column H then for each row that is found on I would like to sum column B and output the result to cell J2. E.g. If I enter Paul into J1 I would like to search for this name in column H. For every row this is found on I would like the B cell for that row to be included in a sum of which the result is output to cell J2.

Is this possible and if so does anybody know how?


A:Solved: Excel - Search for value in one column, sum a different column

yes, SUMIF() should do that

i'll edit - and add an example

enter into J2


see attached example file

Read other 1 answers

Twice over the past five months, when reconciling my QuickBooks Pro 2007 account with my bank statement, I have found that the tax amounts for two previously-reconciled paychecks have changed. My accountant, to whom I send my account in a QuickBooks Portable File and who uses a QuickBooks payroll program, says they have not made any changes. By checking backup, I have narrowed the time when these changes occur to the time that the portable file is used for payroll processing. Manually correcting the changed amounts is not an option since they revert to the changed amounts at the next payroll processing period. This seems to be an issue with QuickBooks payroll processing software. Has anyone else had such an experience and, if so, found the cause and a solution? The checks in question had been printed and reconciled at the time the changes occurred and the net pay had been "locked" so these changes should not have occurred.

Thanks for any help.

Read other answers

At our company we accrue vacation over 10 months (Jan to Oct each year). The std Peachtree vacation formula assumes a full calendar year. I need help constructing a Peachtree formula that will stop accruing vacation after October. I can set the amount per check. Something as simple as the following concept:

IF (payroll date > 10/31/08, 0, 3.08) which would accrue 3.08 hours each pay period with a date less than 10/31/08. I don't know the syntax within the Peachtree software to make this happen.

Thx in advance to any PT expert that can help!

Read other answers

Hi guys

I want to build an HR/Payroll system from scratch.
It needs to be similar to the one I use at the moment which is a website, it is a management information system that many people log in to, to enter and view data from.
For example
Manager A inputs shifts on to a rota for his team of 5 staff members.
The 5 staff members are able to log on to the site (as a basic view only role) which allows them to see what the manager has submitted for them for their monthly timesheet.
The data entered by Manager A and by Admin A about Employee A is able to be manipulated and presented in a pdf report. For example, if I want to know how many times Employee A has been off sick in the past year. Thankfully for me, Manager A has been putting Employee A's periods of sickness on the rota. The system lists these periods of sickness, and all their attributes, from the past 12 months, in a pdf report for me. It also does the same for holidays/annual leave. The system also gives me a pdf-able report of the employees training because Admin A has put on information about every course Employee A has done.

I can also, on my system role, upload documents for managers to view.

I can also export all timesheet entries by CSV so I can import it into another system (Sage).

I am not an experienced IT expert but I am willing to spend years learning how to do this.
I just need someone to give me a map of where to start, what I'll need in terms of resources, and what knowledge I will need to... Read more

Read other answers

I a little rusty but I'm trying to create an excel payroll spreadsheet and I'm running into formula issues at every turn. I'm trying to insert a formula that takes my gross income (L3) and calculates federal income tax withholding including deductions and to show the total in Fed W/H box (M3)
I also need to calculate Suta at .8% up to $7000

I know this is a lot. I am just getting back into the workforce after almost 10 years of stay at home mom, and my brain is trying to catch up. Thank you in advance.

Read other answers