Over 1 million tech questions and answers.

Excel 2007 right data wrong place

Q: Excel 2007 right data wrong place

We use a spreadsheet that is shared by many users.
Within the last couple of days the spreadsheet statred place the input data in the wrong cells.
Can you tell me the reason and how to fix it.

Preferred Solution: Excel 2007 right data wrong place

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel 2007 right data wrong place

Well, first we would have to know what the wrong place is.
- Are macro's being used
- Formatting
- etc.

Show a sample with fictional data showing the 'good place' and the 'wrong place'
Your info is insufficient

Read other 1 answers

OK, sorry guys it looks like I screwed up! not very computer savvy.
A while back... LONG while back, been putting off this issue, saved automatic backup in wrong place
woops! Looks like I need to fix that. Any tips so I don't delete the wrong thing?
here's the picture.

A:saved automatic backup in the wrong place... D-Data Drive :(

Looks like disk where you have saved your backups is doesn't have enough free disk space well you can either delete some files on the disk to gain more disk space or change the backup settings to start new backup on another disk i don't remember very well but if you move backups to new disk and change the currently backup location to new backup disk new backups should use the moved backups in new backup location.

Read other answers

I have an entire column of data that I need in one cell. When combined I need each piece of data to be surrounded by " " and a , between each one.


results = "151","183","2001"

A:Solved: Excel Column of data place in one cell with "data", "data" results

ASAP's "Merge row data" ("Columns and rows" category) will do 99% of the work for you.


(edit: "entire column" -- do you mean full from top to bottom? )

Read other 2 answers

Hi. I need excel to pull out certain information from a given column and row and display that information in another cell. I'll try to 'draw a picture' so you can see what I mean.

Column 1 Column 2 Column 3 Column 4
Row 1 10 10 15 12
Row 2 7 4 4 9
Row 3 112 12 30 15
Row 4 17 2 17 13

So what I need excel to do, for example is read column 3 and row 2 and pull out (and display) the number 4, or read column 4 and row 1 and pull out (and display) the number 12. Is this possible?


A:Excel 2007 Data Retreival

Please see my attachment for a clearer picture of what I want to do. Thanks.

Read other 2 answers

hi i have different match rate data for my different reconciliations.I want to show them on weekly basis comparison.Also as the data will be continuous so i just want to input data and the chart should refresh.I want to use pictorial depiction to make the data look good and sensible.Can you kindly help pls.thx

A:Excel 2007-Data Representation

do you have an example spreadsheet with dummy data in (remember this is a public forum, searchable by google)

and explain the data and show how you would like the end result if possible

Read other 1 answers

Hi I have one Excel sheet. As given in the attachement.

I want to filter data according to Resources.
Example: If i filter data for "Gold" it shold show the city / Country name for which value is 1. and hide all other city or country names which are having null value for Gold.
As show in the attachment.

Can any one please help?


A:Excel 2007 data filtering problem

hi ashvini_18

I don't think you can achieve what you want with the way the data is arranged.

I would have the Countries down the left hand side and the Metals across the top.
You can then apply a filter ('1') to each metal column which then only show the Countries that have thet Metal.
All of the columns will still be visible though although it would give you say Countries with both Gold and Zinc if you apply succesive filters.


Read other 1 answers

I have a spreadsheet with 2 simple colums: Price and Date. I'm trying to get a line graph showing how the price is moving over time (X=date, Y=Price). I have looked at several how-to videos and tutorials on how to chart/graph in Excel 2007, and I believe I'm creating the chart correctly. But the data doesn't graph. Most of what I try gives me the last price point ($580,000) as what seems to be the label of the Y axis and then all $0.00 plotted along the bottom of the graph, no dates appear at all.

All I can think of is that the cells aren't formatted correctly and the program can't see each cell as a value but as more like text. I have tried formatting the cells as currency and longDate, but to no avail. Is there anyone who would be willing to take a look at my sheet and tell me what I'm doing wrong?

A:Excel 2007 Data not Charting Properly

Ok more info: When I manually retype the cell values in two new columns and use the new columns to make my chart, it works exactly the way I want it to work. Please don't say I have to retype all the data because I have like 1000 points. Is there a way I can "scrub" the data I imported and get it to be formatted correctly so it will work as if I typed it in manually? Can I export it to CSV and reimport it? Can I copy/paste it to Notepad or something, one column at a time? How about RTF? Argh I really don't want to retype everything.

Read other 3 answers

Hi All,

i want to compare data between two work sheets of one workbook and if data matches then it will be copied to third work sheet automatically. can some body help me.


A:Comparing data between two sheets excel 2007

Read other 16 answers

Is there any way to have query data (from SQL Server) pulled into Excel 2007 without being in a "table". This is garbage. If I try to get rid of the table setup it dumps the query. This was not the case with 2003. In 2003 It pulled in where I told it to but was not formatted into a table. If I run my query based spreadesheets in 2007 that were written while still using 2003 they function fine. If I write them while in 2007 I get the table BS associated with the return. Not many 2003 machines left in our company!! Thanks

Read other answers

I have an Excel 2007 spreadsheet that is displaying the top 2500 rows of data that is constantly coming into a database table.

I have a chart next to it that charts the data.

The range of the data series of the chart is A1:A2501, which makes up 2500 rows, which is fitting.

The problem is that if I right click the data and refresh, it does so, but the chart will then shift its series down for some reason.

So for example, if 5 new data records come in on at the top on the refresh and 5 old ones drop off the bottom, the chart will update its series range to A6:A2506, even though there are no data records after 2501.

I tried locking the references by using $A$1:$A$2501, but that didn't work.

Any suggestions?

Read other answers

Good Morning! (from the UK)

I have created a spreadsheet which has many hardcoded target values, and where you enter an actual value manually for the correct 'Initials', 'Quarter' and 'Product' (these are the 3 set variables which are controlled by drop down lists on the worksheet to ensure data validation - the lists [or nameranges] were defined in another sheet). The 4th column is a value called Actuals, where the user would enter the actual value (as mentioned).

I'm trying to create a userform, which essentially lets you select the Initials, Quarter and Product, and then you enter the Actuals value in a text box and press a button, which automatically adds it to the correct cell in the spreadsheet.

I'm fiddling around with vba but my knowledge is pathetic, and googling the answer has left me even more confused!

Any help would be greatly appreciated

Thank you!


A:excel 2007, userform for entering data

Hi there, I think the links below will be able to offer the necessary infromation to help you some:

Let us know if you get stuck

Read other 1 answers

Hi Everyone,

I'm in need of some assistance with excel. I'm in the process of starting a hobby business producing food products. In order to get my costs exactly correct I want to use a spreadsheet.

I have a master price list as a data source, I then want to create a separate sheet for each product I intend to produce. What I want to do is select the products from a drop down list on each product sheet and have the price for each product imported into the product sheet.

I have attached what I have done so far. On the Master Price List sheet, I want to use the ingredients list in column A as the drop down list in the Product sheets. On the product sheets, once an ingredient has been selected I want that to automatically populate the price per gram (column C) from the corresponding column from the Master Price List (column I)

I'm sure it's a relatively simple request but I'm really struggling to get my head around it, any assistance would be greatly appreciated.

A:Excel 2007: Importing data from one sheet to another

I'll take a look -

Read other 2 answers

My company is using SAP as our production software. When I download data from SAP into Excel 2007, numbers are not showing correctly. Colons are where periods should be, and numbers that had 3 decimal places showing are now showing 15 decimal places with a colon instead of decimal. Help please.

A:data imports error in Excel 2007

You have the option in SAP to set certain user defaults

Menu: system>user profile> own data. In here, you can specify some selections. When you download data from SAP, select unconverted as the file format and then use text wizard to import to excel. The delimiter is often a comma but sometines | (above my backslash key on my PC). Depending on which version of SAP you are using, R2 / R3 / R4, other options are available. Let me know how you go on and if this does not work, I can give you some other things to try? Which transaction are you using in SAP?


Read other 2 answers

Hi guys,

I have a raw data spreadsheet of 10 stocks' price with date. I would like to write a vba program that can read off the raw data, produce 1st column as the date and the next 10 columns as the stocks' price. If any date doesn't have at least 1 of the stock price, that date will be obmitted.

It would be greatly appreciated if you can guide me through this since I am pretty new to this vba programming.

Thanks a lot!!

A:Excel 2007 - VBA read raw data question

would you be able to post an example of the data - dummy - ideally in an spreadsheet attached here
so we can see the format of the raw data and how you want it to look

Read other 2 answers

Hi there,

I hope you can help. I’m about to start an internet business with a friend and get new price amendments from the wholesaler every couple of months.

What I want to know is;
We have around a 1000 products, the supplier has about 10,000 and they can supply us with an Excel doc every couple of months. Is there a way of finding out under product code which products have changed in price in our range of 1000 products, if I were to put one on one tab and one on another? We wouldn’t want to know about the other 9000 products, if this is possible?

Column A

Product code

Column B

Product description

Column C

Price Ex VAT

A:Solved: Excel 2007 data comparison

Read other 8 answers

My pivot is not refreshing off of changes to the original data. I understand you have to change the "number of items to retain per field" to none.. did that.
I have closed out of it and then reopened it .. still it did not change after a refresh.
Any ideas ? thanks in advance

A:Excel 2007 Pivot retaining old data and pivot not refreshing the new data

Hi, welcome to the board!

A lot of things could be going on here, so I'm not sure where to start. I would look at the data range which your table is pointing to, make sure it is the most current data. You can make your data source dynamic if you'd like as well. Look at the pivot table settings, namely the refresh settings. When does it refresh? On open? Every X minutes? Does it change if you manually refresh it? Looking at any 'wrong' numbers, what does it show if you drill down those figures? Is there any way you can supply a sample file? If nothing else we could try to recreate your data, but we'd need much more details.

Read other 3 answers

I do have a couple of questions and I'm just stuck since I do not know what to do.

1. How do I get tabs to be shown on spreadsheets, so you can switch between them by hitting the tab key?

2. How can I automatically tranfer information from one spreadsheet to another?

Hope someone can help me out.

Thanks in advance,

A:Excel 2007 - tabs on spreadsheets & transfer of data

Hi there,

By "tabs" do you mean worksheets? They show by default, but if you click on the Office Button (top left round office icon) then click on Excel Options, then click Advanced on the left, scroll down until you see the heading Display Options for This workbook, you can toggle (check/uncheck) Show Sheet Tabs.

As for your second request, it is very loosely formed and we are not able to give you an answer as it's not specific enough. You'll have to tell us what you're looking at doing, giving specifics about where your data is located and where you want it to go, also explaining the process you would like to achieve (more or less just describe the process you want to achieve, not how you think you want to achieve it).

Read other 2 answers

I have a file of names, e-mail-addresses, and phone numbers that I want to import to a spreadsheet. The file is actually in report form, and the appearance of evenly aligned columns is misleading because of the use of multiple tab characters.

I think I'm interested in either CSV or fixed-column format. As I see it, I can replace the tab characters with a single semicolon (the names have commas) for CSV input, or replace them with the spaces they represent for fixed-column input.

I'm looking for a clever method of accomplishing either of these, and I suspect it lies within the capabilities of Word, but I'll gladly accept any solution that works.

Read other answers

PC crashed, was using Windows XP and Excel 2007. PC techs installed Windows 7 and still have Excel 2007. I'm trying to install the Add-In tab with the data transfer (CWBTFXLA.XLL). Getting an error after I close out excel and open a new window. The error is saying the file is in a different format than specified by the file extension...blah blah. I go ahead and open it and it brings up a bunch of garbage in the spreadsheet. On the top line it says, "This program cannot be run in DOS mode."

1) Where's my Add-in tab?
2) Anyone else have this error and what to do?

