-
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...
-
Can anyone help? I'm after a macro which will search a row from column J onwards. If it finds data in a cell it will add a blank row below the row it's searching in & then paste the data to column D in the new row. It will continue to add new rows & copy the data in to them until it finds...
-
Using Excel 2003, I would like to automate the process of creating a worksheet from a template, got this working, then automate sending this worksheet to a defined distribution list. I tried recording a macro but it stops after the email is called without entering the recipients and then sending the...
-
Dear forum users and bloggers, I would be really greatful if you could help me with the following matter. I need to assign the "freight payer" which is either the sending or in some times the receiving plant, e.g. OT for Ontario etc. I have two columns "sender" and "receiver"...
-
The code is currently opening the file as you describe. The main reason we are implementing this code is for speed reasons. Based on that, I am trying to find the absolute fastest way to read this data. I had done some testing on my local PC and known network locations (with regular drive letters), and...