-
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...
-
The sheets I'm presenting will change in number of rows (i.e. the range is not constant) It is also a shared work book with protected sheets and rows, allowing the user to insert new rows. I'm trying to write a macro that will sort by column "g" in row 1 which is the header row but...
-
Hi there, Firstly apologies if something similar has been answered before, or i've missed something very obvious, i'm by no means a VB expert. Background I have a Worksheet broken down into Sections, at the top of each Section I have a Macro for Users to Show/Hide (the Rows for) that Section...