Thanks for your time and help!!

Read other answers

Let's say I have data contained in Excel with each piece of data in an adjacent cell...

Name: Rank: SSN#:
Smith, John R SSG 123-456-7890

How would I take that information and merge it into a memorandum in Office, all in separate documents?

So say the memorandum looks like this:
Whomever it may concern,

Smith, John R., SSG, United States Army, 123-456-7890 has been certified blah blah blah blah


So if I had 50 names it would produce 50 documents or something?

Is that even possible?

A:Merging Data From Excel Into Word (2003 Or 2007)

I think you can use Mail Merge to do this kind of thing.

I'm guessing your spreadsheet is in the .CSV format?

If you are using 2003, I'm not sure what the headings are at the top, but with 2007 you need to choose the mailings tab and then select start Mail Merge.

Select the Wizard and you should then have an option somewhere down the line to import a data source.

After doing this you should be able to insert the merge fields which should look like <<Surname>> or something like that.

From this you should then be able to create a template letter and print all the records out.

Hope this helps,

Read other 7 answers

I have a couple of questions regarding the below code and the attached spreadsheet. What do I have to do to make this macro execute at the time indicated in col m of the spreadsheet? The dates are going to be different for each row.
Also how do I get cell data [a4] [h4] [g4] [m4] [n4] to populate from the worksheet into the email?

