inserted

Hi I have bunch of similar word doc that has variable amount of sentences/paragraphs that needs to be inserted. I have a table in excel that lists out each paragraph that needs to go into each document. I have 40 documents and each documents will have different number of paragraph. In each...

Hey i'm having trouble getting an outlook code to work in my favor. Basically i have a userform that an end user fills out and it assigns 2 strings to errorHD and issueHD I want to check if the user already has outlook open If its not then open outlook Then use a template that looks like Name...

I have tried to write some code but it won't work. I want the code to get the last number in column A of the sheet "Reference", file name: client_list.xlsm and add a 1 to it. I then want the new number inserted in the row under that row in column A. I also want the new number inserted in cell H5...

I would like to import an xlsm sheet with data into my workbook at the end of the last tab and have the new inserted sheet/tab name the xlsm filename being inserted less the path. below is my code but I cannot get it to work right. any thought to what i am missing or have wrong? I switched to...

Hi All, I have a excel sheet with the connectivity with the sql server. I use this sheet to insert,Update, delete data from the sql server. Now I'm trying to add a column in this which says if the row was inserted or updated in the database. Can anybody please guide me ho to do this? Thankyou

Hello I am trying to write a change event which when the value in H6 is >0 the named range "GreenTemplate"(which is three rows deep) is copied and inserted below named range "insertRow" and then the inserted rows are named "GreenQ1". Then if the value in H6 is cleared the named range is deleted...

Hi Excel-wizards! This is my first post having been a distant follower for a while - so go easy on me ;) I have a number of .xls workbooks which have lots of files inserted into them (Insert>Object>Create from file>Display as icon). These files are usually .pdfs but there’s often others...

Hi I have templates and im going to insert them into a workbook. Thing is the templates once inserted need to be linked to another workbook. Is there anyway I can do that without having to create links manually.

Is there a rows deactivate event? When my users insert a row, I want to prevent them from moving to another row until the cell in the column A of the newly inserted contains a value. Thanks

I know I did this before. But can't find where. It was VBA code that inserted the current time (24hr) when the user entered a "t" in a cell. TIA Bob

Good day, My question is quite simple : I am trying to return the last empty row from a table (Line number where the data will be inserted) into a Text Label that will show on my UserForm. I've looked around and I couldn't stubble upon anything relevant. Thanks,

Hi all, Apologies if i have posted this in the wrong place! Im trying to make it simple for users of a workbook to insert an image. So far I have inserted an activeX image control and used this code (found online) so they can select an image to add to the cell- Private Sub Image1_Click() With...

Hello All, I am attempting to insert N number of rows based on N being inserted in cell "D7" Rows are to be inserted at A10, with the formatting (borders) extending to D10 This is the code i have so far but I keep getting the error message "Runtime error 1004 unable to set the weight...

How can I get Excel to insert x rows below a row based on the value of a cell in that row? eg if in row 1 cell B1 contains '5' I want 5 rows inserted. I have a number of rows with different values so I need different gaps inserted between rows.

I tried to merge three macros into one to conserve steps, and it worked at first. I combined this macro with a copy/paste special/value macro and a delete contents of empty cells in a column. Sub MergeColumns() Columns("F:G").Insert Range("F2:F" & Range("E2").End(xlDown).Row).Formula =...

I have a large worksheet and I like to copy and paste all to the clipboard.My question is I have numbers in parenthesis like (12),but when it comes over to the clipboard it appears as -12 these numbers in the original worksheet come from formulas....which contain "(" and ")".....looks like...

hi Guys Please find my drop box link https://www.dropbox.com/s/t87ax5n6l6exa8o/testing2018.xlsm?dl=0 When sanction letter is selected, sheet sanction letter is opened and cell A2 is activated.Same applies for other menus Today's date is inserted in A2,SL inserted in B2 ,002 is inserted...

I have never used "Target" before. I have a list of name (a18:a150) and want to click on one and have the name inserted into textBox1 in userForm2. I can get the range set correctly and "userform2.show" brings up userform2 (which has my textbox1). I cannot figure out how to get the name from...

I am attempting to insert a formula function from one sheet to another. I have inserted the formula into the destination sheet. It’s works fine for the first cell. When I drop the formula down the column the dollarised amounts used in the formula spreadsheets ‘scatters’ . What I mean is when...

<tbody> Cus_Code Inv. No Date Rs CDD V4525 21/8/2018 1525 CDD V4531 5/8/2018 1522 CFF V2547 11/8/2018 4522 GHB V1478 25/5/2018 3256 GHB V2358 31/8/2018 2563 </tbody> I have above table in sheet1(start from A1) and I have inserted sheets by name of Cus_code in...