Moving Data In A Database

Mar 15, 2007

I've "lurked" around the board for a few days now, and I've gotta say this is the most helpful excel forum by far. After wading through a tiny chunk of the thousands of threads on this board, though, I am still having trouble with coding a macro that will do what I need it to do. If it affects anything, I'm on Excel 2002 on Windows XP.

I am currently in a project where I have to go through a database, formatted as thus: ...

View 9 Replies


ADVERTISEMENT

Use TAB To Moving Another Cells And Save Database In Another Sheet

Jul 28, 2013

I have 2 sheet in Excel. Sheet1 I rename main page and Sheet2 I rename database. In my main page I use tab key to be moving from within 3 cells (B5,B6,B7) that are different to include data. How the data may be stored in sheet database. When we fill data in main page how to evacuate data to fill second data.

View 1 Replies View Related

Moving And Deleting Entire Rows Between Tabs In Workbook And Moving Them Back If Needed

Sep 23, 2013

I have an excel work book with 6 tabs. I would like to have Excel move an entire row from one tab to another tab (removing the row and inserting it in the other tab). I.e. Example I have a tab with items that are marked as "Open Actions" so if I were to change the drop down to close. Excel would move that entire row of actions to the tab with the "closed actions" and insert into the next available row. Now if someone were to come back at a later date say no it should be reopened than I would change the drop down to open and excel would move that row back to the open actions tab into next available row. I tried a PIVOT table and no good I played with few macro and not.

View 5 Replies View Related

Creating Images Database Where Pics Are In Excel Database

Mar 31, 2004

I am currently trying to create a database of products for my company. For each product I would like to include an image associated with it. I then want to have on another sheet a place where the user will click an error and be able to cycle through the products. As tehy cycle the associated image will pop up.

What I need to understand is after importing the image into excel, how do I associate that image to a cell so I can reference it in another sheet of the database. I am not concerned with how large the database will get, my pictures are quite small.

View 4 Replies View Related

Database Named Database And Return A Time In Column

Nov 7, 2008

I'm trying to lookup a database named database and return a time in column A, based on criteria in cells a1 and b1 on another sheet, A1 would contain a number and B1 would contain a day from mon-fri

eg of Database
A B C D E F G
10:00 5000 Mon Tues

11:00 5000 Wed Thur Fri

and so on

if a1= 5000 & b1=Wed
how can I return 11:00

I have tried index and match =index(a:a,match(a1&b1,b:b&e:e,0))

View 9 Replies View Related

Excel Data Using Cells Input To Filter Data And Producing Database Style Reports

Aug 6, 2013

Trying to use Excel Data List to create a database style report. IE. Originally blank sheet, which is only populated by data containing data matching "filters" input into cells ( say A1 & A2 )

I.e. A1 = Delivery week to be filtered by, and B1 Manufacturer Name

So if I type week "1" into A1 & Manufacturer "Microsoft" into A2, it will show a table only containing data Microsoft, Week 1, and associated data for those lines across the screen.

Week 1
Microsoft

PO number : Date Ordered: Address 1, 2 3 etc....

0011 01/01/13 Somewhere
0015 02/01/13 Anywhere
0213 05/01/13 Nowhere

I know this is much easier with a database, however my manager insists a database cannot be used, and it must be in a spreadsheet format !

View 3 Replies View Related

Excel 2007 :: Moving Data From One Worksheet To Another Keeping Data And Formatting?

May 5, 2014

I am working on a project that has 5 worksheets. I have been able to figure out everything else I need to do but this has me stumped. I have data in Sheet1 A6, that i want to place in Sheet2 A6, Sheet3 A6, Sheet4 A6 and Sheet5 A6 and keep data and formatting(BOLD AND UNDERLINE). So I change Sheet1 A6 and the other 4 sheets change also. I'm using Microsoft Excel 2007.

View 1 Replies View Related

Sum Database Totals But Only If 2nd Database Greater Than X Number

Oct 17, 2013

I've used a countifs, but I'm having trouble doing a sum in a similar way. I have 2 databases and I will try to explain below. I need the to sum the values of database 1 if the second database is >= 20. So the value I would expect on this example would be 900. I would also like to be able to highlight which ones are elliminated. Such as coloring the text red.

Database 1

Eric 100
Jenny 200
Gina 300
Doug 400

Database 2

Eric 18
Jenny 20
Gina 34
Doug 55

View 5 Replies View Related

Copying Data And Pasting Data To Update Database

Jun 3, 2006

I have a workbook with a database of 15 different products. We receive information with current prices for each of the 15 products on a weekly basis. This info comes in one single worksheet. I have created a different file with one worksheet for each product to track price behavior over time. I need to update these database everytime I get a new report. What I was trying to do is to develop a Macro to copy the data from a "Master" worksheet that includes all 15 products info to the respective worksheet for each product. Information is sorted in columns having the most recent date in the lowest column. I would need the Macro to copy the new data below the last price for each product. I would copy the data into the "MAster" worksheet, then run the Macro who would copy each row and paste it in its respective worksheet in the row rightafter the previous one.

