Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Insert missing date/merge two spreadsheets

  Asked By: Adalicia    Date: Aug 28    Category: MS Office    Views: 782
  

I need some help again.
Now I have a spreadsheet has data looks like this but much larger
(about 200 rows and 10 columns)
Date B C D
1/2/08 2.1 2.2 2.3
1/4/08 1.1 1.2 1.3
1/7/08 1.2 2.1
1/30/08 1.3

What I need is like this:
Date B C D
1/1/08 2.1 2.2 2.3
1/2/08
1/3/08
1/4/08 1.1 1.2 1.3
1/5/08
1/6/08
1/7/08 1.2 2.1
.
.
.
1/30/08 1.3

I want the 'Date' column with all date in some time period (like from
1/1/08 to 12/31/08)

Is there any easy macro can do this?

Share: 

 

6 Answers Found

 
Answer #1    Answered By: Ziza Mizrachi     Answered On: Aug 28

Not sure what we're looking at.
Ah... are you saying that you want to
fill in the missing  dates?

Are you using the sub we wrote that
uses Dictionary items?

 
Answer #2    Answered By: Fairuzah Alam     Answered On: Aug 28

Yes. I used that one. It worked perfect. Thank you so much for
helping that out.

For this one. Yes, I want to fill in the missing  dates. But I also
need the missing dates before and after my data  sheet. Like I said in
my previous post. I need the date range from 1/1/2008 to 12/31/2008.

 
Answer #3    Answered By: Gerardo Morgan     Answered On: Aug 28

ok... is this the same project?

the reason I'm asking is that with that macro, you've stored the data  using
the date as a "key".

How do you want to establish the start/ending dates?
User input? or hard-coded?

As soon as my macro is finished, I'll throw together something for you.

 
Answer #4    Answered By: Kawakib Mansour     Answered On: Aug 28

This is not for exact the same dataset, but similar. They both have
same column 'date'. Other variables are not the same. I just ramdonly
choose number 2.1 2.2, etc. as simple sample:)

The data  will have a specific starting/ending date which I don't know
now. So I think it might be better to establish them through user-
input.

 
Answer #5    Answered By: Julia Hughes     Answered On: Aug 28

OK, that simplifies things.
So, the parameters are:

User inputs starting/ending dates.
Macro reads data  and stores in Dictionary using date as key.
Starting with starting date, the date is entered in column A,
and if data exists in Dictionary, it is entered in B-??
Sound right?

How many columns contain data?
What kind of data? strictly numeric? Alpha-numeric?
what about special characters? underscores(_), colon(:),
pipe(|)??

 
Answer #6    Answered By: Scarlett Hughes     Answered On: Aug 28

Each row contains different number of data. I think it's up to 20 or
so columns but most of rows may only have less than 10 columns.
The data  are strictly numeric (only number and dot).

 
Didn't find what you were looking for? Find more on Insert missing date/merge two spreadsheets Or get search suggestion and latest updates.




Tagged: