View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tiptop[_3_] tiptop[_3_] is offline
external usenet poster
 
Posts: 1
Default updating spreadsheet

Hello all, I have a quick question. I have a spreadsheet that I nee
to have remain open in the background of another spreadsheet. I nee
to create a code that will take the info from a1 of the mai
spreadsheet and input it in a1 of the background spreadsheet. Th
tricky part that I can't figure out, is that if a1 on the backgroun
already has something typed in it, then I need it to put the info i
a2, so on and so forth. The background sheet is going to be updated o
a minute by minute basis.

IE.

SheetA.xls (in the background)
SheetB.xls (main screen)

MacroA takes the info from SheetB Cell A1 and puts it in SheetA Cell A
only if it's empty. If it has something in it already, then it need
to put it in SheetA Cell A2.

Any Ideas???

Thanks for all the help!

--
Message posted from http://www.ExcelForum.com