Phoenix - Your AI AssistantCreation of a very simple Excel Macro for combinding sheets by columns
- Posted:
- Proposals: 4
- Remote
- #1216132
- Awarded
have already sent a proposal. Description
Experience Level: Entry
Estimated project duration: 1 day or less
Hello
I need a way to move data from each SHEET within an Excel WORKBOOK. The data is contained within the same column in each sheet but needs to be moved onto a new sheet with the data organised in a column by column approach.
This will need to be an excel macro and is a very simple job to do for someone who can do it.
The document attached is an example, we need COLUMN B from each sheet to be copied into a new sheet but pasted in on a column by column basis rather than all into one row column (this is what the existing consolidate function does in Excel).
I need a way to move data from each SHEET within an Excel WORKBOOK. The data is contained within the same column in each sheet but needs to be moved onto a new sheet with the data organised in a column by column approach.
This will need to be an excel macro and is a very simple job to do for someone who can do it.
The document attached is an example, we need COLUMN B from each sheet to be copied into a new sheet but pasted in on a column by column basis rather than all into one row column (this is what the existing consolidate function does in Excel).
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi, So basically you'll like to have a VBA macro able to copy all the data in the column B from every sheet to a new sheet as column B from 1st sheet as column A in the new sheet, column B from 2nd sheet as column B in the new sheet, column B from 3rd sheet as column C in the new sheet, ... column B from 10th sheet as column J in the new sheet, etc...? Thanks, Tom