View 4 Replies View Related

Add Data To A Database?

Oct 12, 2013

I have spreadsheets supplied by clubs to add data to a database. I am not a spreadsheet user,

Today I have a spreadsheet with the columns A to M repeated in the width of the spreadsheet.

How do I reduce that to one display?

View 7 Replies View Related

VBA To Get Data From Database.

Jan 15, 2010

I am trying to use an excel vba program to get data from a database and then use this data in my program. But i have no clue about where to start.

View 9 Replies View Related

Data Validation Rules Not Moving With Data

Feb 24, 2014

creating a spreadsheet for work which is almost working a treat Unfortunately, when a row of data moves from one sheet (Queries) to another (Archive), data validation is lost. Initially I thought I daidn't have it set up on the Archive sheet, but on moving it back to queries (by use of a macro) the validation is still not working. how to keep validation rules WITH data when it is moved please? I will upload my file when I get home from work....network restrictions prevent me doing it here!

View 8 Replies View Related

How To Sort Data In Database

Jul 8, 2014

I need to sort a database. In the pic you will see what i have and what i need to do.

example.jpg

View 3 Replies View Related

Add Data To Access Database

Oct 20, 2008

Is there a way for an excel macro to open a access database & import a txt file straight to access (without importing to excel first) & then executing some other code e.g. copy query results(which i already have code for)

View 14 Replies View Related

How To Get Data To Display Like Database

Nov 2, 2011

I have a database sheet with all the data, I want to make a query sheet that display the rows of data when I enter the data in the summary sheet. I have 2000 rows of data and about 24 in type(columns)

So if I enter in cell Hona and Miles 50, it will display all the rows in the database sheet that contain those data...so I assume I would have to insert some kind of formula, or is there a simpler way to do it with out VB/database...

Car Miles PriceGasColor
RaceCar 50 Over1.5Red
Honda 100 Over2.5Black
Lexus 200 Over 3.5Silver

View 4 Replies View Related

Moving Rows Of Data Into 1 Row

May 20, 2014

I'm essentially getting a lot of data at the moment, which has a few orders people have made on my website.

Essentially, think order id, address etc and then all the products the customer has ordered.

However, the part which includes what the customer has ordered creates multiple rows of data, with the order ids etc duplicated. What I need to do is consolidate this into 1 row. So to add additional columns instead of rows.

The reason fro this is I want to mail merge the data into an invoice and mail merges work of 1 line of data at a time. I've attached an example, any way to do this?

(Attached to this post / or linked here: [URL] ....)

View 1 Replies View Related

Moving Data To Another Cell

Dec 11, 2009

I have 3 columns Z, AA, AB. The heading for Z1 is “A”, AA1 is “B” and AB1 is “C”
In column Z2:Z2000, there is a mix of A, B’s and C’s. I want A to stay in Z1 column, B’s to goto AA1 and C’s to goto AB1, also I want this added to a macro that I previously created, so everything happens with one push of a button

Now for save, not sure if this is possible or not, if I can have this added to the macro as well that would be great. When I push my macro button, the file saves to “Dec (today’s date) DB (81).xls” The number 81 is the total count of A, B’s C’s, this # will change depending on how may A, B’s and C’s there are. I really hope there is a way of doing all this

BEFORE

A B C
B
A
A
B
C
C
C
A
A
B
C

SHOULD LOOK LIKE THIS

AFTER
A----B-----C
----- B.....

View 4 Replies View Related

Moving A Row Of Data Into One Cell

Dec 13, 2012

Essentially, there are two columns I am dealing with. One is "Sales Rep" and it lists all of the sales reps employed by the company. The other is "Zip Code" and that will list all of the zip codes that sales rep is responsible for.

Now, I have a row of data, all of those zip codes listed out, that each rep is responsible for, but my supervisor wants all of the zip codes listed in one cell, in that second column. Example: (02018, 34098, 16711).

The commas are not necessary, but is there any way to get this done other than manually entering them?

View 6 Replies View Related

Moving Data With VB Code

Jul 24, 2007

I have a workbook with 5 Tabs. One of these tabs is "Completed" (for completed work) The other tabs are names of Managers and the tabs contain information about who is doing what work for the Manager and information about it.

What i would like to do is in column F on every sheet is the "status". I would like when the "status" is changed to completed, to have VB code move that entire record to the Completed tab.

I think its possible i just don't know how to do it.

View 14 Replies View Related

Macro For Moving Data

Sep 1, 2007

I need to move a lot of data from what was originally a txt document into an easily readable form.

I have used Macro's before but only for very basic routines (so please treat me as a bit dumb when it comes to Macro’s).

I have Include Screen shot of the data highlighted in a colored box and the relevant colored cell I need to move it into.

This needs to be repeated many times with data that is consistent in its layout.

View 12 Replies View Related

Moving Matching Data Into The Same Row From Different Ones

Jul 21, 2009

