append

Looking for some VBA code to help with the following need. Rows in column G contains a five digit number. Rows in column H contains a combination of text and numbers. Combinations in column H always ends with “-XXXXX”. I need to append the five digit number in column G such that the five...

Hi, I want to update a sales volume list on a monthly basis. I used to have a linked table but the dashboard was getting quite heavy. I rebuilt it using a pasted table. But I am having a problem with append paste. The product numbers are up to 10 digits. The first 4 digits are a prefix, and...

Hi everyone, i'm trying to trigger some code when a table gets new rows. For example, for my financial records, i periodically check for new transactions on my bank website, and copy them and append them into an excel table. When I do this, i want to input the date into a cell to know when i...

Hi everyone, I am new to this forum, I need HELP!! I have linked an excel cell (A1) to an external source, when ever the value from the source changes the cell will reflect the same value(used Paste Special>Link). Now I need a code which can append all the values of the cell in a different...

Cross-posted from excelguru: So here's the situation: I pull a bunch of data out of our database through various queries and mash them all together in Power Query. For one dataset in particular, there are days where the data I need is not FTP'd to our database by the service provider until the...

We have various urls posted into our sheet that sometimes are not valid urls for what we need. So we need to strip some data from it and append some data to the end. EXAMPLE https://www.myurl.com/p/Bce6o9tg0XZ/?utm_source=google&utm_medium=cpc needs stripping to...

I have exported a file and there is a column that returns dates as text in the following format - 01/19. I need to append "2017" to every entry in that column so that the result is "01/19/2017". What would be the best approach to doing so? Thanks!

Hi all Been looking around and couldn't find a suitable VBA code. (I'm not well-versed in coding thus don't know enough to update the codes that I found online). Hoping I can get some help here. I have 2 worksheets. Worksheet1: Data is entered from Column A Column B Column C Column D...

Hi Guys, I am working on a form in Excel VBA code of which is password protected. The idea is that user fills the form (accessible from his/hers drive or from remote location), clicks submit button and the email with details is sent. At the same time the same details are saved into other...

Hi there. I'm attempting to create a user-friendly macro-enabled spreadsheet ("Comments Recap v2.xlsm") that will generate a report of the Excel cell Comments in selected Excel workbooks. I've got a nifty button that will enable the user to select a folder. After that, all the excel files...

Hey All, I've been stuck on this at work all day so turning here in my final hour of desperation! I have two tables, listed below: <tbody> Date Month Program Projected Sales 1/1/2017 1 ABC 100 2/2/2017 2 XYZ 200 3/3/2017 3 ABC 300 4/4/2017 4 XYZ 400 </tbody> <tbody> Program 1 2 3...

Good morning, I am working on a project that requires me to combine the information from 7 different tables in Matrix format into one master table in tabular format that acts as the data source for a PivotTable. The solution needs to be something that can run every time a user has finished...

Hi, how do I append an item to an array without knowing how many to add to ahead of time? I created a generic example to illustrate. Public Sub Add2Arr() Set sht = ThisWorkbook.Worksheets("Sheet1") lastRow = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row Dim maxArr() As Variant For i =...

I have been a user of Access for many years, but never built anything. How do I setup VBA to import and append data to a table? Thanks

I will be loading data into a specific ws that I want to pull in with vba. the file will be in .txt format and all of the columns will be the same. I just need to append this information to the data set Thanks

Hi all. I have created an SPC sheet which stores 120 spc measurements. My code which checks each data column then updates the sheet is as follows: Sub findemptycell() Application.ScreenUpdating = False 'Check that all required fields are complete else stop and set focus to empty field...

I'm looking for a macro to look for a specific Text String in a column and then append the value in another column. We have a program that exports out to a template in excel to do generate a pricing quote for our customers and We have someone manually doing adding values to the name of the...

I have a spreadsheet that my company gets monthly for usage. The spreadsheet has 4 worksheets in it. East, West, Central, RTC. I am using Ken Puls FnGetContents function to pull in each one separately (so I created the function 4 times). Then I append them all after the fact. Is there a way to...

I have a macro that adds data to the bottom of a column, it worked the first time but it keeps pasting in different spots in my worksheet. Can someone spot what is wrong? Dim lastRow As String Range("D3").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy...

Hi There I created a MS Word Macro enable document to update the users Outlook Email Signature and copy it to the Email location. All this is working Now I Want to save values to a Text file (log file) but it must append the text entry into one main "Report.txt" I got the code to save...