Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet
for the experts..I have 50 excel spreadsheets sent to me monthly...subject to
increase..I need to combine all the data from these spreadsheets into one..currently..I open each once and copy/paste...is there anyway to automate this process? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet
More information needed.
1. Is the data all copied into a new workbook or worksheet each month or is it appended to existing data in an existing worksheet? 2. Is the format of the data to be copied the same in every worksheet? Is it a specific number of columns and rows or perhaps a specific number of columns with varying number of rows? 3. Further to question 2, what is the criteria for selection of the data to copy? Is it always the same range on each sheet? Can the data be copied and pasted in one go or are there several copy, paste routines required? 4.What is the criteria to paste the data? Does it all go on one sheet consecutively one under the other or on separate sheets? 5. How much data is there on each spreadsheet sent to you? Is it too much to provide a sample on this forum? 6. Are you looking for someone to write the code for you or do you simply want some ideas as to how to go about doing it yourself? Quite likely there will be more questions but your answers to these will be a good starting point. Regards, OssieMac "MsCarter" wrote: for the experts..I have 50 excel spreadsheets sent to me monthly...subject to increase..I need to combine all the data from these spreadsheets into one..currently..I open each once and copy/paste...is there anyway to automate this process? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import excel spreadsheet into an excel spreadsheet | Excel Worksheet Functions | |||
In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |