|
|
#11
03-01-2017, 06:41 PM
|
|||
|
|||
Hmmm... a couple of those questions didn't get interpreted the way I had hoped.
1.) How are you determining what original data row to copy? In order to automate everything you need to know where to start, what row? What is it that determines this? How can this be logically used in a macro? 2.) Why are you doing all this? It's great that you're a nice guy, but what I was trying to get at was why do you take things from one sheet to another and back again? an example as to why I ask... the move back and forth could be replaced by this if you knew what the row is and if it could be manipulated in place. Code:
With Sheets("Sheet1").Rows(7)
.Copy
.Insert shift:=xlDown
Application.CutCopyMode = False
'now do the manipulation
End With
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| pivot not showing number format with commas | olybobo | Excel | 1 | 05-05-2016 05:09 PM |
 Counting Blanks in 1 Column and Non-Blanks in Another
|
dogwood705 | Excel | 4 | 02-07-2015 08:45 AM |
| Commas within fields in .csv files | gar | Excel | 1 | 01-29-2015 09:24 PM |
|
How to use mid or left functions to seperate city,st,zip with no commas
|
sinaranje | Excel | 4 | 11-11-2014 10:52 PM |
|
No inverted commas in word 2013.
|
tonycrossley | Word | 3 | 01-27-2014 04:55 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode