Pivot table or Macro?
I was asked to manage space in many warehouses. I have was wondering
if I was better of using Pivot tables or Excel Macros. Someone must of
gone through the same situation. I have to say that I am more familiar
with coding macro programs but I am open about learning more on Pivot
table! (or both). Any suggestions regarding this matter?
You really need to explain what "manage space" entails. This just really
isn't enough info to supply a meaningful answer.
If this helps, please click the Yes button
"Bobby" wro...Deselecting records in pivot table automatically
I have a file with over 51,000 rows. I need to pivot the data to get
at 3 different conclusions. I can pivot, but I need to further filter
the pivot and I'm having problems figuring out how.
My headings and some sample data:
Dist_Nbr Customer_Acct_Nbr Customer_Number Bill-to_Company_Name
7510 60000100 600001 SUMTER PACKAGING CORPORATION 00
4611 60000200 600002 A SMOOTH MOVE LLC 00
7170 60001200 600012 DOCUMATION INC 00
7170 60001201 600012 DOCUMATION INC 01
0684 60008300 600083 DOCUMATION INC 00
>From this I need 3 lists and I already pivoted the report.
One list gives me...compare
I have been reading this group for a while, however I am quite a
rookie in using of excel. I would appreciate if someone could help
with this issue.
I quite often have to compare two sheets (from different
workbooks-files, but with the same sheet name). Calculations are thus
updated time by time and I need to check where were the main
differences. Cells contain both values and formulas. I have found
through this newsgroup nice add-ins of Myrna Larson and Bill Manville,
and Rob Bruce. However I would need the macros to highlight only
significant differences (let's say fro...Compare two files and update data from another file base on words in a cell separated by commas
I have two file with several colomns. I need to compare two Col B
fileA Col B of FileB as shown in example.
Each col have about 1000 rows.
Each row contains thousands of words and phrases separated by Comma.
As you can see from example, my data has soo many words and phrases
separated by comma in each row of two colomn A and B.
i Need to merge data of corresponding row from COLA$FileB TO
corresponding row of COLA$FileB
Also merge data of corresponding row from COLB$FileB TO correspondin...How to Freeze the Pivot Table
Is it possible to Freeze the Pivot Table Data? I would like to give the
table data only. The raw data will be delete to min. the size.
Thanks a lot!
Just select the whole table
I'd clean up all the stuff I needed to first. (removing subtotals is easier
while it's still a pivottable.)
And just a hint.
Copy that worksheet with the pivottable first. Then when you screw up the
formatting, you can start over with the already existing pivottable--you don't
have to start from scratch.
Alan Tang wrote:
> Is it p...APA Style Table in Excel
Is there a way to left align digits in excel and still have decimal places
Left align the cells.
In article <s0Gsb.email@example.com>,
"Dan" <firstname.lastname@example.org> wrote:
> Is there a way to left align digits in excel and still have decimal places
> in line?
> Instead of:
I have got 2 workbooks with a list of names. I need to find out if a name
appears in both books.
One of the workbooks came from a different source and the other one is a
report I ran from our database.
I need to find out whether the workbook from out of the company has got any
of our own names on it.
I am using Microsoft Excel 97 and am fairly new at this so please be gentle.
One way I did think was to combine the two workbooks into one and find the
duplicates but thought there may be another way.
Hi "queen on",
Assume that In book1 the names are in column A, s...Notes table and IndirectDataInput / Date stamp in Memo field
I am trying out the previous suggestions for a solution regarding time/date
stamp in a memo field. Both are very interesting.
In the case of a separate Notes Table…how do I transfer the current memo
field to the memo field record in the new Notes table? My database resides
900 records with memo fields…
Thankful for advice!
You will need a foreign key in the Notes table that tells you, for every row
in the notes table, which is the row in the main table that the note belongs
You need to extract both the notes and the PK of the record for each note.
Use a query to do...Comparing
I have two columns of numbers column A could be up to 3500 rows. Column B
may be more or less than 3500 rows. What I'm trying to do is see if any
number in columns "B" appears anywhere in Column "A", and if so we can just
highlight it in both columns. Actually I would want to be able to sort by
highlighted. so maybe add someway to sort by matched or unmatched.
I hope this makes sense.
In column C put...
=IF(ISNA(VLOOKUP($A1,$B:$B,1,FALSE)),"Not in B","In B")
In column D put...
=IF(ISNA(VLOOKUP($B1,$A:$A,1,FALSE)),"Not in ...locked table error
I am trying to open a report via a control button on a form. The form is
based off of tblCustomers and the report is based off of a query which
includes tblCustomers (I think the problem is due to that).
The error I'm getting is "Run-time error '3211': The database engine could
not lock 'tblCustomers' because it is already in use by another person or
The db is local so I'm the only one using it right now.
Any suggestions on how I can fix this problem?
have you tried closing that form before the report is open; as a sanity check?
eve...I need to compare to columns and indicate the matches in another
am wanting to compare 2 columns for exact matching. If there are two
matching items I want to be able to say "A match" in a chosen cell for all
the ones that match. Column C will be retrived in an random order... so how
would I write the formula for that?????
A B C
A match 11tune 89time
A match 123ABC 123ABC
If possible include how to highlight the ones that make as another option.
Try something like this:
For a value list in B1:B5 and a ...Pivot Table report discarded in Excel 2003
When I open an Excel workbook in Excel 2003, I occasionally get the message:
"Errors were detected in file 'path\Accounts.xls'
"The following is a list of repairs:
"PivotTable report 'PivotTable1' on '[Accounts.xls]Analysis ex VAT' was
discarded due to integrity problems.W"
I note there appears to be a fix for Excel XP (SP3) but I can't find a
solution for Excel 2003. This problem did not occur with Excel 2000.
A solution for Excel XP was to turn off auto-recover, but I don't want to do
I don't understand how aut...Advice on comparing data sets
Can anyone advise on how I can compare data on 1 sheet with dat
compared on another. Example attached.
I want to be able to show that whenever the UK is shown (can appea
multiple times) on this sheet it checks on sheet2 and enter th
corresponding band value in this case for the UK (show in cells B6, B8
will show band A
Ref Country Band
As always thanks for your help.
|Filename: ...Conditional Lookup Table?
In another database program I've used for years, you could set up a
conditional lookup table without any programming. For example, if Field A has
2 choices, "Corporate" and Individual", then the lookup table for Field B
would be based upon the choice in Field A without writing any code. In other
words, if the user enters Corporate in Field A, then the corporate lookup
table would be available for Field B. And if the user entered Individual in
Field A, then the Individual lookup table would be available for Field B.
Can I have Access select the correct lookup t...Where can i find a football/Soccer table template to download?
I need a blank template, so that we can fill in the team names, and one that
add's up the socres etc.
...Compare and delete row
I need some help - I need to compare a cell, let's say A1, that wil
contain a date. I need Excel to compare it to today's date, if it i
over 60 days, I need it to go ahead and delete that row. If not, I nee
it to leave alone.
Thanks in advanc
Message posted from http://www.ExcelForum.com
If IsDate(Range("a1")) = True Then
If Range("a1").Value > Date + 60 Then Range("a1").EntireRow.Delete
Regards Ron de Bruin
"intheway >" <<email@example.com...Pivot Table for Inventory Database
I have an inventory database that has separate fields for receipts and
dispersements. How can I make a pivot table to show the part numbers, the
receipts and dispersements and a running balance?
Have a look at the PivotTable info on Debra Dalgleish's site.
Scroll down to "P" section.
Gord Dibben Excel MVP
On Tue, 22 Mar 2005 19:54:19 -0500, "ridgerunner" <&firstname.lastname@example.org> wrote:
>I have an inventory database that has separate fields for receipts and
>dispersements. How can I make a pivot tabl...comparing cell
i have a spreadsheet that contain a column of name (some the same and some
not) and would like to place each name in a row acroos the top of the same
Smith Jones Brown
First insert a heading above your column of names.
Then Data>Filter>Advanced Filter mark the source as your column of names.
Choose copy to another location and choose a detination cell on the sheet.
Select Unique values only.
Having got a unique list of names, copy this list and Paste
Special>Transpo...Error message when using Pivot Table
I get an error message when I try to manipulate a very large Pivot Table. The
message says "Excel cannot make this change because there are too many row or
column items. Drag at least one row or column field off the PivotTable or to
the page position. Alternatively, right click a field and then click Hide or
Hide levels on the shortcut menu."
I can't even figure out how to execute the remedies in the error message! I
can manipulate other Pivot Tables from other ss just fine. And my colleagues
have no trouble with this particular very large Pivot Table--just me. Is
this a...compare side by side
Using WindowsXP-Media Edition with Service Pack 2 and Office 2003.
When I choose the "compare side by side" option, my two workbooks appear one
above the other rather than side by side. Am I missing something??
>>Am I missing something??
I commented on that to MS during the beta test. They ignored me!
"BK" <email@example.com> wrote in message
| Using WindowsXP-Media Edition with Service Pack 2 and Office 2003.
| When I choose the "compare side by side" option, my two workbooks appear ...Report Writer
I have GP 8.0 and am trying to add the Customer PO# to
the report POP Purchase Order Blank Form. I found the
knowledgebase article that tells you how to create a
relationship between table Purchase Order Line TEMP and
table SOP_POPLink and then with table Sales Transactions.
But when I go in my Report Table Relationships window I
can't find table SOP_POPLink when I click New with
Purchase Order Line Temp highlighted. All I see is table
Item Master when I believe there should be table
SOP_POPLink as well. I have verified that the
relationships are showing up within the respectiv...Comparing Excel Spreadsheets
Ok, got one I can't handle..
I have one of two scenarios. Either I have 2 Excel workbooks, or 1
workbook with 2 worksheets..
Either way, I have 2 one Column data sets.
I need a way to look at the data sets and find what is missing
Data 1 = 1 2 3 4 5
Data 2 = 1 3 5 6
Results = 2 4 6
Does anyone know how to do this?
...PIVOT TABLE IN EXCEL 2007 #2
I want create a pivot table using an external database. I can do it but the
list of column data appears all in column A instead of column B, C, D etc.
How do I get the data into columns with its appropriate headers?
Have a look here:
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"sid" <firstname.lastname@example.org> wrote in message
>I want create a pivot table using an external database. I can do it but the
I would like to compare a calculated time in my work sheet vs. the actual
system time. For example, if the caculated time is >than or = to the system
time I want excel to tell me to "CALL", if not then "REST"...any help would
Put your calculated time in a cell (say A1) In B1 put =NOW()
in C1 enter =IF(A1>=B1,"CALL","REST)
"Eddie Munster" wrote:
> I would like to compare a calculated time in my work sheet vs. the actual
> system time. For example, if the caculated time is ...Table Import
I am trying to grant permissions to a user to access the Table Import
utility through Advanced Security. When I go to grant the permissions from
Menu >> Tools >> Integrate the Table Import has a yellow question mark and
not a check box. Is there anything that I need to install?
The By Menu section of Advanced Security shows the menu structure, but it
can only control menu items which it can directly associate to a form. It is
just a nicer view into the By Dictionary mode. The Yellow question mark
specifies that the menu choice is not associat...