• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

count changes made in second sheet columm

M

meir

New Member
hey guys,

i need help with something im trying to do and i think
i need someone with a vba knowledge to help with that (mine is basic at best :(),
the attached file contains 2 sheets ,the first is a raw sheet where i need to
copy /paste diffrent tables in the same table format (i get the tables from my
client and i need to check it for errors) the errors might eccur in cullums E or G,
i than need to type the corrct code into the cell which the error accurd,
what i need the second sheet to have is a macro code that counts the
number of changes that i made (after i copied the table i got to the raw sheet)
in the cells under collums E and G/
appreciate the help in advance,

meir
 

Attachments

  • count events.xls
    341.5 KB · Views: 4
A bit of a outside-the-box thinking, but here's one way to do it:
  1. Have the original raw table copied into 2 worksheets. One of these we will make corrections to, the other will remain unchanged. I'll call them "RAW" and "FIXED"
  2. Make corrections to FIXED worksheet. I'm assuming these are data errors, not formatting.
  3. In a third sheet, called "COMPARE", we'll fill a large enough range of cells with:
    =1*(RAW!A1<>FIXED!A1)
  4. The formula to calculate the # of changed cells then is:
    =SUM(COMPARE!A:Z)

This method wouldn't require any VBA code, and gives you some flexibility in that if you make a mistake making the edit, it won't get double counted.
 
Hi Meir ,

If Luke's answer is OK with you , that's fine , but my understanding is not so complete as Luke's ; can you explain a little more ?

You have data entered in columns E and G ; what exactly do you want the count cell B10 to display ?

Is it the unique number of entries in columns E and G ? For example , the first 20 rows in these columns have the following entries :

Column E : 201 , 203 , 204 , 403

Column G : 1014 , 1015 , 1016 , 1017 , 1301

Based on these 20 rows of raw data and manually entered correction codes , what should the count cell B10 display ?

Narayan
 
You must log in or register to reply here.
Back
Top