Sub Mail_small_Text_Outlook()
'Working in Office 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
strbody = "Andean Funding Closing Document has not been recieved" & vbNewLine & vbNewLine & _
"Andean Tracking Number: [a4]" & vbNewLine & _
"Requested Amount: [h4]" & vbNewLine & _
"Case Number: [g4]" & vbNewLine & _
"Closure Document Due NLT Date: [m4]" & vbNewLine & _
"Staff Coordinator: [n4]" & vbNewLine & _
"Please contact OGL immediately to correct this situation" & vbNewLine & vbNewLine & vbNewLine & vbNewLine & vbNewLine & _
"Judy De Santis" & vbNewLine & _
"Office of Global Enforcement" & vbNewLine & _
"Latin America Caribbean Section" & vbNewLine & _
"Office: 202-307-4609" & vbNewLine & _
"Cell: 202-345-9257" & vbNewLine & _
"Fax: 202-30... Read more

A:Excel 2007 -How do I get cell data to populate email?

Read other 6 answers

I work with Excel 2007. If under column A, I have 900 names of Restaurants, and under each name of restaurant, is a one-line address of the restaurant, what should be done so that the address can be moved to the cell to the right of the restaurant.

For example

This is the original data:

Column A
AAA Restaurant
AAA address
BBB Restaurant
BBB address
CCC Restaurant
CCC address
This is the desired result

