VIsual Basic Data Entry EXCEL

Hey guys

Newbie to Trade2Win with general EXCEL experience. My boss has landed a nasty whopper on me vis-a-vie VB and EXCEL.

There are two independent s/sheets. One is a simpe data entry type form where users will enter 2 dates. These two dates are then fed to s/s no,.2 and used to populate a Pivot Table.

1. How to trap the two dates?
2. Hot to feed them to workbook no. 2?

Any help greatly appreciated.

Little Sis

Little Sis said:

Hey guys

Newbie to Trade2Win with general EXCEL experience. My boss has landed a nasty whopper on me vis-a-vie VB and EXCEL.

There are two independent s/sheets. One is a simpe data entry type form where users will enter 2 dates. These two dates are then fed to s/s no,.2 and used to populate a Pivot Table.

1. How to trap the two dates?
2. Hot to feed them to workbook no. 2?

Any help greatly appreciated.

Little Sis

Click to expand...

If Sheet 1 is the data entry and Sheet 2 is the pivot table would it not be just a simple matter of putting=Sheet1!A1 in the Cell of Sheet 2 that needs the date?

eg/ If Cell A1 of Sheet 2 needs A1 of Sheet 1 then =Sheet1!A1 goes into A1 of Sheet 2

(Although I could just be talking a load of sheet)

new_trader said:

If Sheet 1 is the data entry and Sheet 2 is the pivot table would it not be just a simple matter of putting=Sheet1!A1 in the Cell of Sheet 2 that needs the date?

eg/ If Cell A1 of Sheet 2 needs A1 of Sheet 1 then =Sheet1!A1 goes into A1 of Sheet 2

(Although I could just be talking a load of sheet)

Click to expand...

I should add that the format is =[sheet name]![cell]

That is to say if the data sheet is named 'data' then the reference would be =data!A1

The best thing to do is to type an '=' sign in the cell of the sheet you want to import the data, then whilst the cell is still active, click on the sheet, then into the cell you want to get the data from, then hit enter.

Little Sis said:

Hey guys

Newbie to Trade2Win with general EXCEL experience. My boss has landed a nasty whopper on me vis-a-vie VB and EXCEL.

There are two independent s/sheets. One is a simpe data entry type form where users will enter 2 dates. These two dates are then fed to s/s no,.2 and used to populate a Pivot Table.

1. How to trap the two dates?
2. Hot to feed them to workbook no. 2?

Any help greatly appreciated.

Little Sis

Click to expand...

You could always use a user form to capture the dates, and then write these to the second spreadsheet (eliminating the need for the first).

There's a good tutorial at www.contextures.com/xlUserForm01.html

its pretty simple, most people with basic excel experience can follow it. We use data forms for all excel data entry, there's just too much chance of users getting it wrong otherwise.

Thnaks for the reponse(s) but..

the files/qorkbooks are independent so let me try again

A block of data is dumped from an indepdenent system in to a work book
Another indepdent workbook copies this data
Adavanced filter to sort this for the dates entered
The data for these requested dates is dumped to a pivot table which is then printed.
End user who uses the system sees a scren with three boxes
Inport Data
Refresh Summary
Print Report

MAcros are working but how can data be used to limit dates for those user requests. I have been looking ar a macro to run advanced filter but am having difficulty converting data entered t a usable form - any other suggections.

With much appreciation,

Little Sis

To anyone who replies to this query, I presume you will charging the company the appropriate rate?

Grant.