past

when I run this command I assume its trying to past every cell into B3. How do I just make it copy and past from row 12 to the last row then paste? Sub Copydata() Sheets("Data").Activate Dim lr As Long lr = Range("A" & Rows.Count).End(xlUp).Row For i = lr To 2 Step -1 Range("A12:M" &...

Hi, I have been battling to find anything online that can assist me. I have a sheet that has email addresses in them and need to Find each email address and generate a list of all email addresses and how many times they appear in the sheet. I can use an Array with FindNext but how do I get it to...

Hey Mr. Excel I have this Code seen below. The point of the macro is to past data from my source sheet to sheets with matching names with some cell values. I have the following sheet setup <tbody> R (Sheet names) S T U V W 5 Overview 2014-4 1 1 6 9 17 6 Overview 2015-1 6 0 3 12 21 7...

So I opened my mouth before I actually thought about it and agreed to write a "quick" bit of code for my group to use at work. I haven't really written any code for anything in close to 25 years, since college excel class oh so long ago... The Problem given a spreadsheet with hundreds of...

Hi guy's I am trying to copy from one sheet to another (Should have been easy) I need to copy from sheet Skill DB Current Month range (A1:E1) down to the last row and then paste this into Skill DB Archive into the next avaliable row. Any ideas? Thanks

Hi there, I'm new with VBA and walk through old post but can work it out myself, I need more practices. I want to copy values from one sheet to another if condition is met. I have a list on one column on sheet1 and another list on other column in sheet2(they might not be the same), anytime...

Hi, I'm trying to create validation for date field. As it stands, the validation makes sure the date is in the correct format, but it allows you to enter past dates. I need the date to be in the dd/mm/yyyy format and the date should be today or greater. No past dates. Can anyone help...

Hi, I am seeking a formula for cell B1 that will calculate the date one month prior to the date in cell A1. This becomes tricky because obviously not all months have the same number of days (February has 28, whilst April, June, September, November all have 30). If the date in cell A1 was the...