Hi Jen,
You may use the macro below to delete the duplicate rows.You may also use
Excel 2007 'Remove Duplicate Rows ' Functionality.
Do let us know if any further help is required.
Public Sub DeleteDuplicateRows()
'
' This macro deletes duplicate rows in the selection. Duplicates are
' counted in
May i know where you from
On Sat, Feb 13, 2010 at 11:52 AM, Rajesh D wrote:
> if any body is having inventory control / pay roll in excel please forward
> me
>
>
> Thanks in advance
> Rajesh
>
> --
>
> --
> Some impo
Hello Fans..
Am in trouble, please give a *macro *to remove duplicate rows (attached file
show just few data) this will help me alot (My original data have up to 6100
rows, possibly more than 500 rows are duplicate).
Regards
Jen
--
---
Okay, so I am in the process of creating a very large excel file and
was hoping for a quick way to do something, but my intermediate skills
aren't able to figure out the solution.
Here is the situation, I am referencing cells off my first worksheet
in subsequent worksheets. For each new sheet pas
When I run an autofilter, it shows x number out of the total records
found in the button left of Excel. Is there a way to extract that #
(the # of records found in the current filter criteria) within a
macro?
Thank you for any help - Michael
--
---
Hi,
I have some source data in one sheet (Calculations) and formatted data
in a second sheet (Output).
In the Calculations sheet, data are one organized one row after the
other.
In the Output sheet, data are grouped by 5 lines, referencing data in
Calculations.
So one every 5 lines in Output ref
Excel 2007 applies a table style to a new table, for example when data
is pasted from an Access Database or a summary cell in a pivot table
is double clicked.
I don't want to use extra toner to print the applied shading, and I
don't want to change the style every time I create a new table.
Can th
Hi Keith,
The files can only be send via emails which attaches to it automatically.
Best Regards,
Ayush Jain
On Wed, Feb 17, 2010 at 6:05 PM, wrote:
> Yes it did thanks. I was wondering if you had the option of attaching files
> to thread so everyone on group could see progress of solution.
>
Hi Team,
Can you send me any step by step procedure Document to learn Basic VBA
2006.
Is there any document which i can go through? or else any video
tutorial website to learn VBA?
It would be great help if provide those details.
Thanks
Puttu
--
---
Paul
Thanks for the prompt response.It worked and so do my macros
Baloo
On Tue, Feb 16, 2010 at 10:47 PM, Paul Schreiner wrote:
> What version of Excel are you using?
> What you are referring to is called using "R1C1 reference style".
> In Excel2007 it is found under Excel Options -> Formulas
>
Dear Steen,
If the values will be overwritten on each day, then what source will chart
(histogram) would use? I belive the chart needs to have the data source to
which it can reference. Alternatively, you can use VBA coding to store these
values at some other location, but Still these data would
Dear Shiv,
I believe seeking help for each set by set of the entire code will not help
you. You should search these keywords in google or other search engines for
explanation. Alternatively, you can connect with the person who has written
this code to understand exactly the reasons/ fundas.
--
Dear All,
Every day we receive nearby 100 files from our system, which contain some
client date and the file name is like ICICI, HDFC, SBI etc, I want rename the
files as per there account no. like 123, 456, 789 etc.
Require your help in creating a macro, which will rename the files as perthere
Hi,
Can anybody help me out in understanding VBA codes for creating macros in
excel,as i am very new to this and not able to grasp it easily.
Is there any way to learn the codes easily.?
Plz help me out in understanding the codes.
Regards,
Chethan
--
---
*Dear Gurus,*
I'm trying to clean up my vba code for printing a named ranged. My problem
is i want to ask the user to input a data to meet a criteria, and then if
that while that criteria is true, it prints a certain range.
Here's my code, IT DOESNT SEEM TO PRINT THE RANGE SPECIFIED BY THE USER
Hi
I'm trying to find a way to show progress without having to insert new
cells.
fx
last week status 30%
today status 50%
this information is enterned into the same cell, the history is shown
grafically i
any ideas how to do this
rgds
Steen
--
---
16 matches
Mail list logo