Column A Column B
AAA Restaurant AAA address
BBB Restaurant BBB address
CCC Restaurant CCC address

Thanks is advance

A:Solved: Excel 2007 Move Data to Another Cell

Read other 7 answers

Hi there I was pointed in the direction of this site in the hope that I may get some help with a small problem. I have put together a fairly basic website that records scores for an online gaming event that I am hosting. The points given out go towards 2 sets of scores (an individual score and a team score) all of this is working perfectly. However what I could now do with doing is converting these 2 sets of scores into 2 league tables enabling us to update the website easily.

I am told the thing I need is something called a pivot table, but I have no idea how to set one up. Is there anyone who can help out here please.



Read other answers

Just wondering...
I have an Excel worbook with a number of pivot tables, which all draw their data from a single raw data Excel Table.
The user will use this as a template file - they'll paste the month's data into the raw data sheet and refresh the pivot tables.

In testing, some of (but not all) the filters were cleared when the data was removed to create the template file. That suggests that every month, after the user pastes in the data, they'll have to go and check / re-set all the filters in each pivot table. Each individual pivot table should have its filters set the same every month. This could be prone to user error (missing a filter), and as I have calcluations based on the pivot table results (thanks Bomb!), it could mess up the analysis, too.

The only thing I can think of at present is to include a worksheet(s) containing static checklists of the items that the pivots should be filtered to, and getting the user to follow these.
Is there no way I can set default filters, regardless of how much data there is (even if there is none), so that the user doesn't have to go through each filter on each pivot table and check them every month?

A:Excel 2007 - Setting pivot filters when there is no data

Gram said:

Excel 2007 ...Click to expand...

I'm out. ()

Read other 1 answers

I am working on an Access DB written by someone much cleverer than me who has use a lot of SQL which I find hard to interpret. It is a DB of client info and order info. I exported the Client Table to Excel so that I could more easily sort out the data (separate name fields into Title/First Name/Last Name, for example) and then I wanted to import the cleaned data back into the Access DB.

I renamed the existing table as Client Original and I successfully imported the new table giving it the samename as the original used to have so that there wouldn't be any issues involving queries etc which relied on it unbeknown to me.

I needed to add a field from the Client Table to an Order Form but - to my surprise - the only table available to me was the first one which I had renamed as Original; the new one which had the old name wasn't seen by the Add Fields box - it is as if it doesn't exist (but it does!!)

