insert

Hi, I am quite new on Excel and I am trying to create a Formula which is some kind of a database. I want to create an autofill of time between 2 locations that I will pre-set... In the first line for ex. IST is city code and BKK is city code, if I insert these 2 city codes the value of 2 hours...

I have a large spread sheet that I would like to insert number to a group of cells (Column B) based on empty cell in column E. At next empty cell add 1 to number and insert in cells in column B and loop until end of worksheet. The spreadsheet is a research document and has 27K+ rows. This...

Hi I have set excel so all new spreadsheets open with same font and size. Where I need help is when I insert a new column into other peoples spreadsheets the font changes and the size increases. I have a spreadsheet with a MACRO inserting a new column and I then have to spend time resizing and...

I'm looking for a way to insert an entire sheet from whatever the most recent xlsx file is from a specific folder location so lets say theres 3 xlsx files in "C:\Users\bsnyder\Desktop\Excel Program\backups" i would want it to automatically insert a sheet with the data of the first sheet of the...

Good Morning all a few years ago in an old job some one helped me create this piece of code which adds a comment box once someone adds anything to a cell i'm getting a run time error can you please help thank you Jason error: Target.Comment.Shape.TextFrame.Characters(1...

Hi does any one know if you can insert a picture, file name say Tom, into a cell. So if I have the word Tom in a drop down box in cell A1. I would like the picture of Tom to appear in cell B1 and sized to fit in a cell say 100x 100. And if I change the name to say to Jack then Jacks photo will...

Hi all, kindly require to provide me a VBA code so that to insert rows below and place exactly the same contents (e.g. numbers, dates, descriptions e.t.c.) as from above rows cells, except the contents in col. "E" and "J". Thank you all in advance

Hello everyone, I am having a hard time figuring out how to deal with a too zealous characteristic of Excel… I am programming a macro that is basically just an advanced insertion : instead of just copying and inserting a range of cells, I want to allow the user to modify a certain number of...

is there a book i can read or someone who does lessons on that? what i need is to insert the soccer data,and after using formulas like poisson.distr. to give possibilities for certain outcomes

0110027182304679320100060011190301210100245200 i have this number and use the function =find(3201,B7,1) i get the right response "17" i would like to pull the next 6 numbers after the 3201 is found. "000600" and insert it to K7 hope this make sense... ty dean

Hi, I wanted to insert a formula that calculates the sum of a column in a table. Cells(5,6).FormulaR1C1 = "=SUM(TableName[Score])" However, the code doesn't work because TableName is a string variable, I need it to be that way so that i can generate multiple tables with different names...

I want to be able to select the column that I want it to compare the value and if the value changes then insert a row. This code works but it doesn't allow me select the column I want to use and it doesn't stop at the last row that has data it continues to the end of he spreadsheet. Sub...

How can I insert IFERROR( and ,"-") at the begining and end of formulas? With search/replace? Thanks!

I need to prevent or restrict to add new columns into excel sheet.

Hello, The following code is not working to loop through each sheet. Basically I want to add one column to every sheet and then copy paste some values from each sheet. The loop only works on the active sheet and ends up adding three columns, instead of one column to each of my three sheets...

Hello - I'm looking for some assistance, I have roughly 5000 rows of data and I need to insert a row between each of them. Basic Statement that i'm looking to achieve is: If Cell in column A has data, (Text, number, etc) then insert row beneath. Loop until cell with out data (text, number...

Hello all, I created a workbook to keep track of maintenance records for some of our certifications and equipment. I am trying to insert a row below each header row for continuous data it works off of a command button and at the end of a year it will add a new row for each cert or piece of...

Hi, I am looking to insert a new checkbox into the next empty cell. I can get this far, but then can't specify the properties of the box. See below: ActiveSheet.OLEObjects.Add "Forms.CheckBox.1", Left:=1206, Top:=(Range("T" & Rows.Count).End(xlUp).Offset(1).Top) + 2.25, Width:=12, Height:=12...

Hello, I would like to know if it's possible to insert a new row if you select from drop down "Insert New Row". All data should shift down and cell where drop downs are should have "Insert New Row" fixed as a selection. Is this possible? Thank you.

Hi All Column BL9 TO BL25 contains names (Sometimes there might not be any names). Task is if it contains some names then to copy row(A9 TO AO9) and insert that Row xlDown and copy a name in cell B9 xlDown (the name being same as the one in column BL9 TO BL25. SO LOOP IT FOR ALL THE NAMES. copy...