-
So i have an assignment which involves this type of problem. Bassically, I have a txt file with numerous rows of data, in the form: Name, Date , Latitude , Longgitude. I need to write a macro which displays all of the data OR just the data from a specifed name. Rather than copy the acutal assignment...
-
Normal 0 false false false EN-AU X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt;...
-
Hello all, I am very new to excel and I need help. Currently, I am writing a macro to populate results into a newly inserted column C (date and time) after I captured info from column A (dates) and column B (time) for a list of data that could easily go beyond thousands row of records. So far, I managed...
-
hey I need help writing a macro that adds 2 values in a col. and then carries the total and keeps going to row 5000. The problem is the number of rows inbetween each number is always variable and the sum needs to return to the same position(if that cant be done results can be move to col B). For example...
-
Please help! I have spent way too much time trying to figure this out, so I'm really hoping someone can help. I have recorded vb that changes a page item in a pivot table when selecting from a combo box - similar to this video. http://www.datapigtechnologies.com/f...s/pivot10.html . The recorded...
-
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...
-
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, 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...
-
Not sure if there is really any Macros Solution for my situation here I got vexed tuning my script. I have 2 .XLS files F1, F2 with multiple sheets and data on merged cells. In F1 under column B for cells from B30 to whatever be the last used row I have few set of values (text). In F2 under column B...
-
Need help finishing this code for a msgbox. If no is selected I want the Sub to End/Cancel, If yes is selected Sub will run its course. I have found plenty of info on making a msgbox but none show how to end the sub when no is selected. Sub Insert_Row() Dim Response Response = MsgBox("Are Cells...