different columns

Hi all, I am currently working in a spreadsheet with multible tabs, where the format is the same: a table where values (text) from column 5-row 3 (and down), column 6-row 3 (and down) and column 7-row 3 (and down) should be transferred into a PDF with a table consisting of the three columns...

Hi, I am hoping someone can help here, I performed a search but did not see a result specific to my issue. We are pulling data from a database with several columns. Column A has country and column B has a subsidiary. Unfortunately, due to a bug in the system the countries don't appear, so in the...

Hey Everyone, I have 1 data set with a bunch of columns, the ones needed for this question are Column H (header: Created, shows a list of dates when a specific request was created) and Column AK (header: Status, shows the status of the created request [i.e. Approved; Invalid; etc]) I need a...

Hi, I have a tricky situation I'm working through here and I'd appreciate some help. I have output from a program that converts pdf phone bills and makes a summary in Excel. However when there's thousands of bills these summaries sometimes need to be done in parts, say 1-2 thousand at a time...

I have nine columns of dates all columns are on the same sheet and right next to each other (e.g. A through I) Each column is not sorted because each date is derived through either a formula or a Vlookup, etc Each column represents a different set of dates...with each column being a different...

Hello, I'm new here so please forgive any naivety. I have about 100 excel workbooks that contain essentially the same types of data. Each file details plant collections of certain people and each plants corresponding habitat, date collected, locality, county, state, species etc. Yet they have...

I have two worksheets (Sheet 1 & 2) where column A on both worksheets has a list of codes. Some of the codes are duplicated on both worksheets. Some codes are unique for each sheet. I would like to create a DIFF on Sheet 3, Column A, that lists all of the like codes from sheet 1 and 2. On...

In Microsoft Excel 2010 how can you get a web query to refresh into the next column instead of the same cell? I'm trying to track the price of a share of stock by date and would like the fields to update themselves every single day. I've tried different things including writing out a seemingly...