I then tried to import into the Client Original table instead, but get the message that it cannot overwrite this table when I get to the end of the wizard. There are no relationships at all involving the Client table (and when I show the Client Original table on the relationships screen it's name is given with _1 at the end of it which isn't in the name I gave it .) I am thinking that the guy who wrote the DB has something hidden in the SQL somewhere which is stopping me from being able to overwrite this table.

Has anyone got any ideas please?

Many tha... Read more

A:Access 2007 - will not overwrite existing table with Excel data

Read other 11 answers

...hope I named the thread right.

Good day everyone. This one thing in Excel has been driving me crazy for a couple of hours now. I've looked all over the internet trying to find the solution and still couldn't. Hoping to find the solution here. otherwise I might stay up all night tonight, trying to make this work

so I'm putting together this custom spreadsheet for my own little needs. let's say I have A1, B1 and C1 cells. in the C1 cell I want to display "1" if the numbers in A1 and B1 are equal and they are not equal then display nothing. so the formula I'm using is


and is there are any numbers in A1 and B1 excel interprets everything just fine. but if if there are no numbers yet, it takes two empty cells as having the similar data and still gives me "1" in C1 cell. so how do I make so that Excel does not execute the IF formula before I enter the numbers in A1 and B1. or is there another of of not getting the "result" before actually putting in the numbers?

hope that someone can help me with this thing.

A:Solved: Excel 2007, stop IF formula if no data entered.

Read other 12 answers

Hi all

I'm hoping an Excel 2007 guru can help me out.

I work for a medium size company and am stumped with a current problem I have open. I'm starting to think that the "problem" is by design.


An Excel 2003 (.xls) file is saved on our network,
All of the staff now use Office 2007, or in this case, Excel 2007.


Here's where it gets messy.

The staff tell me that under Office 2003 one person with write access to the folder share could open the Excel document and make some changes whilst leaving it open. Another staff member with read access to the folder share would then open the Excel document and be able to click "Refresh data" to see the updated data as the the person with write access was saving. Essentially, one person had it open to make changes, another person had it open (in read only I think) and would click "refresh data" from time to time to see the updates. Does this make sense?

Now they tell me they can no longer do it. If they try clicking the data tab and "Refresh All", nothing happens.

My question is, can an xls file be opened by one person in write mode whilst others open it in read only mode with a view to refreshing the data as the "writer" makes and saves changes?

Any comments or suggestions welcome.


A:Excel 2007: Refreshing data when two users have the same file open


Read other 3 answers


