datasets

Hi Folks, I'm in need of your expertise here:giggle: I have two data sets as follows : 1- Data containing all kinds of movements of fleet vehicles (including Business Trips, To/from workshops, test drives etc.) 2- Containing the info. on Business Trips with Locations (for business Trips only)...

Hi. I have a source worksheet with 8 separate datasets. I want the user to be able to indicate which of the 8 datasets they want to copy/paste from this source worksheet into the destination worksheet. I can write a macro that will allow the user to indicate one, several or all eight of the...

Hello ! Though I am a brand new member, I have been an unlogged user and big fan of MrExcel for a long time. Thank you all for countless good advices and tips I found here over time... As I am unable to find an answer to my question, here I am with my first request for help ! I need to build...

Hi All, I have a large data set in sheet1 which has ~20 columns and 10000+rows and each row has a set of limits based on what value is in column B this data set changes ~once per week. The limits are stored in sheet2 where column A contains the unique list of values from column B in sheet1 and...

I have got a very large dataset on which I need to perform some data analysis. There are roughly 100 variables but there are multiple iterations so in the end it is closer to 15,000 variables. I need a way to select just the variables with the same header in a new worksheet as that will make it...

Hi all, Hope someone can help :) I have sales figures for 2 different years. They are laid out as so; 2011 Sales <tbody> Country Volume Product Code UK 1000 100123 USA 245 100123 Germany 566 100124 Germany 201 100125 </tbody> This table is repeated for the next year, however there...

I have two spreadsheets that track data for costs/expenses. The first worksheet tracks data in this way: Months for an 18 month period across the top as headings with Location 1 Expense Categories (Hardware, Software, Interest, Contingency), Location 1 Capital Categories (Hardware, Software...

Hi, I would like to know if there is a way I can create a graph of the week from a big sample size that automatically updates itself every day. for examplesay i have this data: <TBODY> 8/30/2012</SPAN> 224</SPAN> 25</SPAN> 9/5/2012</SPAN> 224</SPAN> 25</SPAN> 9/6/2012</SPAN> 228</SPAN>...