paste data

Good Morning, I am looking for some support with a template I am creating (see below). I have two controls - one to use to send the information in an email, and the other to clear the form. I have used a Macro for the clear form control, and that is working fine. I am looking for assistance with...

Hello, I've tried to record a macro and expand that in order to help solve my problem. I've fixed some things I need to do by looking at solved threads, but not everything. Below is my code. Ideally, I'd like to do the data sorting operation for a bunch of text files in a named folder, but...

Hi all, The macro I run extracts data from multiple workbooks and I have set different ranges from where to copy & paste this data into one data sheet. Issue I am having is that when I run the macro it replaces the data from previous extract in my data dump sheet. Is there a way I can keep the...

Hi there! Can anyone help me with such a simply looking issue,please? I use a sheet with some design, including fields for input by user. To prevent destroying my design, I would like to let users input datas only as a paste without formatting the cell. So I typed in this VBA code...

I have a spreadsheet with several hundred records. I would like to populate blank fields in each record with information from another record with the same value in a particular field. In the example below (blank cells have been replaced with ___), I want to populate all the blank fields in...

Hi, I need help with adapting a VBA code someone helped me with a few years ago. Basically, I have an excell sheet from which I want to copy values from certain cells and paste into another flat excell file. The data falls into two types: 1: One off ie invoice date, invoice number...

Hello experts, I’m new to Excel, but I’ve grasped the concept of basic macros in VB. I’m now trying to create a macro that cuts and pastes whole rows into a different sheet depending on whether they have a particular word in any column. This is a little beyond my expertise, and I would be very...

Help Please,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am creating a report (using a predefined template) based on static data that was originally filtered from a pivot table. Here is the background:<o:p></o:p> <o:p></o:p> receive pivot...

I have a workbook with numerous sheets, few sheets have data in standard rows and columns, one sheet has a label/tag setup such as : Date:___________ Name:__________ Style:__________ Number:________ Is there anyway to highlight a row of data from another sheet and drop that information into the...

Problem: I am creating a form with a webbrowser as an object inside. From a sheet in excell I want to copy information from several cells to the browser in my form. I have no specific destination in the browser form, as you can see in the code snippet I am tabing my way through the form using...

Hi! I think this will be easy for someone smarter than me. The data: I have a list of items in for repair, and record the date the item hits a particular department in a spreadsheet. Departments are columns, Items in for repair are rows. What I've done: Created a sheet with a row for each day...

Hi Guru's, This would be a BIG help and would be a solution to months of work i have been completing. I really need a macro written that will copy two sheets (sheet 1= rep data & sheet 2= stats) from a closed workbook into another individual workbook through macro button. Lets call the...