copy & paste from sheet

Hello so here is problem I have a masterworkbook(marcgoproject4.xlsm) it has five(5) sheets all has headers sheets name : sheet1=ADDITEM sheet2=ITEMLIST sheet3=RECEIVED sheet4=SHIPPED sheet5=STOCK now the problem is i also have a babyworkbook(in.xlsx) that gets updated regularly only has...

I want to copy a cell from an active sheet to a summary sheet using FIND. Just not hitting it yet. I found some code from DeBruin that may get me started. Once I copy the cell in the active sheet I want to scan a SUMMARY sheet where my value from the active sheet will be in Column A. Once it...

Hi, I am new to VBA. I am trying to do one thing regarding copy and paste. Here is my question. I want to count the number of values in the column A of sheet1 and want to paste them in the column D of Sheet 2 skipping 7 rows. pattern goes like: sheet1.A2 copy and pasted to sheet2.D2 sheet1.A3...

Hi, I am trying to write a code which will loop through all excel workbooks in a particular folder & copy data from a specific tab on each sheet and then paste it to a master excel workbook. I have got the code to select folder, extension, tabname basis inputs from user and also loop thru...

Hi I am sure for anyone with a modicum of VBA skills, this will be a sinch, but for someone like me who last tried macros using Lotus 1-2-3, I'm struggling. I would like to copy the values contained in 3 particular cells, A9, B9 and P9 from Sheet 2 of a spreadsheet to cells B2, B3 and D2...

Hi guys, Apologies for my lack of VBA skills but I'm having difficulty finding code to do the below. Basically I need a macro to copy and paste worksheets based on sheetnames from the master. For example I have the following: Master Spreadsheet with 5 worksheets named A B C D E I want to...

Hey guys, So I currently have a macro button that, when pressed, imports an entire table into sheet11 from a mySQL database. In the same workbook, I have an excel sheet1, that has many of the same columns as the new table in sheet11. I would like to get it where when the macro button is...

Hello, I have 2 sheets within a workbook, RawData! and View!. I want to be able to paste raw data into the RawData! sheet, and have specific data be references within certain headings on the View! sheet. My attempt to create a visual of what I want to do is below: RawData! sheet: The data...

Hi, I have found some answers to somewhat similar questions but none that fits my need and unfortunately I am not experienced enough with VBA to piece together a functioning macro from what I've found searching online so far. What I need to do is to create a macro that runs automatically once...

Hello All... I was wondering if someone could help me. I am new to excel, and has designed a worksheet to help me with my annual tax return as I am a self employed driver. I thought I had got my worksheet working fine, but its not the case. Its difficult to explain what I am after, but here...

Hi everyone, I'm looking to automate the process of repeating an excel worksheet (which is set up with various tables and formulas) for various countries. I have a referenced list of countries set up in worksheet 1. So for example: in worksheet 2 I have a sheet set up for Albania - and I want to...

Hi Guys, I need a macro which can do following thing. <colgroup><col span="17"></colgroup><tbody> Sheet1 Sheet2 Results in Sheet3 Column A Column B Column C Column D Column E Column A Column A Column B Column C Column D Column E AA X X X...

Hi everyone, I hope someone can help me with this. I had to copy rows from one excel sheet to another if required condition is satisfied. I have a set of rows containing many activities and each activity has a date and a code. What I need to do is to copy the rows that satisfies this...

So here is my issue. I have fumbled around multiple forums trying to find the answer. I am new to vba for excel and I have hacked together a macro from bits of code I found in these forums. It does what I need it to except for one caveat, the second part of the macro uses a set range but i...

Hi there All! So i have looked for a similar thread and can't find, so posting my own. here goes.... I have a database that I dump into an excel spreadsheet every 6 weeks after new updates get done to the db. So I have created a separate sheet in the workbook to make up a birthday list. So in...

Hello, I am trying to build a code that copy cells from non-contiguous ranges and paste the data on another sheet where the cells are contiguous. The ranges have more than one column but I just want to copy the data from one column (for example the first column). This is the code I have for now...

Hi everybody, I have a workbook to calculate costs and expenses of orders from different exports. Every week I receive 2 exports and put them in different tabs. Both the exports are not in the same structure so I modify one using an extra tab. And at the end I have 2 tabs exactly in the same...

I'm trying to find out if this is even possible. I am working on a spreadsheet that I am combining information from two other spreadsheets. If a column has a date listed (not blank), then I would like to insert the contents of a different cell (so I can do VLOOKUP on the remaining cells)...

Hello all, I am trying to build a macro where it allows me to copy data in Range(I3:I40) within master sheet where the data changes every day into a tracking file Range (the next available black column) so, into newsheet C4:C41 on day 1, D4:D41 on day 2 etc. i can never get the right column...

screenshot windows