what im basically trying to do here is to move XYZ from column B and 123 from column C to match up with XYZ in column A ....

View 7 Replies View Related

Moving Data Between Two Userforms

Aug 6, 2009

I am trying to do what I have quoted below. In particular,I have the two userforms set up so that I open one and then click a checkbox that opens the second userform. I would like the data I enter into a texbox in the second userform to populate a text box in the first.


Originally Posted by dominicb
Good evening scott92

Sounds like you want to dump the contents of textbox1 into a public variable and force textbox 2 to pick them up from there. You might have a problem deciding exactly when textbox2 is to update - ie what event you're going to hang it from. Are both userforms visible on the screen at the same time? is the updating to take place in real time?

HTH
DominicB

View 5 Replies View Related

Moving Data From Spreadsheet A To B?

Jan 31, 2012

i need to move data from a speadsheet (that is open) to

P:SharedAgentsAdmin TeamAvrils TeamSamuel Kinver-WrigleyEscalations ManagementSIOXTeamNew SIOX beastFOR GRAPH PURPOSES.xls

So all the data in the open workbook is in a sheet called "move sheet".

So first to move:

A1:D13 to the workbook address above in sheet "admin" but it needs to look for the next available row in col. A to paste the data.

then

A15:D27 to the workbook address above in sheet "Outgoing (Cust.)" but it needs to look for the next available row in col. A to paste the data.

View 5 Replies View Related

Moving Data From One Sheet To Another

Jul 11, 2012

What vba code would I use to move data from rows a and b in sheet 1 to sheet 2. preferably with a button if possible.

View 2 Replies View Related

Moving Data From One Workbook To Another

Jan 18, 2014

I have two workbooks and wish to extract data from the first workbook (second tab), and insert certain cell data into a specific cell in the second workbook (first tab).

The first workbook has this info:
SN
SN
Sort
P/N
Removal
Customer 1
Customer 2
Program
Rec Month

ABCD1234
D1234
1234567899
Scheduled
Customer A
Customer B
Block 10
Nov-13

[Code] .......

This is a very large data set. The S/N will appear multiple times. The rest of the data will change with each entry, but there are some exceptions where it may be the same.

The second workbook has this data:
ID
S/N
A
B
P/N
Born-on-Date
Date Rec
Ship Date
Customer 1

123456
ABCD1234
1 thru 14
Yes or No
1234567899
03/10/2007
11/07/2013
11/22/2013
Customer A

[Code] .......

This too is a very large data set. What I need to do is to find the S/N in the first table "based on the month" and replace the entry under Customer 1 with the associated Customer 2 data entry. The VLOOKUP function can't seem to handle the multiple S/N entries.

View 1 Replies View Related

Moving Data To A New Cell.

Apr 12, 2007

I have cut and pasted a large amount of data onto a spreadsheet. The problem is that I have two rows of data that is associated with one another, so lets say A1 has a name and A2 contains that person's age. This process repeats in the same way in A3 and A4 and so on.

I need to move the data from A2 to B1 without using a simple function like =A2 in B1. The reason is that I will need to sort just the Names in column A once I get the the data moved. I am not sure how to do this.

View 3 Replies View Related

Moving Data Between Sheets

Apr 9, 2009

I have one very large piece of data located in one worksheet that I use across ten other worksheets. I simply copy and paste this data into each worksheet each morning after the data has been refreshed. Is there any way to be able to simply have my master sheet update and then get coppied to all of my other sheets?

View 9 Replies View Related

Moving Old Data By Months

Sep 4, 2009

I have 6 rows of data with 12 columns. The first row of data consists of the 12 months and the order changes with the current month -1 listed first. The first column of data is updated from a separate sheet. When the first column is updated I would like the old data to follow the month it was originally listed under until that month becomes the first month again.

View 9 Replies View Related

Lookup Moving Data

Nov 9, 2006

I have a spread sheet made by a former employer, if i enter a charge code in I4 it give me a price, the fomula is =(VLOOKUP(I4,boq,4,FALSE))*H4 the 4 after boq is the row the price is in. h4 is the amount of that item I have done, the problem I have is that my client has now changed the way we charge them, if I do 1 to 5 of an item it is one price, if I do 6 to 25 its a lower price, if I do 26 to 100 it lower still. I have added the prices for 6-25 in line 5(e) and 26-100 in line 6(f), what would the formula be so vlookup looks in the line depending on the value in H4. ie if h4 = 1-5 look in line 4. if H4 = 6-25 look in line 5 & if H4 = 26-100 look in line 6.

View 9 Replies View Related

Moving Data To Another Sheet If

Jan 26, 2007

using visual basic on excel and im after some code for a macro to be assigned to a button in a workbook that will do the following task:

1. In sheet "Main Page" Select rows between A4 and D100 that have anything in column C.
2. Copy the data in these rows and paste them in sheet "Invoice Page" in rows below and including 4 without leaving any empty rows, although there might be rows that dont contain data in column C in the first sheet where they are being copied from.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved