-
I have a large amount of data in a spreadsheet. I am tracking various data by part number. This workbook is sorted by Part number (column "A"). I am wanting to write a macro to find the largest number (in Column "G") for each group of duplicate part numbers. Once this number is found...
-
Every week managers from arounfd my company send me a supply order using teh attached spreadsheet. THe main page of the sheet is setup to atuomatically calculate their order total and then we fill the order. I would like to generate a packing list to include with their order. I need the packing list...
-
My understanding of Excel is pretty basic so 1. forgive me if this isn't the right section and 2. I'm not exactly sure how to ask this question. I am a teacher and I have a grade sheet that has several projects' grading rubrics in columns A and B. Student names are then arranged in columns...
-
Hi All I have a protected worksheet where all but a dozen cells are locked. The unlocked cells are in A1:A12. Occasionally, instead of entering data into A1:A12, the user will drag one of those cells onto another one unintentionally. Often they have no idea that they have moved a cell. Formulas in columns...
-
Hi there, I have a file with a decent amount of rows (thousands and thousands and thousands and...) In one of the columns, highlighted light red in the attached file, I have three rows of an address. I would like to create a macro that will go down the list and cut the second lines of the address and...
-
Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
-
I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
-
I have a very unusual problem. My workbook is fairly substantial and uses a good amount of vba/vb to handle UI issues as well as perform some calculations via UDFs. Recently I have found a situation where inter-sheet links stop working. The application allows the user to add cashflow engines - it does...
-
I want to secure macros from being edited, viewed or deleted by users. Does anyone know how to do this?
-
What is the macro command to go down to the next line?