ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel-update spreadsheet, keeping integrity (https://www.excelbanter.com/excel-discussion-misc-queries/55811-excel-update-spreadsheet-keeping-integrity.html)

KP

Excel-update spreadsheet, keeping integrity
 
I frequently receive an updated excel spreadsheet from our corporate office.
I've added a column to sort for local purposes. The concern being the
addition of rows by corporate so highlighting, copying, and pasting would
corupt my column by throwing off the alignment of the data.

Any suggestions on easily updating the information without "reinventing the
wheel"?

exceluserforeman

Excel-update spreadsheet, keeping integrity
 
It is not clear, to me, (and I am a bit dim) as to why you copy and paste to
your "column" apart from " to sort for local puposes"?

You need to spell out exactly what you do and why, wothout revealing the
name of your bosses dog!


"KP" wrote:

I frequently receive an updated excel spreadsheet from our corporate office.
I've added a column to sort for local purposes. The concern being the
addition of rows by corporate so highlighting, copying, and pasting would
corupt my column by throwing off the alignment of the data.

Any suggestions on easily updating the information without "reinventing the
wheel"?



All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com