Align vertical data horizontally while copying previous columns along

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Align vertical data horizontally while copying previous columns along

FAQ

Thread Tools

Display Modes

01-28-2019, 04:47 AM

Sokkenpop

Windows 10 Align vertical data horizontally while copying previous columns along

Office 2016

Novice

Join Date: Jan 2019

Location: NB, Netherlands

Posts: 7

Hi Alpha,

in sheet1, i have 3 columns with additional info that doesnt need to be copied over (to the right of all the dates in sheet1 (columns Q, R, S)).

However, running this macro will also copy these columns over, ruining some of the Sheet2 output and mismatching the results.

does this macro continue to the rightmost column? where can i edit the code to rule this out?

regards,

Sok

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vertical Text Alignment with Adjacent Columns	kdutrisac	Word Tables	2	06-26-2017 12:38 PM
Copying specific columns of a table to WORD and deleting rows	ffinley	Word VBA	5	12-07-2015 04:01 PM
Copying and pasting values with unequal data columns	grexcelman	Excel Programming	5	12-05-2014 11:36 AM
Vertical align to bottom of cell when row wraps to next page	lausianne	Word Tables	3	02-28-2014 05:20 PM
Copying data from sheet with deleted columns creates blanks	ZGreyArea	Excel	1	11-20-2013 10:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:31 AM.