A quick explanation of how this is setup -
A cell (C2) has the data "01/01/2012 07:23" (in the format CUSTOM ("dd/mm/yyyy hh:mm")

A formula =CEILING(C2,30/1440) rounds this to the nearest half hour and places it into cell F2 (in this case 07:30:00), in the format TIME.

The issue is, cell F2 still contains the date (01/01/2012) and all I want in F2 is 07:30:00 - so I can see how many of these events occur across the sheet at 07:30. However I've not been able to strip just the time from the original date field (C2).

Any ideas how?
I've tried using =RIGHT(C2,5), which gives me 88889 (in the format TIME). If I try and convert this to custom (HH:MM:SS) it doesn't work!?

A:Excel 2007 Use RIGHT function correctly to strip unneeded data away

works for me in excel 2003 == see cell C6 in attached file

I just custom format

or are you looking for something else

if you want just the text and not the date any longer

but i dont think that will help you

Read other 1 answers

Me again!

I have a line chart in Excel (not area!). Just two lines zig zagging along. I need the area between the two to be coloured in. But just that area. How would I go about doing that?

Also! How would I go about adding a scrollbar to it, so that I can only see five points on the x axis at a time?

Thanks a million!

A:Excel 2007: Shading Between Data Series in a Chart, Scrollbars

Read other 12 answers


I use excel 2007 for goods that I sell to calculate costs profits etc. Sometimes I have multiple suppliers of a product.

Is there a way in which I can have prices for say 3 suppliers and merge adjacent cells
that will have generic data valid for all 3 suppliers such as size colour etc but then also be able to filter results without getting an error.

At present because cells to the left or right are not the same size it will not filter and I cannot think of another way to do it.


Cells A1,A2,A3 are merged and contain the name of the product and cells B1,B2,B3 have the 3 supplier names. Because adjacent cells are merged filtering is not possible or is it?

If not can someone with good excel knowledge advise a different approach?

A:Excel 2007: Data filtering issue due to merged cells

i've been thinking about your post since it first came on.

There are a few things i thought of.

Firstly it may just be that you cannot have merged fields and filter the info.

Secondly COuld you have one row for each product and then three columns for three suppliers rather than seperate rows.

The other things i thought about would be if you unmerged the cells. Then used Pivot tables to display the data maybe.

Alternatively Access rather than Excel but im a database geek so i would say that.

I know this is probably not much help but as no one else responded i thought i should give you my thoughts

Read other 2 answers


Ok, here´s my problem. I have a report that I need to make several times a month. To do that I need to get data from a certain BI application that generates huge amounts of data. After that I need to make a pivot from that data and then select different fields from the fields list. Occasionally, I need to use different fields and it is a pain in the a** to find the correct fields, since the BI fields (there are a LOT) are not alphabetized and I can´t change the order of columns there.

So, is there a way to order the fields in the field list in any way?

Thanks, in advance!

A:Is it possible to rearrange data in excel 2007 pivot field list

Hi, welcome to the forum.

If you select the entire sheet before you create your pivot tabel you can sort from left to right
That way the header row, which contains the fieldnames will de alphabetically sorted.

Try it with the Data Sort and options.

I just tried it under Office 2003 and 2007 adn 2010 have the same options.

Read other 3 answers


Here's the deal

I am linking through excel 2007 to an access 2007 DB Query (with columns A & B).
Column A & B show correctly in excel I have added a third column C, to calculate the running sum of A&B
C1 = Running Sum
C2 = (A2+B2)
C3 = (A3+B3)+C2
C4 = (A4+B4)+C3
C5 = (A5+B5)+C4
C6 = (A6+B6)+C5
...and so on and so forth...

Now I hit the refresh external data button and ......$%##!!!
Suddenly Excel in all his wisdom decided that he feels the need to edit my formula...
Now it reads as follow:
C1 = Running Sum
C2 = (A2+B2)+C1 //the "+C1" is automatically inserted by Excel & results in a Error
C3 = (A3+B3)+C2
C4 = (A4+B4)+C3
C5 = (A5+B5)+C4
C6 = (A6+B6)+C5
...and so on and so forth...

How do I kill this bug?

A:Solved: Excel 2007 - Formula Error After External Data Update

The problem is that when you refersh you must have chosen to clear the table so your formula is lost.
What I usually do is refresh and the then have it run a amcro afterwards that reinserts my column with my needs.

Read other 2 answers

I've got two different spreadsheets in Microsoft Office Excel 2007 that rely quite heavily on graphs. Now, the issue I'm having isn't stopping the practical functions of the spreadsheet, but it is aesthetically frustrating.

Each time I access either spreadsheet, some of my graphs data labels reset their formatting and styles. Approximately 75% of the data labels remain as they were originally formatted, but approximately 25% of them reformat themselves each time. I correct it by formatting them the way I'd prefer, and I re-save, but the next time I open the spreadsheet they've gone back to their default state.

Now, this is only the formatting, not the content of the data label, but it is still frustrating.

Can anyone please give some advise as to how I can fix this?

A:Graph Data Labels Resetting In Microsoft Office Excel 2007

Is anyone able to help me with this, please? It's such a frustrating issue.

Read other 1 answers

Hi everybody,

I upload an excel file to help understand my problem.
So I have date and time and in column 2 I have my parameter value.

Note 1) not all the data is at 04:30:00, and this is a huge problem in the macro I found online.

1-1-16 0:00 1
4-1-16 4:30 1
8-1-16 4:30 1
11-1-16 4:30 1
15-1-16 4:30 1

What I want to create is the missing data time, associated with a column 2 blank and not 0 if possible

So the final result should be like
1-1-16 0:00 1
1-1-16 0:01 "blank" (not zero if possible)
1-1-16 0:02 "blank"
4-1-16 4:30 1
4-1-16 4:31 "blank"

Thanks for your time

Read other answers


I am trying to build a harvest data sheet for wildlife management implications and I cannot find out how to auto-populate data from the initial sheet to separate sheets based on the entry in one specific column.

