D
doublef
Hello-
In a nutshell I am trying to figure out how to automatically sort name
and delete blank cells. Here is what I am doing...
I made a simple mock-up of the type of Excel data I am working wit
(below). It contains employee ID number, names, gross pay and wher
each employee did work for the month. The employee information i
entered in the excel sheet, along with each location they did work fo
during the month.
[image: http://www.vidbusters.com/media/excel_sample1.jpg]
This data is then brought to the following sheet through some simple I
statements (basically, if they did work for Location 1, then put th
amount there...).
[image: http://www.vidbusters.com/media/excel_sample2.jpg]
The problem is that when an employee does not do work for a certai
location, it just leaves a blank space. And in the real sheet, ther
are hundreds of employees so the page will have a few employees,
bunch of blank rows, then a few more employees.
I only know enough Excel to get by, my knowledge basically caps of
with VLOOKUPS
Is there code or some sort of a macro that ca
delete those unused cells and sort the names so they are right unde
each other? If anyone could help, that would be awesome! Thanks i
advance
In a nutshell I am trying to figure out how to automatically sort name
and delete blank cells. Here is what I am doing...
I made a simple mock-up of the type of Excel data I am working wit
(below). It contains employee ID number, names, gross pay and wher
each employee did work for the month. The employee information i
entered in the excel sheet, along with each location they did work fo
during the month.
[image: http://www.vidbusters.com/media/excel_sample1.jpg]
This data is then brought to the following sheet through some simple I
statements (basically, if they did work for Location 1, then put th
amount there...).
[image: http://www.vidbusters.com/media/excel_sample2.jpg]
The problem is that when an employee does not do work for a certai
location, it just leaves a blank space. And in the real sheet, ther
are hundreds of employees so the page will have a few employees,
bunch of blank rows, then a few more employees.
I only know enough Excel to get by, my knowledge basically caps of
with VLOOKUPS
Is there code or some sort of a macro that cadelete those unused cells and sort the names so they are right unde
each other? If anyone could help, that would be awesome! Thanks i
advance