Excel question ?

[Steve]

Hi, can anyone help me out with this ....

I have excel 2003 table and sheet inside of it have some formulas.
I would like to paste text data from notepad to that sheet without of
erasing any of the containing formulas which are like I said already there.

Thanx

 

[Cimjet]

Hi Steve
You could create a textbox from the ">View >Toolbars > Drawing menu, then paste
your information in it.
The textbox can be size and position any place on your sheet.
HTH
John

 

[Steve]

Hi Steve
You could create a textbox from the ">View >Toolbars > Drawing menu,
then paste your information in it.
The textbox can be size and position any place on your sheet.
HTH

My sheet is using some kind of a vlookup function and if I add some data
to any of the fields it automatically search through other 2 sheets.

But when I tried to paste text data from the notepad, it automatically
deleted that vlookup function on the sheet 1. Not much experienced in
this so didn't know how to avoid this deletion.

 

[Clif McIrvin]

My sheet is using some kind of a vlookup function and if I add some
data to any of the fields it automatically search through other 2
sheets.

But when I tried to paste text data from the notepad, it automatically
deleted that vlookup function on the sheet 1. Not much experienced in
this so didn't know how to avoid this deletion.

When you add data from the keyboard, you are entering data into cells
that do not contain formulas. Excel knows enough (depending on option
settings) to automatically copy formulas down into new rows if you are
adding new data below a list. I don't know that pasting new data below a
list will automatically copy formulas down into the new row.

My other guess is that when you are pasting data from the notepad (do
you mean the data is coming from Notepad, the program?) Excel is using
up more cells than you intend when it pastes the data from the clipboard
and replaces formulas with data.

If that is the case, you might try File | New and paste the data from
the clipboard into the new sheet ... then copy and paste only the
specific cells that you actually need.

 

[Cimjet]

Hi Steve
You can't have both, formula and text in the same cell.
Beside a Textbox, information from my first post; if you want information
attached to a cell. Select your cell,right click and choose >Insert Comment. The
information can be paste in the comment box.
Both method will not affect your formulas.
HTH
John

 

[Steve]

Hi Steve
You can't have both, formula and text in the same cell.
Beside a Textbox, information from my first post; if you want
information attached to a cell. Select your cell,right click and choose
Both method will not affect your formulas.
HTH
John

Had it like that before.
Table was separated into 3 sheets.
1st sheet was empty with 4 columns .... location number, item code, item
name and location long name.
2nd sheet already had filled whole inventory list, 3rd sheer had already
filled location names and their barcodes.

That table was loaded into pocket pc excel
(win ce) and I was doing yearly inventory in my company with that.


For example only 1st sheet is working sheet.. first column is location
(ex. IT room). After I marked first field and scanned location barcode
with it, sheet automatically recognized location and automatically
filled column number 4 with location long name.

After that I've marked 2nd field and scanned item barcode. Sheet added
scanned item code to that 2nd field, automatically recognized its full
name and added that text name to the 3rd field.

So I guess vlookup is using 2nd and 3rd sheet to recognize data and fill
up some fields on the sheet number 1 but I still have to scan location
and item code manually.


The problem is that I already have all scanned data from the last month
but only in text format (ex. items.txt). And I would like to add all
that data to that 1st sheet to make my job easier otherwise I will have
to scan manually 1800 items again which is a terrible job.

So when I try to paste all that into that 1st sheet, all vlookup
formulas dissapear.

I hope that it's not too complicated .. sorry if i can't explain it much
better.