Let me explain the data sheet in more detail; I have the initial sheet set with @16 columns containing harvest information for individual animals and broken up by individual properties. (Property "X", followed by date, age, weight, sex, etc. in columns for each specimen harvested).

Now what I would like to be able to do; I would like to enter the data under each property the first time and have three other sheets auto-populate, i.e. #1-total data set not divided by property, #2-all males, #3-all females, based on the entry in the "sex" column-'M' or 'F'.

I hope I have made the problem clear enough to understand. I know there must be a way to do this. Please help! Thanks!

A:Excel 2007 Question: How do I auto-populate data to inidividual sheets?

Read other 7 answers

I have an excel spread sheet that pulls data from multiple seperate sheet to then consolidate them into a single table that then uses a pivot table to pull together a 'class' list of everyone starting a set classs on the same day and venue with their contact details on including a phone number. For 1 person on the list the pivot table has added an additional 2 to the end of the phone number.

I have checked the original spreadsheet, the consolidated sheet and neither of thiose has the extra digit in it only shows on the pivot table.

The pivot table is set up with tabular layout so you get 1 line per person who meets the filters set to class start date and venue and i have checked that the column on the pivot table is formated the same all the way down.

Does anyone have an idea how the extra digit arrived and how i get rid of it? I have over trypwed the original data on the colsolidated list with some thing differnt and refreshed and then put the content back to the refernce cell and the extra 2 re appears - all very confusing

A:Solved: Excel 2007/2010 Pivot Table data error

Very hard to trouble shoot this on written notes. To find this... I would try moving/adding the person to another class. I would also try pivoting on class members and see how this entry appears. If still an issue I would make this thing with only the offending records and associated records. Excel usually doesn't make this stuff up.

In reality I would send this off and call it done!

Read other 3 answers

Hi all,

I am trying to develop a cost calculator based on several drop down lists. I have used the following formula:

=AVERAGEIFS('Scope Of Work'!I:I,'Scope Of Work'!C:C,C6,'Scope Of Work'!F:F,'Cost Calculation'!D6,'Scope Of Work'!G:G,'Cost Calculation'!E6)

Cells C6, D6 and E6 in the Cost Calculation Tab are all drop down menus based on data validation. The formula works when all 3 cells have a selection value but I also want it to calculate if only one or two of the drop down lists have been populated, any ideas?



A:Solved: Excel 2007 - Dynamic formula based on Data Validation List

Read other 11 answers

Hi everybody

I have got an hourly meteorological data for 10 years. The problem is that some of the data entries are missing. e.g.

23-April-2006 19:00
23-April-2006 20:00
23-April-2006 22:00
23-April-2006 23:00

I need to insert the rows for missing hours. Rest of the columns in the inserted row are needed to be blank. e.g.

23-April-2006 19:00
23-April-2006 20:00
23-April-2006 21:00
23-April-2006 22:00
23-April-2006 23:00

Please also note that for some years, the data entries are for half past hours. e.g.

31-Dec-2001 23:30
01-Jan-2002 00:30
01-Jan-2002 01:30
01-Jan-2002 02:30

Muhammad Zeeshan

A:Solved: Inserting rows for Missing Date/ Time data (Excel 2007)

Read other 16 answers

I am trying to hide rows of my worksheet that show a date in the completed column.
The orders that are complete have a date in column F up to this point I highlight them green so I know they are completed but it would be nice if they highlighted green and were hidden when a date was entered into the completed column.
Can someone assist me with creating a macro that will do this?
I am very new to macros so please forgive my lack of knowledge.

I have attached a sample of what I am doing however inf has been changed.

I am using Excel 2007

Thank you,

A:Solved: Macro for excel 2007 to hide rows based on any data entered in a column

Hi, welcome to the forum,

I put some simple code in the Sheet's vba

Make sure you allow macro's to be run

Just enter a date in the last row of column F for testing.

For the other green rows, just click in column F and update the date by retyping it

Read other 3 answers


I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.

So that the excel size won't be that big and also it saves processing time.

A:Solved: Access data export into Excel as the data linked to excel.

Read other 16 answers

The ?problem? I?m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb.
I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit.The W700 has Office 2007 and theW541 has Office 2013.Both versions ofExcel are 32 bit as far as I can tell.
Until recently I was primarily using the W700ds but have nowswitched to the W541.

