copy and paste

Hello, I have a workbook that's set up to query a database and return values. I need to send this workbook to others who do not have access to this database. If you don't have access to the database, errors are returned rather than the values. What I need to do is somehow copy and paste the...

I had a workbook which became monstrously large for no reason (100mb). I copied and paste special values the tabs into a new workbook which reduced the size to ~120kb. However now, when I copy a row into the row below, it brings up the save as prompt every time. Why is this happening?

I'm working on cleaning up a report that contains statistics for all counties in the U.S. by state. I'm trying to find a way to filter the data so I can select only the state and counties I need to look up. Currently, the report contains each county on a row, with the only separation between...

I don't know VBA much at all.... and I need help. I'm trying to code it so that I can go to the column that I specify in a cell. In cell A5, I have 32. so I want to select the entire column of AF and copy and paste that column to the right, so in this case, column AG. next month, it will be 33...

Hello, I am new to the forum but I hope someone has a solution for me. I currently have an ongoing list of people who have "checked in", and receive a new list each week of people who have "departed". Basically, I would like to be able to have a macro that I would be able to run and match the...

Hi, I am trying to make a Macro to add trackers after clicking a button. My excel is set up this way: - The 1stColumn of Row 9 is a formula that shows today's date - Row 10 has 6 Column with 6 criteria - From Row 11 to Row 2010, they are formulas for the 6 criteria on Row 10 I am trying to...

Hi everyone, Can anyone help me out with this tricky situation, I have a Excel form to be filled based on the name of a person , but if the score is 0 I should not pick it. whats the easy way to do this? Macro or Vlookup?:warning: <tbody> Smith 73 Data ISO 13485 & Policy...

Hope you guys can help me out with this Background: I am trying to build an activity manager for my sales team. Each one of them will hold a standardize template in which then they will update their appointments and then saved into a general folder. I then want to consolidate my entire team's...

Hello...I would like to find a way in Excel to create a button that will copy from a textbox in an open MS Access form into an Excel field. Lets say for arguments sake the location of the database is C:\Test\Test.accdb, the form is called TestForm1 and the textbox is named TestTextBox1 and I...

I am having issues with the following Macro. Little bit of information. I have a workbook called '2015 Stats' and all of my Officers compile a 'Patrol Log' and save it to a folder. they save it in the format of the date and their last name (i.e. 05-12-15 Smith). I succeeded in getting the macro...

Hi Guys, I'm trying to copy data from a sheet in a workbook to multiple workbooks. I've tried the following code to copy the data to one file, but don't know how to loop through and apply to multiple files. I need to copy the data from Source workbook to Destination1/2/3 and so on workbooks...

<tbody> Product Product code Product Description Quantity price each total price a.product dropdown a.code a.description 1 £3.99 £3.99 vat total </tbody> Hi there, I am looking to create a script, will copy and paste the first row of products, then paste that into the...

Hi all, I've been able to put together the following code with the help of many post by other members. Problem: I need to modify the code to copy the same range of data from multiple sheets into a summary sheet which is located in a different workbook. I cannot get the following code to run...

I have a multi tab template which has been significantly revised. I need to migrate the data from about 500 files of the old template to the new one. This would involve copying and pasting multiple ranges from multiple tabs in old workbook to multiple tabs in the new workbook. (probably about...

Hello, I have a workbook with two worksheets, one with my raw data and the other for my final report. Without messing up my conditional formatting, I need to copy the data from the data worksheet to the final report. My problem is, I have some basic conditional formatting from cells B2:B49...

I have 2 workbooks, Book1 and Book2. on Book2 I'd like to click a button that will copy info from Book1 and paste it ito Book2's "Cover" sheet. In Book1: the info that I want is in column E. This info is 0 to 20 five digit numbers (concatenated from an earlier action), all separated by at least...

The point of this workbook I'm creating is to make an ugly system-generated report look nice. The user pastes the report onto the first page, then clicks a macro button that does everything. "Everything" includes deleting some columns to make it line up correctly, then copying and pasting the...

Hi i wrote this code but it doesnt work as i expected. Can someone please help me solving it? There are 366 sheets in my workbook, namely "Sheet1", "1", "2",...,"365". In "Sheet1": <tbody> A B 1 Day: 1 2 3 </tbody> What i want to do this copy all cell in sheet1 and paste it to the...

Hello all! Quick question about Pivot Tables and their layouts. I have data in a pivot arranged in rows with the Employee name, followed by the hour of day (a filter trick we had to use) then an activity. So the format looks like this Employee Name Hour of Day Activity...

Hi - I'm old to programming but very new to VBA. I'm using Excel 2010 and have a pretty functional routine. Where I'm running into trouble with opening a 2nd file, copying a column, pasting the column to the original file (from which the code is being executed) and then closing the 2nd file...