after I saw a larger file losing KB when saved, I did a test with a file that had not been altered or openedfor over two years. I copied it twiceand added a -1 and a -2 to change the names.The file was a small 832 Kb file.When I opened and saved on the W541 running Windows 7 with Excel 2013,the file saves with 771 Kb.When Iopened the file using the W700 running Windows 7 with Excel 2007, the computeron which it had originally been created, the file saved as 830 Kb.Both saved smaller but the newer computerrunning Excel 2013 was much smaller.Iam seeing these same types of ratios of reduction in size for much larger Excelfiles as well.

I have not documented any actual problems or loss of data withany of the files to date and I have used an Ultra-Compare text file comparison which found no differences.
Is there any reason to be concerned about this? And, if so, what to do?

As with many people, some of my files are the result of manyyears of work and I don't want to do anything to compromise any of the data butI don?t know whether or not what I?m seeing is normal due to both Excel 2007and Exce... Read more

Read other answers

but I need some help and I am sure you have all heard it.
The thing is
I can't log into yahoo mail but can go into everything else
can't go to gmail, bravenet.com or angelfire.com where my site is hosted. I worked on the site for 4 to 6 hours and now I can't check or do anything.

here is my log

thank you for taking the time to read this


Logfile of HijackThis v1.99.1
Scan saved at 16:56:36, on 21-Aug-2007
Platform: Unknown Windows (WinNT 6.00.1904)
MSIE: Internet Explorer v7.00 (7.00.6000.16512)

Running processes:
C:\Program Files\iTunes\iTunesHelper.exe
C:\Program Files\Corel\Corel Photo Album 6\MediaDetect.exe
C:\Program Files\Creative\Shared Files\CamTray.exe
C:\Program Files\Toshiba\TOSCDSPD\TOSCDSPD.exe
C:\Users\Lauren\Program Files\BitTorrent_DNA\dna.exe
C:\Program Files\Windows Media Player\wmpnscfg.exe
C:\Program Files\Last.fm\LastFMHelper.exe
C:\Program Files\Verizon Wireless\V CAST Music Manager\MEMonitor.exe
C:\Program Files\Mozilla Firefox\firefox.exe

R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = http://www.yahoo.com/
R1 - HKLM\Software\M... Read more

Read other answers

Hi all...I was goofing off on the internet today...went to my bookmarks and clicked on youtube....and it would not load! the loading bar was just 'going real fast' and never completly loading- just going real fast. Fearing it was some sort of virus or crash on thier behalf I closed it and came here to ask if any thing like this has happened before. you tell me please? I am also told by this site that I can recieve emails and comments through email so I will hope your answer come thru my email thanks! Moondiver

A:probably the wrong place to...


Welcome to TSF!!

If you think that you have a virus, follow these instructions and the folk the that forum will help you out.


Read other 2 answers

i guess i'm newer than i thought i was......a friend gave me a new monitor that is larger than my old one....so i have a lot of black screen ......wish i could fix this...if someone could help or redirect me, i would appreciate it....thank you

A:may be in the wrong place

The monitor you have now, as the old monitor you had, should have some buttons or knobs on the front of it. These are used to resize the image, adjust it's position etc. Try them out looking for the obvious such as a knob with an image that looks like it will stretch it etc. Also, you might want to adjust your settings to a different resolution. For example: 800X600, 1024X768 etc. To do that, just right click on an empty space on your desktop, select PROPERTIES, then left click on SETTINGS, then move the slider under SCREEN AREA. Hope this helps, T.

Read other 2 answers

My @ key is not with the no 2 I have to press the " to get it to work

Read other answers

I got broadband last week and we're only allowed 2GB monthly usage limit (hehe, well it is cheap). I was wondering if streaming videos counts towards this, like does it take up disk space? And is there any chance of viruses? Thanks, pretty random, but I'd like to know.

A:ok this is probably the wrong place, but...youtube


Yes that will count towards your 2GB monthly allowance...everything you get from the internet will count (emails, webpages, videos, music etc).

It does take up disk space but once you clear your temporary internet files, that will solve the problem.

As with the risks of internet use, there is a chance of picking up spyware/viruses by downloading content....but the chances are far less with reputable sites.

Hope that helps :)

Read other 7 answers